Sorting and paging compiled queries

Question

Is it possible to compile queries which will be used with paging and sorting? For example does this make sense:

this.query = CompiledQuery.Compile<...>(
..
from row in dbx.Table select row
)

..

var select = this.query.OrderBy(..).Skip(..).Take(..);

Is this plausible? Or will it recompile every time Order, Skip, Take parameters change? Should I go back to regular queries instead of compiling them?

Answer 1

In your example, the query would be recompiled every time.

However, if you put your paging inside the compiled query, then it will compile the paging part, as well.