asp.net MVC使用EF框架进行分页
-
数据库以Roles表为例
-
控制器代码
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using Com.page.Models;
namespace Com.page.Controllers
{
public class UserinfoController : Controller
{
RbacDBEntities db = new RbacDBEntities();
// GET: Userinfo
public ActionResult Index(int pageIndex=1,int pageSize=10,string Name="")
{
var counts = db.UserInfos.Where(p => p.Name.Contains(Name)).Count();
var totalpage = Math.Ceiling(counts * 1.00 / pageSize);
var row = db.UserInfos.Where(p => p.Name.Contains(Name))
.OrderBy(p => p.ID)
.Ski