项目中所使用:使用EF可以将父子项全部加载进来,所以只是用递归将父子项放入list,反射加泛型使其通用。
一,实体:
public class Sys_city
{
public Sys_city()
{
children = new List<Sys_city>();
}
public int Id { get; set; }
[StringLength(100)]
public string title { get; set; }
[StringLength(20)]
public string zip_Code { get; set; }
public int? ParentId { get; set; }
public int level { get; set; }
public int sort { get; set; }
[StringLength(300)]
public string CityFullName { get; set; }
public string parent_s { get; set; }
public virtual Sys_city Sys_City { get; set; }
[ForeignKey("ParentId")]
public virtual ICollection<Sys_city> children { get; set; }
}
二,数据表: