A dependent property in a ReferentialConstraint is mapped to a store-generated column

Solution 1:

Is it possible that you defined a bad column relation between your tables?

In my case, I had different columns and one was set as autonumeric.

Solution 2:

This error says that you are using unsupported relation or you have error in your mapping. Your code is most probably absolutely unrelated to the error.

The error means that you have some relation between entities where foreign key property in dependent entity is defined as store generated. Store generated properties are filled in the database. EF doesn't support store generated properties as foreign keys (as well as computed properties in primary keys).

Solution 3:

I had the same problem. Based on the answers provided here I was able to track it and solve it, but I had a strange issue described below - it might help somebody in the future.

On my dependent tables, the foreign Key columns have been set to StoreGeneratedPattern="Identity". I had to change it to "None". Unfortunately, doing so inside designer didn't work at all.

I looked in the designer-generated XML (SSDL) and these properties were still there so I removed them manually. I also had to fix the columns on the database (remove the Identity(1,1) from CREATE TABLE SQL)

After that, the problem went away.

Solution 4:

I had the same problem and after some digging in table design in sql server , I found that mistakenly i set table's primary key also as foreign key.

In this image you can see that JobID is table's primary key but also mistakenly foreign key.