public async Task <bool> Exists <T>(Expression <Func <T, bool> > expression = null, CancellationToken token = default(CancellationToken)) where T : class, IDataModel
{
bool result = default(bool);
using (var db = new MediaLibraryEntities())
{
db.Database.SetCommandTimeout(timeout);
result = (expression != null ? await db.Set <T>().FirstOrDefaultAsync(expression, token) : await db.Set <T>().FirstOrDefaultAsync(token)) != null;
}
return(result);
}
public async Task <int> Execute(string sql, CancellationToken token = default(CancellationToken), params object[] parameters)
{
int result = default(int);
using (var db = new MediaLibraryEntities())
{
db.Database.SetCommandTimeout(timeout);
result = await db.Database.ExecuteSqlRawAsync(sql, token, parameters);
}
return(result);
}
public async Task <int> Count <T>(Expression <Func <T, bool> > expression = null, CancellationToken token = default(CancellationToken)) where T : class, IDataModel
{
int result = default(int);
using (var db = new MediaLibraryEntities())
{
db.Database.SetCommandTimeout(timeout);
result = expression != null ? await db.Set <T>().CountAsync(expression, token) : await db.Set <T>().CountAsync(token);
}
return(result);
}
public async Task <int> Update <T>(T entity, CancellationToken token = default(CancellationToken)) where T : class, IDataModel
{
int result = default(int);
using (var db = new MediaLibraryEntities())
{
db.Database.SetCommandTimeout(timeout);
entity.ModifyDate = DateTime.Now;
db.Entry(entity).State = EntityState.Modified;
result = await db.SaveChangesAsync(token);
}
return(result);
}
public async Task <int> Delete <T>(object id, CancellationToken token = default(CancellationToken)) where T : class, IDataModel
{
int result = default(int);
using (var db = new MediaLibraryEntities())
{
DbSet <T> set = null;
T entity = null;
db.Database.SetCommandTimeout(timeout);
set = db.Set <T>();
entity = await set.FindAsync(id);
set.Remove(entity);
result = await db.SaveChangesAsync(token);
}
return(result);
}
public async Task <int> Insert <T>(IEnumerable <T> entities, CancellationToken token = default(CancellationToken)) where T : class, IDataModel
{
int result = default(int);
IList <T> items = entities.ToList();
using (var db = new MediaLibraryEntities())
{
foreach (var item in items)
{
item.CreateDate = DateTime.Now;
item.ModifyDate = DateTime.Now;
}
db.Database.SetCommandTimeout(timeout);
db.Set <T>().AddRange(items);
result = await db.SaveChangesAsync(token);
}
return(result);
}
public async Task <IEnumerable <T> > GetListAlt <T>(Expression <Func <T, bool> > expression = null,
CancellationToken token = default(CancellationToken),
params string[] includePaths) where T : class, IDataModel
{
IEnumerable <T> results = Enumerable.Empty <T>();
using (var db = new MediaLibraryEntities())
{
IQueryable <T> query = db.Set <T>();
db.Database.SetCommandTimeout(timeout);
foreach (var include in includePaths)
{
query = query.Include(include);
}
results = await(expression != null ? query.Where(expression) : query).ToListAsync(token);
}
return(results);
}
public async Task <T> Get <T>(Expression <Func <T, bool> > expression = null,
CancellationToken token = default(CancellationToken),
params Expression <Func <T, object> >[] includes) where T : class, IDataModel
{
T result = default(T);
using (var db = new MediaLibraryEntities())
{
IQueryable <T> query = db.Set <T>();
db.Database.SetCommandTimeout(timeout);
foreach (var include in includes)
{
query = query.Include(include);
}
result = await(expression != null ? query.Where(expression) : query).FirstOrDefaultAsync(token);
}
return(result);
}
public async Task <int> DeleteAll <T>(Expression <Func <T, bool> > expression = null, CancellationToken token = default(CancellationToken)) where T : class, IDataModel
{
int result = default(int);
if (expression != null)
{
using (var db = new MediaLibraryEntities())
{
DbSet <T> set = null;
db.Database.SetCommandTimeout(timeout);
set = db.Set <T>();
set.RemoveRange(set.Where(expression));
result = await db.SaveChangesAsync(token);
}
}
else
{
result = await DeleteAll <T>(token : token);
}
return(result);
}
public VideoGamesRespository()
{
Entities = new MediaLibraryEntities();
}
public VideoGamesRespository(MediaLibraryEntities entities)
{
Entities = entities;
}
