Hi,
I'm trying to do a simple "Select Count(*) from PRODUCTS where date > xxx" with Castle on NHibernate.
If I was directly using NHibernate, I could reuse this question answers but unfortunately I see no easy way to access the Current NHibernate session from Castle Records.
I obviously don't want to retrieve all my objects and do a Count on the C# side ;). I only need to know how many objects there are.
Any ideas?