Hello, I´m a newbie with nhibernet, I´m an asp.net developer. Is it possible
to get pages of data instead a complete dataset?, I would like to avoid the
overhead over the database with tables that contains a large amount of
records. Mostly of the web pages only show 100 rows in a grid per page, so
it is not necesary to retrieve 100000 rows when 100 is needed? how can I do
this with nhibernate?. I have seen many filters and sortings capabilities in
the library, but I think that they are after fetching the entire dataset or
resultset... Is that right?

Thanks in advance...

Use the SetFirstResult and SetMaxResults methods on the IQuery and ICriteria interfaces to limit the resultset. The effectiveness of these calls will depend on the features supported by the database.

Hello, thank you for your help, but I have another proble, how can I get the total count of elements in the table or the number of pages in order to custom page with gridview or datagrid.

Thank you

you will have to do a count query first using HQL