public SqlObject(IQueryBase parentQuery, string dataBase)
{
this.parentQuery = parentQuery;
this.Database = dataBase;
}
public async Task <PagerList <EntitySample> > PagerQueryAsNoTrackingAsync(IQueryBase <EntitySample> query)
{
throw new NotImplementedException();
}
public List <EntitySample> Query(IQueryBase <EntitySample> query)
{
throw new NotImplementedException();
}
public PagerList <EntitySample> PagerQueryAsNoTracking(IQueryBase <EntitySample> query)
{
throw new NotImplementedException();
}
public async Task <List <EntitySample> > QueryAsync(IQueryBase <EntitySample> query)
{
throw new NotImplementedException();
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="query">查询对象</param>
public async Task <PagerList <TEntity> > PagerQueryAsNoTrackingAsync(IQueryBase <TEntity> query)
{
var pager = query.GetPager();
return(await GetPagerQueryResult(FindAsNoTracking(), query, pager).ToPagerListAsync(pager));
}
public SqlObject(IQueryBase parentQuery, string dataBase)
{
this.parentQuery = parentQuery;
this.Database = dataBase;
}
/// <summary>
/// 获取分页查询结果
/// </summary>
/// <param name="queryable"></param>
/// <param name="query"></param>
/// <param name="pager"></param>
/// <returns></returns>
private IQueryable <TEntity> GetPagerQueryResult(IQueryable <TEntity> queryable, IQueryBase <TEntity> query,
IPager pager)
{
var order = pager.Order;
if (string.IsNullOrWhiteSpace(order))
{
order = "Id";
}
return(queryable.Where(query).OrderBy(order).Pager(pager));
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="query">查询对象</param>
public PagerList <TEntity> PagerQueryAsNoTracking(IQueryBase <TEntity> query)
{
var pager = query.GetPager();
return(GetPagerQueryResult(FindAsNoTracking(), query, pager).ToPagerList(pager));
}
/// <summary>
/// 查询 - 返回未跟踪的实体
/// </summary>
/// <param name="query">查询对象</param>
/// <returns></returns>
public async Task <List <TEntity> > QueryAsNoTrackingAsync(IQueryBase <TEntity> query)
{
return(await GetQueryResult(FindAsNoTracking(), query).ToListAsync());
}
/// <summary>
/// 查询 - 返回未跟踪的实体
/// </summary>
/// <param name="query">查询对象</param>
/// <returns></returns>
public List <TEntity> QueryAsNoTracking(IQueryBase <TEntity> query)
{
return(GetQueryResult(FindAsNoTracking(), query).ToList());
}
/// <summary>
/// 查询
/// </summary>
/// <param name="query">查询对象</param>
/// <returns></returns>
public List <TEntity> Query(IQueryBase <TEntity> query)
{
return(GetQueryResult(Find(), query).ToList());
}
public async Task <List <TEntity> > QueryAsync(IQueryBase <TEntity> query)
{
return(await Query(Find(), query).ToListAsync());
}
public List <TEntity> Query(IQueryBase <TEntity> query)
{
return(Query(Find(), query).ToList());
}
