/// <summary>
/// 获取网站横幅列表.
/// </summary>
/// <param name="bannerTypeCode"></param>
/// <returns></returns>
public List <Banner> GetBannerList(string bannerTypeCode)
{
using (MyBannerContext context = new MyBannerContext())
{
var query =
from data in context.Banners
where
// 指定分类.
data.BannerTypeCode == bannerTypeCode
// 数据必须是有效的.
&& data.Status == Banner.STATUS_IS_ACTIVE
// 已经开始.
&& data.StartDate <= DateTime.Today
// 尚未结束.
&& data.FinishDate >= DateTime.Today
orderby
data.DisplayOrder
select
data;
List <Banner> resultList = query.ToList();
return(resultList);
}
}
static void Main(string[] args)
{
// 当 Code First 与数据库结构不一致时
// 自动升级到最新的版本.
Database.SetInitializer(new MigrateDatabaseToLatestVersion <MyBannerContext, MyBanner.Migrations.Configuration>());
using (MyBannerContext context = new MyBannerContext())
{
var query =
from data in context.BannerTypes
select data;
foreach (var item in query)
{
Console.WriteLine(item.BannerTypeCode);
}
}
Console.WriteLine("Finish!");
Console.ReadKey();
}