Cascading with "where=xxx"

adressin · **Joined:** Wed Apr 07, 2004 6:13 pm **Posts:** 18

Hi,
How does NHibernate handle a mapped collection using the "where" clause? I have 2 collections on an object that both map to the same class, but use different "where" clauses. Will cascading and caching work as other mapped relationships?

adressin · **Joined:** Wed Apr 07, 2004 6:13 pm **Posts:** 18

wanted to put an example of what I'm talking about to help:

Code:

      <bag name="RoleAccessRights" lazy="true" cascade="none" generic="true" where="MEMBERSHIP_OBJECT_TYPE = 1 AND PROTECTED_OBJECT_TYPE = 3">
         <cache usage="read-write"/>
         <key column="PROTECTED_OBJECT_ID"/>
         <one-to-many class="TS.Core.Domain.AccessRights, TS.Core.Domain" />
      </bag>
      <bag name="UserAccessRights" lazy="true" cascade="none" generic="true" where="MEMBERSHIP_OBJECT_TYPE = 2 AND PROTECTED_OBJECT_TYPE = 3">
         <cache usage="read-write"/>
         <key column="PROTECTED_OBJECT_ID"/>
         <one-to-many class="TS.Core.Domain.AccessRights, TS.Core.Domain" />
      </bag>

So, there is no "inverse" side (can I have one if the other end of this represents many different "protected object types" i.e. keys to different database tables?).

Can I let NHibernate manage the cascading and caching?