Error 3002: Problem in mapping fragments in .EDMX

Question

I have only one table in model's .edmx file. I updated the table in SQL Server by adding a column to it, opened up the .edmx file and used "update Model from Database" to update. The updated .edmx does show newly added field but I get a compile error:

       Error 3002: Problem in mapping fragments
```How do I fix it without deleting and recreating the model?

Answer 1

Hi @Malam Malam,

Check the entity keys in your table. It is the only one.

This may have happened unexpectedly, or the Entity Framework was unable to get the primary key information from the database and had to infer the entity key.

If you right-click the column (in EF diagram on VS) you will get the option to tick/untick the Entity Key:

However, it is recommended that you delete the table from your edmx, then "Update Model from Database" and add the table again, and finally rebuild your project.

Best regards,
Lan Huang

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.