How do I take the "top n" using NHibernate Criteria API? Ideally I'd like to use detached criteria.
something like:-
criteria.SetFirstResult(1); criteria.SetMaxResults(10);
Will take the first 10 results.