I am new to MVC. In My Application , I'm Retrieving the Data from Mydatabase. but when I run my Application it show Error Like This this is my url................
https://localhost:17039/ MvcDemo2/Employee/Index/1
One or more validation errors were detected during model generation:
MvcDemo2.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.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.Entity.ModelConfiguration.ModelValidationException: One or more validation errors were detected during model generation:
MvcDemo2.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.
Source Error:
Line 16: { Line 17: EmployeeContext empcontext = new EmployeeContext();
Line 18: Employee employee = empcontext.Employees.Single(emp => emp.emp_id == id);
Line 19: return View( employee); Line 20: }
1);Employee.csBelow are my model classes
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Web;
namespace MvcDemo2.Models
{
[Table("emp127")]
public class Employee
{
[Key]
public int emp_id { get; set; }
public string emp_name { get; set; }
public int emp_salary { get; set; }
}
}
2); EmplyeeContext.cs
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations.Schema;
using System.Data.Entity;
using System.Linq;
using System.Web;
namespace MvcDemo2.Models
{
public class EmployeeContext : DbContext
{
public DbSet<Employee> Employees { get; set; }
}
}
3):EmployeeController.cs
using MvcDemo2.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
namespace MvcDemo2.Controllers
{
public class EmployeeController : Controller
{
//
// GET: /Employee/
public ActionResult Index(int id)
{
EmployeeContext empcontext = new EmployeeContext();
Employee employee = empcontext.Employees.Single(emp => emp.emp_id == id);
return View(employee);
}
}
}
4);Route.config.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Web.Routing;
namespace MvcDemo2
{
public class RouteConfig
{
public static void RegisterRoutes(RouteCollection routes)
{
routes.IgnoreRoute("{resource}.axd/{*pathInfo}");
routes.MapRoute(
name: "Default",
url: "{controller}/{action}/{id}",
defaults: new { controller = "Employee", action = "Index", id = UrlParameter.Optional }
);
}
}
}
5):Index.cshtml
@model MvcDemo2.Models.Employee
@{
ViewBag.Title = "Index";
}
<h2>Index</h2>
<table style="font-family: Arial">
<tr>
<td>
<b>Employee Id</b>
</td>
<td>@Model.emp_id
</td>
</tr>
<tr>
<td>
<b>Employee Name</b>
</td>
<td>@Model.emp_name
</td>
</tr>
<tr>
<td>
<b>Employee Salary</b>
</td>
<td>@Model.emp_salary
</td>
</tr>
</table>
6):Web Config
<?xml version="1.0" encoding="utf-8"?>
<!--
For more information on how to configure your ASP.NET application, please visit
https://go.microsoft.com/fwlink/?LinkId=169433
-->
<configuration>
<configSections>
<!-- For more information on Entity Framework configuration, visit https://go.microsoft.com/fwlink/?LinkID=237468 -->
<section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
</configSections>
<appSettings>
<add key="webpages:Version" value="2.0.0.0" />
<add key="webpages:Enabled" value="false" />
<add key="PreserveLoginUrl" value="true" />
<add key="ClientValidationEnabled" value="true" />
<add key="UnobtrusiveJavaScriptEnabled" value="true" />
</appSettings>
<system.web>
<httpRuntime targetFramework="4.5" />
<compilation debug="true" targetFramework="4.5" />
<pages>
<namespaces>
<add namespace="System.Web.Helpers" />
<add namespace="System.Web.Mvc" />
<add namespace="System.Web.Mvc.Ajax" />
<add namespace="System.Web.Mvc.Html" />
<add namespace="System.Web.Routing" />
<add namespace="System.Web.WebPages" />
</namespaces>
</pages>
</system.web>
<system.webServer>
<validation validateIntegratedModeConfiguration="false" />
<handlers>
<remove name="ExtensionlessUrlHandler-ISAPI-4.0_32bit" />
<remove name="ExtensionlessUrlHandler-ISAPI-4.0_64bit" />
<remove name="ExtensionlessUrlHandler-Integrated-4.0" />
<add name="ExtensionlessUrlHandler-ISAPI-4.0_32bit" path="*." verb="GET,HEAD,POST,DEBUG,PUT,DELETE,PATCH,OPTIONS" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness32" responseBufferLimit="0" />
<add name="ExtensionlessUrlHandler-ISAPI-4.0_64bit" path="*." verb="GET,HEAD,POST,DEBUG,PUT,DELETE,PATCH,OPTIONS" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness64" responseBufferLimit="0" />
<add name="ExtensionlessUrlHandler-Integrated-4.0" path="*." verb="GET,HEAD,POST,DEBUG,PUT,DELETE,PATCH,OPTIONS" type="System.Web.Handlers.TransferRequestHandler" preCondition="integratedMode,runtimeVersionv4.0" />
</handlers>
</system.webServer>
<entityFramework>
<defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
</defaultConnectionFactory>
</entityFramework>
<connectionStrings>
<add name="EmployeeContext"
connectionString="Server=ANKIT-PC;Database=batch9;integrated security=True;"
providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>
7):Databse -Table Script
CREATE TABLE[dbo].[emp127](
[emp_id]
[int]
primary key IDENTITY(1,1) NOT NULL,
[emp_name] [varchar](40) NULL,
[emp_salary]
[int]
NULL
)
