Getting an Error while adding a strongly typed view

Sthitaprajnya Debasis Nayak

10y1.1k.NET

Hi Friends !!!

please help me out.

Model class

[Table("tbl_Employee")]

public class Employee

{

[key]

public int EmpID { get; set; }

public string Name { get; set; }

public string Gender { get; set; }

public string City { get; set; }

}

controller class Action Methode

public ViewResult HyperLink()

{

EmployeeDBContext objEmployeeDbContext = new EmployeeDBContext();

List Employees = objEmployeeDbContext.Employees.ToList();

return View(Employees);

}

While I am trying to add a Strongly typed view to this Action method I am getting an error like below

" MVCDemo.Models.Employee:: Entity type "Employee" has no key defiened. Define the key for this entity type ."

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sthitaprajnya Debasis Nayak10y ago
Thanks Rajeev. I have tried this but still getting the same error.
Rajeev Punhani10y ago
Hi Sthitaprajnya,

The problem with entity framework is that it can work with primary key.By default it recognises Id as primary key ,if column name is not Id then we need to specify which column is primary key.

You need to add 2 namespaces for the above.
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

Also i could see that [key] attribute is case sensitive,So make the above changes it will work.

[Table("tbl_Employee")]
public class Employee
{
[Key]
public int EmpID { get; set; }
public string Name { get; set; }
public string Gender { get; set; }
public string City { get; set; }
}
If the above solution is helpful then,accept the answer.