1 public List<EntityDemoModel.News> NewList(int pagesize, int pagenow)
2 {
3 pagenow = pagenow - 1; //当前页的上一页(注意)
4 List<EntityDemoModel.News> list = new List<EntityDemoModel.News>();
5 using (EntityDemoModel.EntityDemoEntities1 ed = new EntityDemoModel.EntityDemoEntities1())
6 {
7 //包含外键表(注意),OrderByDescending按某个字段倒序排列,Skip() 获取指定索引的剩余记录,Take()取得指定数量的记录
8 list = ed.News.Include("NewsClass").OrderByDescending(p => p.id).Skip(pagesize * pagenow).Take(pagesize).ToList<EntityDemoModel.News>();
9
10 }
11 return list;
12 }