public void DeleteByCondition(Func <T, bool> expression) { foreach (var record in Context.Set <T>().Where(expression)) { record.IsDeleted = true; } }
private void ClearSupportedFrameworks(Package package) { foreach (var supportedFramework in package.SupportedFrameworks.ToList()) { _entitiesContext.Set <PackageFramework>().Remove(supportedFramework); } package.SupportedFrameworks.Clear(); }
public virtual async Task <ActionResult> UndoPendingEdits(string id, string version) { var package = _packageService.FindPackageByIdAndVersion(id, version); if (package == null) { return(HttpNotFound()); } if (!package.IsOwner(User)) { return(new HttpStatusCodeResult(403, "Forbidden")); } // To do as much successful cancellation as possible, Will not batch, but will instead try to cancel // pending edits 1 at a time, starting with oldest first. var pendingEdits = _entitiesContext.Set <PackageEdit>() .Where(pe => pe.PackageKey == package.Key) .OrderBy(pe => pe.Timestamp) .ToList(); int numOK = 0; int numConflicts = 0; foreach (var result in pendingEdits) { try { _entitiesContext.DeleteOnCommit(result); await _entitiesContext.SaveChangesAsync(); numOK += 1; } catch (DataException) { numConflicts += 1; } } if (numConflicts > 0) { TempData["Message"] = "Your pending edit has already been completed and could not be canceled."; } else if (numOK > 0) { TempData["Message"] = "Your pending edits for this package were successfully canceled."; } else { TempData["Message"] = "No pending edits were found for this package. The edits may have already been completed."; } return(Redirect(Url.Package(id, version))); }
/// <summary> /// Add in Single Record in the dataSet /// </summary> /// <param name="entity">Generics dbSet type</param> public TEntity Add(TEntity entity) { try { if (entity == null) { throw new NullReferenceException("Attempt to add a null record"); } IDbSet <TEntity> dbSet = _dbContext.Set <TEntity>(); TEntity addedEntity = dbSet.Add(entity); _dbContext.SetAsCreated(entity); return(addedEntity); } catch (DbEntityValidationException dbEx) { throwException(dbEx); return(null); } }
public void DeleteOnCommit(T entity) { if (TraceLogEvents) { MethodExtensionWrappers.WrapExecutionTracingTime( () => entities.Set <T>().Remove(entity), "Remove '{0}' ('{1}') from database".format_with(typeof(T).Name, entity.Key.to_string())); } else { entities.Set <T>().Remove(entity); } }
public void DeleteOnCommit(T entity) { _entities.Set <T>().Remove(entity); }
public Repository(IEntitiesContext context) { _context = context; _dbEntitySet = _context.Set <TEntity>(); }
public IQueryable <TEntity> GetAll() { return(_dbContext.Set <TEntity>()); }
public void InsertOnCommit(T entity) { _entities.Set <T>().Add(entity); }
public EfRepository(IEntitiesContext dbContext) { _dbContext = dbContext; _objectSet = _dbContext.Set <T>(); }
private T FindById(params object[] keyValues) { return(_context.Set <T>().Find(keyValues)); }
/// <summary> /// Gets all the entities /// </summary> /// <param name="tenantId">The tenant identifier</param> /// <returns>IQueryable collection of the entities</returns> public IQueryable <TEntity> GetAll(Guid tenantId) { return(_dbContext.Set <TEntity>().Where(e => e.TenantId == tenantId)); }
public BaseRepository(IUnitOfWork uow) { _uow = uow; _context = _uow.Context; _objectSet = _context.Set <T>(); }