/// <summary> /// 通过sql语句作为参数传递,返回集合 /// </summary> /// <typeparam name="T">实体模型</typeparam> /// <param name="wherestr">sql 语句</param> /// <returns></returns> public static List <T> GetListTowhereSql <T>(string sql) where T : class, new() { using (MyDbContexts db = new MyDbContexts()) { return(db.Database.SqlQuery <T>(sql).ToList()); } }
/// <summary> /// 通过sql语句作为参数传递,返回查询出的模型数据 /// </summary> /// <typeparam name="T">实体模型</typeparam> /// <param name="sql">sql语句</param> /// <returns></returns> public static T GetModelTowhereSql <T>(string sql) where T : class, new() { using (MyDbContexts db = new MyDbContexts()) { return(db.Database.SqlQuery <T>(sql).FirstOrDefault()); } }
/// <summary> /// 通过Lambda作为参数传递,返回集合 /// </summary> /// <typeparam name="T">实体模型</typeparam> /// <param name="wherestr">Lambda作为参数</param> /// <returns></returns> public static List <T> GetListTowhereExp <T>(Expression <Func <T, bool> > wherestr) where T : class, new() { using (MyDbContexts db = new MyDbContexts()) { return(db.Set <T>().Where(wherestr).ToList()); } }
/// <summary> /// 通过Lambda作为参数传递,返回查询出的模型数据 /// </summary> /// <typeparam name="T">实体模型</typeparam> /// <param name="wherestr">Lambda作为参数</param> /// <returns></returns> public static T GetModelTowhereExp <T>(Expression <Func <T, bool> > wherestr) where T : class, new() { using (MyDbContexts db = new MyDbContexts()) { return(db.Set <T>().Where(wherestr).FirstOrDefault()); } }
/// <summary> ///根据模型进行添加 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="model"></param> /// <returns></returns> public static bool InsertModel <T>(T model) where T : class, new() { using (MyDbContexts db = new MyDbContexts()) { db.Entry <T>(model).State = EntityState.Added; return(db.SaveChanges() > 0); } }