public static bool RemoveUser(int id) { try { using (var db = new AdapterDbEntities()) { var user = db.User.Find(id); foreach (var role in user.Roles.ToList()) { user.Roles.Remove(role); } var membership = db.BusinessMember.Where(bm => bm.UserId == id); db.BusinessMember.RemoveRange(membership); db.Set <User>().Remove(user); db.SaveChanges(); } return(true); } catch (Exception ex) { log.Error("RemoveUser error", ex); return(false); } }
public static List <TPoco> GetAll <TEntity, TPoco>(Func <IEnumerable <TEntity>, IEnumerable <TPoco> > map) where TEntity : class { using (var db = new AdapterDbEntities()) { var dbList = db.Set <TEntity>().ToList(); var list = map(dbList).ToList(); return(list); } }
public static TPoco Find <TEntity, TPoco>(int id, Func <TEntity, TPoco> map) where TEntity : class { using (var db = new AdapterDbEntities()) { var dbObj = db.Set <TEntity>().Find(id); var obj = map(dbObj); return(obj); } }
public static TPoco Last <TEntity, TKey, TPoco>(Expression <Func <TEntity, TKey> > expr, Func <TEntity, TPoco> map) where TEntity : class { using (var db = new AdapterDbEntities()) { var dbObj = db.Set <TEntity>().OrderByDescending(expr).FirstOrDefault(); if (dbObj == null) { return(default(TPoco)); } var obj = map(dbObj); return(obj); } }