How do I take the "top n" using NHibernate Criteria API?

c# nhibernate criteria icriteria
Ben Aston picture Ben Aston · Jul 20, 2010 · Viewed 8.5k times · Source

How do I take the "top n" using NHibernate Criteria API? Ideally I'd like to use detached criteria.

Answer

Rippo picture Rippo · Jul 20, 2010

something like:-

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

Will take the first 10 results.

Related questions

Querying on Collection with Nhibernate Criteria Api?

I have an "Estate" entity, and this entity has a collection "EstateFeatures"(type:EstateFeature) and EstateFeature has a property "MyFeatureValue". Note: These are the limited properties for the question. All Entities has an Id and all necesarry etc Estate IList&…

Read More
NHIbernate OR Criteria Query

I have the following mapped classes Trade { ID, AccountFrom, AccountTo } Account {ID, Company} Company {ID} Now I cannot figure out a way select all trades where AccountFrom.Company.ID = X OR AccountTo.Company.ID = X I can get AND to …

Read More
NHibernate.MappingException: No persister for: XYZ

Now, before you say it: I did Google and my hbm.xml file is an Embedded Resource. Here is the code I am calling: ISession session = GetCurrentSession(); var returnObject = session.Get<T>(Id); Here is my mapping file …

Read More