NHibernate equivalent to session.iterate?

s.rottem · **Posted:** Tue Aug 09, 2005 1:14 pm

Hi,

Is there an equivalent in NHibernate to the session.iterate in the Hibernate docs?

They suggest using something like the following to get the number of entities in a collection:

Code:

 You can find the size of a collection without initializing it:

( (Integer) session.iterate("select count(*) from ....").next() ).intValue();

but I can't figure out how to do this in NHibernate.

Cheerio,

Symon.

KPixel · **Posted:** Wed Aug 10, 2005 10:28 am

Try

Code:

(int) session.Find("select count(*) from ....")[0];

s.rottem · **Posted:** Wed Aug 10, 2005 12:58 pm

Thanks KPixel - will do.

sergey · **Posted:** Wed Aug 10, 2005 3:19 pm

Actually, the direct equivalent of session.iterate() is session.Enumerable().