public async Task <PagedResultDto <TResultEntiy> > SqlExecuteQueryPageList(SqlExecutePageListQueryInput input)
{
var query = _dbContextProvider.GetDbContext().Set <TResultEntiy>().FromSql(input.Sql, input.param);
var totalCount = await query.CountAsync();
var output = await query.OrderBy(input.Sorting).PageBy(input).ToListAsync();
return(new PagedResultDto <TResultEntiy>(totalCount, output));
}
public IQueryable <TResultEntiy> ListExecuteQuery(SqlExecutePageListQueryInput input)
{
var query = _dbContextProvider.GetDbContext().Set <TResultEntiy>().FromSql(input.Sql, input.param);
return(query);
}
