Does anyone know of a resource for Criteria Queries in NHibernate that demonstrates complex criteria restrictions.
For example
select rows in the parent table and only rows in a child table that match a criteria
set eager fetching on parent and child in the criteria
i.e. not just simple criteria, but something a bit more meaty. I have searched for a decent resource, but just find really simplistic examples and I need more advanced examples and explanations.
Hibernate documentation and examples could be used too. Because both NHibernate and Hibernate have same API. An easy way to get documentation and examples is to google it. For example try this.