NHibernate just-in-time SQL for linq criteria on bag collections

Question

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.

score 2 · Answer 1 · edited Apr 17 '15 at 01:14

2

Yes, if you define the filter in the mappings: http://nhibernate.info/doc/nh/en/index.html#filters

edited Apr 17 '15 at 01:14

hazzik

12,584
7
43
85

answered Dec 13 '12 at 16:22

Oskar Berggren

5,535
1
16
36

OK, I was just wondering if there was a work around to do a Linq IQueryable style approach where its not based on the mapping. Thanks. – ICS Dec 13 '12 at 20:59
That's why I do like SO. This was unknown for me. Nice one! – Radim Köhler Dec 20 '12 at 13:21

NHibernate just-in-time SQL for linq criteria on bag collections

1 Answers1

Linked