/// <summary> /// 更新单条数据 /// </summary> /// <typeparam name="T">表的实体类</typeparam> /// <param name="model">模型数据</param> public static int Update <T>(T model) where T : class { try { int rows = 0; using (var db = new DemoEntities()) { if (db.Entry(model).State == EntityState.Detached) { db.Set <T>().Attach(model); db.Entry(model).State = EntityState.Modified; } rows += db.SaveChanges(); } return(rows); } catch (Exception ex) { WriteException(ex); return(0); } }
/// <summary> /// 删除单条数据 /// </summary> /// <typeparam name="T">表的实体类</typeparam> /// <param name="model">模型数据</param> /// <returns>删除行数</returns> public static int Delete <T>(T model) where T : class { try { int rows = 0; using (var db = new DemoEntities()) { db.Entry(model).State = EntityState.Deleted; rows += db.SaveChanges(); } return(rows); } catch (Exception ex) { WriteException(ex); return(0); } }
/// <summary> /// 使用查询条件更新数据 /// </summary> /// <typeparam name="T">表的实体类</typeparam> /// <param name="action">更新数据动作</param> /// <param name="where">表达式</param> public static int Update <T>(Action <T> action, Expression <Func <T, bool> > where) where T : class { try { int rows = 0; using (var db = new DemoEntities()) { var list = db.Set <T>().Where(where); foreach (var model in list) { action.Invoke(model); db.Entry(model).State = EntityState.Modified; } rows += db.SaveChanges(); } return(0); } catch (Exception ex) { WriteException(ex); return(0); } }