Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. public virtual async Task<(List<TModel>, int)> FindAsync(IQueryable<TModel> query, int pageNumber = 1, int pageSize = 20, string[] sortExpression = null, Expression<Func<TModel, object>> includes = null)
  2. {
  3. query = Includes(includes, query);
  4. query = SetFilterAll(query);
  5.  
  6. var count = await query.CountAsync();
  7. query = Sort(sortExpression, query);
  8. query = Pagination(pageNumber, pageSize, query);
  9. return (await query.ToListAsync(), count);
  10. }
  11.  
  12. SELECT * FROM MinhaTabela ORDER BY CAST(meu_campo_date AS DATE) DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement