Nhibernate, Paging, Count(*), OrderBy and performance?

Question

NHibernate

Colleagues,
There is a following task: there is a table with 100 000 records. It is necessary to make a page-by-page output, with sorting and filtering. What would be the best way to have the sorting and filtering happen on the database server and not on a collection in the application's memory?
How to count Count(*) using NHibernate?

Answer 1

Thank you.