Have a FK relationship and a Navigation property at the same

Question

I'm Using EF 4.1 Model First approach

Is it possible to have a foreign key relationship and a Navigation property at the same time for the same type.

For ex I have a Job entity and a field called PaymentType_ID with a foreign key relationship to a PaymentType entity. When I do an insert it works fine.

Then I add a Navigation property using the same association that is used for the FK, when I try insert I get the following error "Invalid column name 'PaymentType_PaymentTypeID'."

It seems EF is for some reason adding another column by itself even though a FK already exists.

Is this possible or what am I doing something wrong

score 0 · Accepted Answer · answered Apr 04 '12 at 15:39

0

Yes it is possible but your property doesn't follow default naming convention so you must manually pair the FK with navigation property for example through data annotations:

[ForeignKey("PaymentType_ID")] // Name of FK property
public virtual PaymentType PaymentType { get; set; }

answered Apr 04 '12 at 15:39

Ladislav Mrnka

360,892
59
660
670

how would I achieve this using Model Fist approach? – Eugene Niemand Apr 04 '12 at 15:55
http://stackoverflow.com/questions/5444450/ado-net-ef-how-to-define-foreign-key-relation-in-model-first-approach/5445806#5445806 – Ladislav Mrnka Apr 04 '12 at 16:04
I accepted this answer as it was the only one provided. But it did not solve my problem – Eugene Niemand Jul 16 '12 at 14:49

score 0 · Answer 2 · answered Feb 20 '15 at 18:53

0

Yes it's possible You should clear navigation property & relationship see : https://msdn.microsoft.com/en-us/data/jj713564

answered Feb 20 '15 at 18:53

Yahya Alshaar

163
1
5

Could you please extend your answer? This is a little thin – Artjom B. Feb 20 '15 at 19:14

Have a FK relationship and a Navigation property at the same

2 Answers2