Daily Archives: November 20, 2008

NHibernate criteria queries across multiple many-many associations Comments Off

Recently, I ran into an issue with NHibernate Criteria queries. The scenario is the following: User has a many-many association with Role and Role has a many-many association with Site. I simply wanted all users that belong to a given site (and a whole slew of other optional parameters, therefore the Criteria query). With hql [...]