全国省市县城市数据大全（执行sql语句并带数据库表结构）

/// <summary> /// 行政区域 /// </summary> [Table("Base_AdministrativeRegion")] public class AdministrativeRegion { public AdministrativeRegion() { Id = Guid.NewGuid(); CreateTime = DateTime.Now; LastUpdateTime = DateTime.Now; IsDelete = false; } [Key] public Guid Id { get; set; } public DateTime CreateTime { get; set; } public virtual AccountInfo CreateUser { get; set; } public DateTime LastUpdateTime { get; set; } public virtual AccountInfo LastUpdateUser { get; set; } [StringLength(500)] public string Remark { get; set; } public bool IsDelete { get; set; } /// <summary> /// 名称 /// </summary> [Required, StringLength(500)] public string Name { get; set; } /// <summary> /// 行政区域别名，以顿号分隔 /// </summary> public string Alias { get; set; } /// <summary> /// 行政级别 /// 0-3全国 省 市 县 /// 当前数据库没有县级数据 /// </summary> public int AreaClass { get; set; } /// <summary> /// 排序字段 /// </summary> public int Sort { get; set; } /// <summary> /// 上级行政区域 /// </summary> public virtual AdministrativeRegion Parent { get; set; } /// <summary> /// 行政区划代码 /// </summary> public string Code { get; set; } }