public TEntity GetByID(object id) { using (var context = new heroku_4f2def07091704cContext()) { dbSet = context.Set <TEntity>(); return(dbSet.Find(id)); } }
//public EntityRepository() //{ // this.context = new heroku_4f2def07091704cContext(); // dbSet = context.Set<TEntity>(); //} //public EntityRepository(heroku_4f2def07091704cContext context) //{ // this.context = context; // this.dbSet = context.Set<TEntity>(); //} public IEnumerable <TEntity> GetAll() { using (var context = new heroku_4f2def07091704cContext()) { dbSet = context.Set <TEntity>(); return(dbSet.ToList()); } }
public async Task <IEnumerable <TEntity> > GetAllAsync() { using (var context = new heroku_4f2def07091704cContext()) { dbSet = context.Set <TEntity>(); return(await dbSet.ToListAsync()); } }
public async Task <TEntity> GetByIDAsync(int id) { using (var context = new heroku_4f2def07091704cContext()) { dbSet = context.Set <TEntity>(); return(await dbSet.FindAsync(id)); } }
public void Save() { using (var context = new heroku_4f2def07091704cContext()) { dbSet = context.Set <TEntity>(); context.SaveChanges(); } }
public void Insert(TEntity entity) { using (var context = new heroku_4f2def07091704cContext()) { dbSet = context.Set <TEntity>(); dbSet.Add(entity); context.SaveChanges(); } }
public virtual IEnumerable <TEntity> GetWithRawSql(string query, params object[] parameters) { using (var context = new heroku_4f2def07091704cContext()) { dbSet = context.Set <TEntity>(); return(dbSet.FromSqlRaw(query, parameters).ToList()); } }
public void Delete(object id) { using (var context = new heroku_4f2def07091704cContext()) { dbSet = context.Set <TEntity>(); TEntity entityToDelete = dbSet.Find(id); Delete(entityToDelete); context.SaveChanges(); } }
public void Update(TEntity entityToUpdate) { using (var context = new heroku_4f2def07091704cContext()) { dbSet = context.Set <TEntity>(); dbSet.Attach(entityToUpdate); context.Entry(entityToUpdate).State = EntityState.Modified; context.SaveChanges(); } }
public void SoftDelete(object id) { using (var context = new heroku_4f2def07091704cContext()) { dbSet = context.Set <TEntity>(); TEntity entityToUpdate = dbSet.Find(id); dbSet.Attach(entityToUpdate); context.Entry(entityToUpdate).CurrentValues["IsDeleted"] = 1; context.Entry(entityToUpdate).State = EntityState.Modified; context.SaveChanges(); } }
public void Delete(TEntity entityToDelete) { using (var context = new heroku_4f2def07091704cContext()) { dbSet = context.Set <TEntity>(); if (context.Entry(entityToDelete).State == EntityState.Detached) { dbSet.Attach(entityToDelete); } dbSet.Remove(entityToDelete); context.SaveChanges(); } }
public IEnumerable <TEntity> Get( Expression <Func <TEntity, bool> > filter = null, Func <IQueryable <TEntity>, IOrderedQueryable <TEntity> > orderBy = null, string includeProperties = "") { using (var context = new heroku_4f2def07091704cContext()) { dbSet = context.Set <TEntity>(); IQueryable <TEntity> query = dbSet; if (filter != null) { query = query.Where(filter); } if (includeProperties != null) { foreach (var includeProperty in includeProperties.Split (new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries)) { query = query.Include(includeProperty); } } if (orderBy != null) { return(orderBy(query).ToList()); } else { return(query.ToList()); } } }