public void DeleteUser(User user) { using (var transaction = _dbContext.Database.BeginTransaction()) { try { var userPermission = _dbContext.UserPermissions.Where(it => it.UserID == user.UserID).FirstOrDefault(); _dbContext.UserPermissions.Remove(userPermission); _dbContext.SaveChanges(); var accountUser = _dbContext.AccountUsers.Where(it => it.UserID == user.UserID).FirstOrDefault(); _dbContext.AccountUsers.Remove(accountUser); _dbContext.SaveChanges(); _dbContext.Users.Remove(user); _dbContext.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw; } } }
public void Add(TEntity entity) { _dbContext.Set <TEntity>().Add(entity); _dbContext.SaveChanges(); }