Must specify mapping for all key properties

Question

0.00/5 (No votes)

See more:

Hi There,

I am faced with a new issue, I have been using entity framework in one of my projects for quite sometime. Today I came across a table in sql that was created by someone who worked on the project a long time ago.

The table had no Primary Key column so I decided to add 1 in, I then updated the EDMX file in my solution but it now keeps throwing up this error:

Must specify mapping for all key properties.

I dropped the table and recreated but this error is not going away at all.

I would really appreciate some help on this.

Thanks.

What I have tried:

Google the issue.

Delete the current EDMX and import a new 1.

Rebuild/Clean the solution.

Posted 16-Apr-18 4:12am

Kats2512

Updated 1-Aug-18 20:22pm

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2018-04-16T05:49:00

Solution 1

First of all, you have to udpate (recreate) .edmx file from schema (database).
How? In the EF Designer[^] - right-click -> Update Model from Database.

In case it won't help, please follow these:
Editing an .edmx File Manually (Entity Framework)[^]
EDM - Must specify mapping for all key properties of entity set[^]

Good luck!

Posted 16-Apr-18 5:49am

Maciej Los

Comments

Kats2512 16-Apr-18 11:50am

Yeah right click update model from database. I even deleted the entity/table from the diagram.

Will check the link tomorrow when I get back to work.

Kats2512 17-Apr-18 3:23am

for some stupid reason I opened the EDMX as xml and found that it was refusing to delete the association. After deleting the xml text the error has gone and the edmx has been updated correctly.

No idea why it does not want to delete automatically.

Kats2512 · Answer 2 · 2018-04-16T21:25:00

Solution 2

Deleted association from the XML file since it was not being deleted/updated automatically when the association was deleted/updated in the database.

Posted 16-Apr-18 21:25pm

Kats2512

sonu roy · Answer 3 · 2018-08-01T20:22:00

Solution 3

remove the particular table from model browser..in both model.store ande entity .
After that add again the same table..it will work

Posted 1-Aug-18 20:22pm

sonu roy

Comments

Kats2512 2-Aug-18 2:39am

Read solution 2, I have already found a way around this issue.

I did try your way but that does not work.