Error 3027: No mapping specified for the following EntitySet/AssociationSet [closed]

Question

I am using EntityFramework 6 and I used Update Model from Database after inserting table in the database, I got above error.Please state how to overcome this problem.

Answer 1

Open the edmx file on notepad, find the unmapping association and remove it. It should work.

Answer 2

Not too satisfying, but I solved it by removing and re-adding the model:

1. Right-click on edmx-diagram and select "Model browser"
2. Remove the entity type that's giving the problems
3. Save (just to be sure, regenerates files)
4. Add model from databasetable again and save.

The warning was gone afterwards.

Answer 3

I got the same error and found that the foreign key in the table I had added was not of the same type as in the referenced table.

Answer 4

Here how I fix this:

1. Remove all the entities in your Diagram in your edmx file.
2. Rebuild your project if this edmx file is part of a project in your solution.
3. Rebuild your solution.

I am not sure why this happens but on my part, it consistently triggers this error when I update my database, and I didn't update my edmx file.

Answer 5

Try removing entity (table) from EDMX then run update to add that table again.