/// <summary>
/// 获取全部的区域列表.
/// </summary>
/// <returns></returns>
public List <AreaInfo> GetAllAreaInfoList()
{
using (MyAreaContext context = new MyAreaContext())
{
var query =
from data in context.AreaInfos
select data;
var resultList = query.ToList();
return(resultList);
}
}
/// <summary>
/// 获取子区域列表.
/// </summary>
/// <param name="areaCode"></param>
/// <returns></returns>
public List <AreaInfo> GetSubAreaInfoList(string areaCode)
{
using (MyAreaContext context = new MyAreaContext())
{
var query =
from data in context.AreaInfos
where
data.ParentAreaCode == areaCode
select data;
var resultList = query.ToList();
return(resultList);
}
}
static void Main(string[] args)
{
// 当 Code First 与数据库结构不一致时
// 自动升级到最新的版本.
Database.SetInitializer(new MigrateDatabaseToLatestVersion <MyAreaContext, MyArea.Migrations.Configuration>());
List <AreaInfo> dataList = new List <AreaInfo>();
using (MyAreaContext context = new MyAreaContext())
{
var query =
from data in context.AreaInfos
select data;
foreach (var item in query)
{
Console.WriteLine(item.AreaName);
dataList.Add(new AreaInfo()
{
AreaCode = item.AreaCode, ParentAreaCode = item.ParentAreaCode, AreaName = item.AreaName
});
}
}
// 输出 UTF-8 的 XML 文件.
XmlSerializer xs = new XmlSerializer(typeof(List <AreaInfo>));
using (StreamWriter sw = new StreamWriter("AreaInfo.xml"))
{
xs.Serialize(sw, dataList);
}
Console.WriteLine("Finish!");
Console.ReadLine();
}
