public virtual IEnumerable <TEntity> Get(Expression <Func <TEntity, bool> > filter = null) { IQueryable <TEntity> query = context.Set <TEntity>(); if (filter != null) { query = query.Where(filter); } return(query.ToList()); }
public async Task <bool> Delete(int id) { using (ToDoDbContext context = _contextFactory.CreateDbContext()) { T entity = await context.Set <T>().FirstOrDefaultAsync((entity) => entity.Id == id); context.Set <T>().Remove(entity); await context.SaveChangesAsync(); return(true); } }
public async Task <IEnumerable <T> > GetAll() { using (ToDoDbContext context = _contextFactory.CreateDbContext()) { IEnumerable <T> entities = await context.Set <T>().ToListAsync(); return(entities); } }
public async Task <T> Get(int id) { using (ToDoDbContext context = _contextFactory.CreateDbContext()) { T entity = await context.Set <T>().FirstOrDefaultAsync((entity) => entity.Id == id); return(entity); } }
public async Task <T> Create(T entity) { using (ToDoDbContext context = _contextFactory.CreateDbContext()) { var result = await context.Set <T>().AddAsync(entity); await context.SaveChangesAsync(); return(result.Entity); } }
public async Task <T> Update(int id, T entity) { using (ToDoDbContext context = _contextFactory.CreateDbContext()) { entity.Id = id; context.Set <T>().Update(entity); await context.SaveChangesAsync(); return(entity); } }
public async Task <IEnumerable <T> > GetAllAsync() { return(await _context.Set <T>().ToListAsync()); }
/// <summary> /// ctor. /// </summary> /// <param name="dbContext"></param> public Repository(ToDoDbContext dbContext) { _dbContext = dbContext; dbSet = _dbContext.Set <T>(); }
/// <summary> /// Fetches All todo's from database /// </summary> /// <returns></returns> public IQueryable <ToDo> GetAllToDos() { return(_toDoDbContext.Set <ToDo>()); }
public List <ToDoDto> GetAll() => _context.Set <ToDoEntity>().ToList().Select(item => new ToDoDto(item)).ToList();
public async Task <int> Update(T entity) { _dbContext.Set <T>().Attach(entity); _dbContext.Entry(entity).State = EntityState.Modified; return(await Save()); }
public GenericRepo(ToDoDbContext dbContext) { _dbContext = dbContext; _table = _dbContext.Set <T>(); }