EF实现公共类

using System;

using System.Collections.Generic; using System.Data.Entity; using System.Linq;

using System.Linq.exxxxxpressions;

using System.Runtime.Remoting.Messaging; using System.Web; using EFModel;

using System.Data.Entity.Migrations; namespace Y_Web.Comm {

public class Comm where T : class new() {

private DbContext dbContext = Create(); public static DbContext Create() {

DbContext dbContext = CallContext.GetData(\ if (dbContext == null) {

dbContext = new Y_DBEntities();

CallContext.SetData(\ }

return dbContext; }

public bool Add(T t) {

dbContext.Set().Add(t);

return dbContext.SaveChanges() > 0; }

public bool Delete(T t) {

dbContext.Set().Remove(t);

return dbContext.SaveChanges() > 0; }

public bool Update(T t) {

dbContext.Set().AddOrUpdate(t); return dbContext.SaveChanges() > 0; }

public virtual T Find(obxxxxject key) {

return dbContext.Set().Find(key); }

public IQueryable GetModels(exxxxxpression> whereLambda) {

return dbContext.Set().Where(whereLambda); }

public IQueryable GetModelsByPage(int pageSize int pageIndex bool isAsc exxxxxpression> OrderByLambda exxxxxpression> WhereLambda) {

//是否升序 if (isAsc) {

return

dbContext.Set().Where(WhereLambda).OrderBy(OrderByLambda).Skip((pageIndex - 1) * pageSize).Take(pageSize); } else {

return

dbContext.Set().Where(WhereLambda).OrderByDescending(OrderByLambda).Skip((pageIndex - 1) * pageSize).Take(pageSize); } }

public bool SaveChanges() {

return dbContext.SaveChanges() > 0; } } }