EF中分页的实现

一.控制器

using LLC.Models;
using LLC.Models.ViewModel;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace LLC.Controllers
{
   
    [AuthorFilter(IsCheck = false)]

    [UserCheckFilter]
    public class RoleController : Controller
    {
   
        TestDBEntities db = new TestDBEntities();
        // GET: Role
        public ActionResult Index(string Name = "", int pageIndex1 = 1, int pageSize1 = 10)
        {
   
           
            var totalRows1 = db.Roles
               .Where(p => Name == "" || p.Name.Contains(Name))
               .Count();
            var pageCount1 = Math.Ceiling(totalRows1 * 1.00 / pageSize1);

            var roles = db.Roles
              .Where(p => Name == "" || p.Name.Contains(Name)).ToList();
              var rows = db.Roles.Where(p => p.Name.Contains(name))
                .OrderBy(p => p.ID)
                .Skip(pageSize * (pageIndex - 1))//跳过
                .Take(pageSize)//取
                .ToList();//转化为集合
                
            ViewBag