Mapping multiple tables into a single object with NHibernate

Question

I have a schema that looks like this:

enter image description here

There is a one to one relationship between Foo and Bar and a many to one relationship between Bar and Baz.

I have Foo and Baz mapped to separate objects, but I'm not sure how to go about linking them using Bar, without making Bar a separate object. (I want to be able to access Baz as a property of Foo)

It looks like it should be possible as it's very similar to the example given here, except using a many-to-one relationship instead of a property.

Community · Accepted Answer · 2017-05-23 12:30:39Z

1

I'm not sure that you will be able to accomplish what you want using a join. You'll end up with problems trying to join Foo and Bar. See these 2 articles:

Fluent NHibernate join tables in mapping not using primary key
Fluent NHibernate join for property value

I'm not sure there is a great way around this without making bar an entity.

edited May 23, 2017 at 12:30

CommunityBot

11 silver badge

answered May 18, 2011 at 0:29

Cole W

15.4k7 gold badges56 silver badges88 bronze badges

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

1 Comment

Phil Lamb Over a year ago

Thanks for the links, it looks like I'll probably just have to map a Bar object.

Collectives™ on Stack Overflow

Mapping multiple tables into a single object with NHibernate

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related