public async Task <List <TEntity> > GetAll(int offset, int limit)
{
using (var dbContext = new raw2Context())
{
return(await dbContext.Set <TEntity>().Skip(offset).Take(limit).ToListAsync());
}
}
public async Task <TEntity> Get(int id)
{
using (var dbContext = new raw2Context())
{
return(await dbContext.Set <TEntity>().FindAsync(id));
}
}
public async Task <bool> Delete(int id)
{
using (var dbContext = new raw2Context())
{
var entity = await dbContext.Set <TEntity>().FindAsync(id);
if (entity == null)
{
return(false);
}
dbContext.Set <TEntity>().Remove(entity);
await dbContext.SaveChangesAsync();
return(true);
}
}
public async Task <TEntity> Create(TEntity entity)
{
using (var dbContext = new raw2Context())
{
dbContext.Set <TEntity>().Add(entity);
await dbContext.SaveChangesAsync();
return(entity);
}
}
public async Task <List <TEntity> > GetAll(int offset, int limit, TOptions options)
{
using (var dbContext = new raw2Context())
{
var x = dbContext.Set <TEntity>().Skip(offset).Take(limit);
foreach (var model in options.IncludedModels)
{
x = x.Include(model);
}
return(await x.ToListAsync());
}
}
