CODEWITHSUNDEEP
c#sql-serverentity-framework
Vigil
Vigil

Reputation: 63

EF6: Foreign keys are not recognized on model generation for Sql Server DB

I'm getting started with Entity Framework and I'm trying to generate a model based on an already existing database. Most of the tables have foreign key references to other tables on unique identifiers that do not happen to be the primary key of the table.

It seems like the model generation is completely ignoring the FK references. The error list shows the following:

Error 6035: The relationship 'My foreign key constraint' has columns that are not part of the key of the table on the primary side of the relationship. The relationship was excluded.

Here's a look at the model and error list

Anybody have any ideas? Is it just that EF doesn't like FK constraints on fields that aren't the primary key?

Thanks in advance.

Upvotes: 6

Views: 2729

Answers (1)

Moho
Moho

Reputation: 16573

Entity framework does not support unique constraints which unfortunately leaves the PK as the only candidate key.

Upvotes: 13

Related Questions