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); }