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
|