Learning NHibernate 4

Pagination and ordering of results

Sometimes you do not want to use the results of a query as is. You might want to narrow down the number of records that a query is fetching or order them on a particular column. In this section, we will see how to manipulate the result set of a criteria query.

Narrowing down the number of records returned by a query

Many times we are only interested in a subset of records that can be returned by a query. On a criteria query or QueryOver, you can limit the maximum number of records returned by calling the SetMaxResults() method as follows:

using (var transaction = database.Session.BeginTransaction()) { employees = database.Session.CreateCriteria<Employee>() .CreateCriteria("ResidentialAddress") .Add(Restrictions.Eq("City", ...