Single column joins in NHibernate using mapping by code

Question

Consider the following relationship between Item and ItemContent.

Item
ItemId
ItemName

ItemContent
ContentId
ItemId
Content
ContentType

What I would like to do is have a Content property on Item that JOINS the Content column from ItemContent based on ContentType that is provided in the mapping itself or injected in some other way.

What is the best way to accomplish this? What is the simplest way to accomplish this?

bernhardrusch · Accepted Answer · 2012-10-29 07:02:14Z

1

Well - according to Ayend Rahien it is possible to use a filter directly in the mapping. I have not tried it - but normally it should work if the says it works.

<set name="Comments"
   table="Comments">
   <key column="PostId"/>
   <one-to-many class="Comment"/>
   <filter name="effectiveDate"
   condition=":asOfDate >= PostedAt"/>
</set>

Here is the whole article about NHibernate filters on his blog

answered Oct 29, 2012 at 7:02

bernhardrusch

11.9k12 gold badges50 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Brian Over a year ago

Any idea on how this would be done using mapping by code? I've tried using the Property mapping, but there is no option for filter in that. Only formula. Formula is generating completely bogus SQL for me at this time.

bernhardrusch Over a year ago

well - this solution would be directly in the mapping file. I don't know if your way of mapping support this. Another idea would be using this technique: stackoverflow.com/questions/1787074/…

Collectives™ on Stack Overflow

Single column joins in NHibernate using mapping by code

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related