I have 3 models:

Person * --- 1 Membership 1 -- * Group

I have mapped all three objects (ie. not using many-many).

Now i'm doing "logical delete" or "soft delete" i've seen it referred to, on the Group model. Is it possible to only fetch the non-deleted Groups by association from the Person object?

Ideally i'd like to have the Person.Memberships collection lazily loaded, but if I load in the Memberships collection, i'd like to eager fetch the groups with a where clause filtering out the deleted groups.

Can this only be achieved by a query?

Thanks,

Dave Newman

I've realised what i'm after is very similar to Ruby on Rails' Active Record has_many through construct:

eg.
has_many :groups, :through => :memberships

you can then add a where clause on the groups table. Is this supported?

If not, I might look into adding support for it.

I think you can possibly do this using the new "filters" feature of NHibernate 1.2. Haven't tried it myself tho.

Symon.