public partial class LibraryManageEntities : DbContext
{
public LibraryManageEntities()
: base("name=LibraryManageEntities")
{
}

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
throw new UnintentionalCodeFirstException();
}

public DbSet<AdmSet> AdmSet { get; set; }
public DbSet<BookBorrow> BookBorrow { get; set; }
public DbSet<BookCase> BookCase { get; set; }
public DbSet<BookInfo> BookInfo { get; set; }
public DbSet<bookType> bookType { get; set; }
public DbSet<ReaderInfo> ReaderInfo { get; set; }
public DbSet<readerType> readerType { get; set; }
public DbSet<User> User { get; set; }
}

 

public ActionResult GetAllUserInfo()
{
int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]);
int pageSize = Request["rows"] == null ? 10 : int.Parse(Request["rows"]);
int total = 0;
using (LibraryManageEntities db = new LibraryManageEntities())
{
var temp = from u in db.AdmSet select u;
total = temp.Count();
var users = temp.OrderBy(s => s.Id)
.Skip<AdmSet>((pageIndex - 1) * pageSize).Take<AdmSet>(pageSize);
var data = new
{
total = total,
rows = users.ToList<AdmSet>()
};
return Json(data);
}
}