public async Task <T> GetEntityAsync(Expression <Func <T, bool> > where, string dataBaseName = null)
{
using (ProjectContext context = await DataBaseConfig.CreateContext(dataBaseName))
{
return(await context.Set <T>().FirstOrDefaultAsync(where));
}
}
public async Task <IEnumerable <T> > GetListAsync(Expression <Func <T, bool> > where, string dataBaseName = null)
{
using (ProjectContext context = await DataBaseConfig.CreateContext(dataBaseName))
{
return(await context.Set <T>().AsNoTracking().Where(where).ToListAsync());
}
}
public async Task <IEnumerable <T> > GetListAsync(string dataBaseName = null)
{
using (ProjectContext context = await DataBaseConfig.CreateContext(dataBaseName))
{
return(await context.Set <T>().AsNoTracking().ToListAsync());
}
}
public async Task <T> GetEntityAsync(string keyValue, string dataBaseName = null)
{
using (ProjectContext context = await DataBaseConfig.CreateContext(dataBaseName))
{
return(await context.FindAsync <T>(keyValue));
}
}
public async Task <Tuple <IEnumerable <T>, int> > GetListAsync <Tkey>(Expression <Func <T, bool> > where, Func <T, Tkey> orderbyLambda, bool isAsc, int pageSize, int pageIndex, string dataBaseName = null)
{
using (ProjectContext context = await DataBaseConfig.CreateContext(dataBaseName))
{
var list = await context.Set <T>().AsNoTracking().Where(where).ToListAsync();
int total = list.Count();
if (isAsc)
{
var temp = list
.OrderBy(orderbyLambda)
.Skip(pageSize * (pageIndex - 1))
.Take(pageSize);
return(new Tuple <IEnumerable <T>, int>(temp, total));
}
else
{
var temp = list
.OrderByDescending(orderbyLambda)
.Skip(pageSize * (pageIndex - 1))
.Take(pageSize);
return(new Tuple <IEnumerable <T>, int>(temp, total));
}
}
}
public async Task <bool> DeleteAsync(IEnumerable <T> entityList, string dataBaseName = null)
{
using (ProjectContext context = await DataBaseConfig.CreateContext(dataBaseName))
{
context.Set <T>().RemoveRange(entityList);
return(await context.SaveChangesAsync() > 0);
}
}
public async Task <bool> DeleteAsync(string keyValue, string dataBaseName = null)
{
using (ProjectContext context = await DataBaseConfig.CreateContext(dataBaseName))
{
context.Set <T>().Remove(context.Find <T>(keyValue));
return(await context.SaveChangesAsync() > 0);
}
}
public async Task <bool> UpdateAsync(T entity, string dataBaseName = null)
{
using (ProjectContext context = await DataBaseConfig.CreateContext(dataBaseName))
{
context.Update(entity);
return(await context.SaveChangesAsync() > 0);
}
}
public async Task <bool> DeleteAsync(string[] keyValues, string dataBaseName = null)
{
using (ProjectContext context = await DataBaseConfig.CreateContext(dataBaseName))
{
List <T> entitys = new List <T>();
entitys.ForEach(async u =>
{
entitys.Add(await context.FindAsync <T>(u));
});
return(await DeleteAsync(entitys));
}
}