EF的分页查询

控制器代码

 public ActionResult Index(int pageIndex=1,int pageSize=10,string name="")
        {
   
            var count = db.Roles.Where(p => p.Name.Contains(name)).Count();
            var totalpage = Math.Ceiling(count * 1.00 / pageSize);
            var rows = db.Roles.Where(p => p.Name.Contains(name))
                .OrderBy(p=>p.ID)
                .Skip(pageSize*(pageIndex-1))
                .Take(pageSize)
                .ToList();
            ViewBag.name = name;
            ViewBag.pageindex = pageIndex;
            ViewBag.pagesize = pageSize;
            ViewBag.totalpage = totalpage;
            return View(rows);
            
        }

pageIndex：页面
pageSize：页面数据数量

---

index主页代码

@{
   
    ViewBag.Title = "Index";
}
@using fenye.Models
@model List