使用实体框架lambda表达式在mvc中获取记录 [英] Get record in mvc using entity framework lambda expression

问题描述

EntityFramework.dll中出现'System.InvalidOperationException'类型的异常，但未在用户代码中处理



附加信息：实体类型Employee不是当前背景下的模型。



我的代码：

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

Additional information: The entity type Employee is not part of the model for the current context.

MY CODE:

public ActionResult Details(int id)
        {
            EmployeeContext employeeContext = new EmployeeContext();
            Employee employee = employeeContext.Employees.Single(emp => emp.EmployeeId == id);
            return View(employee);
        }

============================== =============

===========================================

namespace MVCDemo.Models
{
    public class EmployeeContext:DbContext
    {
        public DbSet<Employee> Employees { get;set; }
    }
}

======================== ==========

< add name =EmployeeContextconnectionstring =metadata = res：//*/Model1.csdl | res：//*/Model1.ssdl | res：//*/Model1.msl; provider = System.Data.SqlClient; provider connection string =data source = XEVOKE-PC; initial catalog = Sample; integrated security = True; MultipleActiveResultSets = True; App = EntityFramework providername =System.Data.EntityClient>

=============================== ======

==================================
<add name="EmployeeContext" connectionstring="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string="data source=XEVOKE-PC;initial catalog=Sample;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"" providername="System.Data.EntityClient">
=====================================

namespace MVCDemo.Models
{
    [Table("tblEmployee")]
    public class Employee
    {
        public int EmployeeId { get; set; }
        public string Name { get; set; }
        public string Gender { get; set; }
        public string City { get; set; }
    }
}

推荐答案

public ActionResult Details(int id)
        {
            EmployeeContext employeeContext = new EmployeeContext();
Employee employee = (Employee)(from emp in employeeContext.Members where emp.EmployeeId == id select emp).FirstOrDefault()
            return View(employee);
        }

希望这肯定会有所帮助。

Hope this will definitely of help.

这篇关于使用实体框架lambda表达式在mvc中获取记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！