Entitytype 'employee' has no key defined. Define the key for this entitytype. Employees: entitytype: entityset 'employees' is based on type 'employee' that has no keys defined.

Question

1.00/5 (1 vote)

See more:

One or more validation errors were detected during model generation:

mvcstarted.Models.employee: : EntityType 'employee' has no key defined. Define the key for this EntityType.
employees: EntityType: EntitySet;employees; is based on type;employee; that has no keys defined.

public ActionResult Details(int id)
{
employeecontext empt = new employeecontext();
employee emptt = empt.employees.Single(emp => emp.Emp_id== id);

return View(emptt);
}

What I have tried:

i have tried so much time until now but issue still arrising as above please suggest me what can i do further

Posted 22-Aug-16 22:28pm

jay49

Updated 4-Aug-21 1:06am

Add a Solution

Comments

phil.o 23-Aug-16 4:34am

Did you try to give a primary key to your Employee table?

jay49 23-Aug-16 5:19am

how can solve this pls suggest me ...still until nw this problem arrised hw can solve it

jay49 23-Aug-16 5:21am

i have select (Emp_id) as a primary key in sql server 2016..so what does

phil.o 23-Aug-16 5:41am

There is a delta between what you tell me (Employee table has a primary key) and the message you get (entity has no primary key).
Did you try to update your datasource to reflect most recent changes to your entities?

jay49 23-Aug-16 5:50am

i have done also it update that datasource but still problem arrised

phil.o 23-Aug-16 5:53am

Try to browse this SO Post : SO EntityType has no key defined error

jay49 23-Aug-16 5:54am

oky i would try this

jay49 23-Aug-16 6:00am

An exception of type 'System.TypeInitializationException' occurred in EntityFramework.dll but was not handled in user code

Additional information: The type initializer for 'System.Data.Entity.Internal.AppConfig' threw an exception....

after done this this type of error should be arrising ....

jay49 23-Aug-16 6:04am

pls what can i do for this suggest me

phil.o 23-Aug-16 6:27am

I suggest you to search for this specific error message in your favorite search engine. I don't have any idea of your configuration/project, and I'm quite bad at guessing.

jay49 23-Aug-16 6:10am

An exception of type 'System.TypeInitializationException' occurred in EntityFramework.dll but was not handled in user code

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)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 1 · 2016-08-23T01:52:00

Solution 1

Check out my blog - EntityType: EntitySet ‘[Entity Name]’ is based on type ‘[Entity Name]’ that has no keys defined[^]

Posted 23-Aug-16 1:52am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Updated 8-Aug-23 4:51am

v3

Yahya Mohammed Ammouri · Answer 2 · 2017-03-01T01:05:00

Solution 2

You need to do two things(this is related to code first approach):

1- Determine the primary key

[Key]
public int BidYearID { get; set; }

2- you have to build your solution then try to add the view

Posted 1-Mar-17 1:05am

Yahya Mohammed Ammouri

Comments

CHill60 1-Mar-17 11:57am

Doesn't add anything to the answer provided 6 months ago

Yahya Mohammed Ammouri 1-Mar-17 23:51pm

The new addition is you have to build the project after adding the [key] attribute.

This is what I faced myself; I have Data classes in separate DAL project and it didn't work until I re-build the DAL project.

Member 15312752 · Answer 3 · 2021-08-04T01:06:00

I was facing this error because of column name in table and properties name in the entity class were not matching.Ensure that table name is either matching or you are using table attribute in case table name and entity class name is not matching. Database name should match too I guess not sure abot that..