In NHibernate it is possible to filter a property of a collection that appears as a package association so that when lazy loaded, the filter is applied directly in SQL, rather than loading the entire collection of packages and then filtering it?
FYI - I am using xml mapping files.
source
to share