我要做一个商城,其中商品分类实体要做成单表递归,怎么做才能实现。
如果要查询,我要怎么能一次就查询出整个表里的数据。
/// <summary>
/// 类别名称
/// </summary>
public string Name { get; private set; }
/// <summary>
/// 级别
/// </summary>
public int Level { get; private set; }
/// <summary>
/// 类别路径
/// </summary>
public string Path { get; private set; }
/// <summary>
/// 是否显示
/// </summary>
public bool IsView { get; private set; }
/// <summary>
/// 排序
/// </summary>
public int OrderBy { get; private set; }
/// <summary>
/// 类别实体(父对象)
/// </summary>
public virtual Category Parent { get; private set; }
/// <summary>
/// 类别实体集(子集合)
/// </summary>
public virtual ICollection<Category> Childs { get; private set; }