NHibernate request for swap in web application

Question

Given the request, for example:

from Users u where u.Country = "US"

I have a web application with a custom grid.

How do I query NHibernate to return the display page results? given size and page index

Malcolm

+1

Malcolm May 13 '09 at 19:49

1 answer

Stefan steinegger · Accepted Answer · 2009-05-13T20:06:08+0000

Use SetFirstResult and SetMaxResults on request or criteria:

int pagesize = 10;
int page = 2;
query = session.createQuery("...")
  .SetFirstResult(pagesize * page)
  .SetMaxResults(pagesize);