EF5 Navigation/Association Property with non-Primary Foreign Key

Question

This is the same exact question as this, but instead for EF5.

Is it possible now?

We have a Users table that has an int PK, but in our other tables that have columns like InsertBy/UpdateBy, the desire is to use value of the LANID varchar column from the Users table, rather than the UserID.

score 3 · Accepted Answer · answered Sep 05 '12 at 18:58

3

No it is still not possible. FK must target PK in the principal table because EF still doesn't support unique keys (prerequisite for using non-PK columns).

answered Sep 05 '12 at 18:58

Ladislav Mrnka

360,892
59
660
670

boo EF whyyy :( -- no bother, we changed the model which simplified the relationship – JoeBrockhaus Oct 03 '12 at 14:43

EF5 Navigation/Association Property with non-Primary Foreign Key

1 Answers1