/// <summary> /// 真正删除 /// </summary> /// <param name="model"></param> /// <returns></returns> public void Remove(T model) { using (var db = new powerbjfEntities(conn)) { db.Set <T>().Remove(model); db.SaveChanges(); } }
/// <summary> /// 执行修改 /// </summary> /// <param name="model"></param> /// <returns></returns> public void Update(T model) { using (var db = new powerbjfEntities(conn)) { db.Set <T>().AddOrUpdate(model); db.SaveChanges(); } }
public void ExcuteSql(string sql) { using (var db = new powerbjfEntities(conn)) { db.Database.ExecuteSqlCommand(sql); db.SaveChanges(); } }
public void RemoveList(List <T> list) { using (var db = new powerbjfEntities(conn)) { foreach (var model in list) { db.Set <T>().Remove(model); } db.SaveChanges(); } }
/// <summary> /// 批量添加 /// </summary> /// <param name="listmodel"></param> public void AddRange(List <T> listmodel) { using (var db = new powerbjfEntities(conn)) { foreach (var model in listmodel) { db.Set <T>().Add(model); } db.SaveChanges(); } }