Hibernate version: NHibernate 1.0.4.0

(Other items are irrelevant)

How can I limit the number of records returned in an HQL subselect?

EXAMPLE (no this is not a valid hql statement, I am trying to figure out how I would code this in a valid way)


SELECT a.name, b.name
FROM Eg.One a
LEFT OUTER JOIN Eg.Two b
WHERE b.createdate = (SELECT TOP 1 b2.createdate FROM Eg.Two b2 ORDER BY b2.createdate DESC)


Thank you.

You can use the following property :

IQuery query = TransactionManager.GetHibernateSession().CreateQuery( query );
query.SetMaxResults( 1 );

Actually, that wouldn't work because the limit would be applied to the top level query, not the subquery.