Sorry for my ignorance I'm quite new to NH. I have read "Hibernate in action" but is still missing something.

The situation is:

ClassA contains a list of ClassB. The IList of ClassB is lazy loaded. Is it possible to make restrictions on the IList of ClassB when accessed through ClassA.ClassBCollection? For every ClassA there could be 1000 ClassB's but I always want ClassB where ClassB.Year=2005.

Can this be done???

Regards Morten

You can use a "where" attribute and place standard SQL tags. I've never used it so you might have to play with it for a while but you will want to do something like this in the ClassA mapping file:



The where is SQL, so like I said, you might have to play with it to match the definition of the table column.

-devon

You can also load ClassB entities (with a HQL like "from ClassB b where b.Year = 2005 and b.ClassA.Id = XXX")
But you will not have the collection ClassA.ClassBCollection initialized...

Or use Session.CreateFilter (someObj.ListOfClassBs, "some HQL condition")