How can you do paging with NHibernate?

by

ICriteria has a SetFirstResult(int i) method, which indicates the index of the first item that you wish to get (basically the first data row in your page).

It also has a SetMaxResults(int i) method, which indicates the number of rows you wish to get (i.e., your page size).

For example, this criteria object gets the first 10 results of your data grid:

criteria.SetFirstResult(0).SetMaxResults(10);

More Related Contents:

  1. NHibernate ISession Flush: Where and when to use it, and why?
  2. Referencing 2 different versions of log4net in the same solution
  3. Is there a way to call a stored procedure with Dapper?
  4. The repository itself is not usually tested?
  5. .net ORM Comparison [closed]
  6. Sequential GUID in Linq-to-Sql?
  7. Mapping collection of strings with NHibernate
  8. Entity Framework is Too Slow. What are my options? [closed]
  9. Best free ORM tools to use with .NET 2.0/3.5 [closed]
  10. Dapper and SQL Injections
  11. Binding a GridView to a Dynamic or ExpandoObject object
  12. What should be the lifetime of an NHibernate session?
  13. NHibernate: Reasons for overriding Equals and GetHashCode
  14. How to return a page of results from SQL?
  15. Most useful NLog configurations [closed]
  16. Is it safe just to set CheckForIllegalCrossThreadCalls to false to avoid cross threading errors during debugging?
  17. A definitive guide to API-breaking changes in .NET
  18. .NET Memory Profiling Tools [duplicate]
  19. Calling a .net library method from vba
  20. How securely unguessable are GUIDs?
  21. How do I validate email address formatting with the .NET Framework?
  22. Global Keyboard Hook from windows service
  23. Recommended method for loading a URL via a scheduled task on Windows
  24. How to see JIT-Compiled code in .NET VM (CLR)
  25. How to call managed code from unmanaged code?
  26. Change selected and unfocused Listbox style to not be grayed out
  27. Detecting what the target object is when NullReferenceException is thrown
  28. What’s the different between ASP.NET AJAX pageLoad() and JavaScript window.onload?
  29. Default ContextMenu Style – WPF
  30. .net: How to parse a date with this format: 08 Feb 2011 06:46

Leave a Comment