Hi guys,
I am quite new with NHibernate.
Let's take a look at the following example:
I have Customers and each Customer has a collection of Orders (Lazy=true, fetch=subselect).
Now let say that i would like to retrieve all the Customers under the age of 50. This would not be a problem since i can achive that via expresions or HQL.
But what if i want to retrieve all the customers under the age of 50, and for each of these customers i would like to get only the orders that were created before the 01/01/2000... can i do that?
Note: i don't want to retrive 2 differnt arrays of Customers and Orders, i would like to retrieve a filtered list of Customers and each Customer with its filtered collection of Orders.

Best regards

If you know how to pull back the customers under age 50 in hql, tacking this onto your Where clause seems simple enough " AND Order.OrderDate > '01/01/2000' "