In NHibernate is it possible to filter a collection property which is mapped as a bag association such that when the lazy loading occurs the filter is applied directly in the SQL rather than loading the whole bag collection and then filtering it?
F.Y.I - I'm using xml mapping files.