Entity Framework foreign key when name doesn't match

Question

I have a table called AccountValues that I would like to reference from my Account table. However rather than using AccountValuesId and AccountValues, I would like it to be a little more descriptive by prefixing MostRecent_ as follows:

[ForeignKey("AccountValues")]
public long MostRecent_AccountValuesId { get; set; }
public AccountValues MostRecent_AccountValues { get; set; }

My question is where should I place my ForeignKey attribute, so that I end up with an actual foreign key (e.g. FK_Something) and also have MostRecent_AccountValues automagically work?

Note: my convention is not to have plural table names. But here AccountValues is plural only because each row has a number of different values in it.

TanvirArjel · Accepted Answer · 2019-05-26 04:18:59Z

3

Problem is in your ForeignKey name on the public long MostRecent_AccountValuesId property. ForeignKey name should match the navigation property name as follows:

[ForeignKey("MostRecent_AccountValues")] // <-- Here it is
public long MostRecent_AccountValuesId { get; set; }
public AccountValues MostRecent_AccountValues { get; set; }

answered May 26, 2019 at 4:18

TanvirArjel

32.5k14 gold badges89 silver badges120 bronze badges

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

Collectives™ on Stack Overflow

Entity Framework foreign key when name doesn't match

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related