public List <T> FindByProc(string SQL, params SqlParameter[] parameters) { using (var context = new KindeeDBContext()) { return(context.Database.SqlQuery <T>(SQL, parameters).ToList()); } }
/// <summary> /// 查找单个 /// </summary> public T FindSingle(System.Linq.Expressions.Expression <Func <T, bool> > exp) { using (var context = new KindeeDBContext()) { return(context.Set <T>().AsNoTracking().FirstOrDefault(exp)); } }
//KindeeDBContext Context = new KindeeDBContext(); // protected KindeeDBContext Context = new KindeeDBContext(); public int ExecuteSql(string sql) { using (var context = new KindeeDBContext()) { return(context.Database.ExecuteSqlCommand(sql)); } }
public IQueryable <T> Filter(System.Linq.Expressions.Expression <Func <T, bool> > exp) { using (var context = new KindeeDBContext()) { var dbSet = context.Set <T>().AsQueryable(); if (exp != null) { dbSet = dbSet.Where(exp); } return(dbSet); } }
public bool IsExist(System.Linq.Expressions.Expression <Func <T, bool> > exp) { using (var context = new KindeeDBContext()) { return(context.Set <T>().Any(exp)); } }