/// <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(); }