Map one-to-many tables relationship to a single entity framework object

Question

I have the following tables in the database (just a demo, of course):

Positions

PositionId

Limits

LimitId PositionId

I want to left join them into a single entity (always have position, not always have a limit attached to it):

Position

PositionId LimitId

I've seen articles regarding one-to-one mapping and "Table per type inheritence", and tried to implement the same method here, but with no sucess. Is that even possible?

Answer 1

I think what you want is an ordinary inner join where your foreign key (PositionID in the Limits table) is allowed to be null.

Answer 2

Nir,

Does this article contain what you are looking for?

Answer 3

Yes and no...In my scenario, the 2nd option is the applicable one, since I don't have the same primary key in both tables. so, I must create an updateable view...The problem with updateable view is that I can't modify fields which are in different tables and expect the database to handle it, unless I use "Instead of" triggers, which I really don't want to get into at all... So, I guess there's nothing out of the box for me...damn. (Unless you have another idea...)

Anyways, I really thank you for your help, it's much appreciated. Nir.