2
Guys I’m using Entity and I have a query that returns some 2000 lines. After doing this:
base.Get(queryParameters)
.GroupBy(x => new { x.Id })
Until then it is normal,I work with pagedlist, where is informed the page number that will be displayed and the amount of items of it, example:
-The return has 20 items, it is informed page 2 and quantity 10, the return will be 10 items from the 11th to the 20th item of the list.
The problem is that I can only do it after having consulted the 2000 lines in the bank and grouped them, which makes the delay very large, because there are some 'joins' in the middle.
Is there any way to group a query and paged it before the query is done in the database?
https://stackoverflow.com/questions/19766300/pagedlist-with-entity-framework-getting-all-records
– Gustavo Santos