c# - mvc 上的 Linq 查询错误

Question

public class Employee
{
    [Key]
    public int EmployeeID { get; set; }
    public string Name { get; set; }
    public int DesignationID { get; set; }

    public virtual Designation Designation { get; set; }
}


(from emp in dc.Employee 
    select new Employee { Employee = emp , Designation = emp.Designation }).Single();

它给我错误 “Models.Employee does not contain a definition for Employee” on the line Employee = emp

Answer 1

所以它很简单，就像错误所说的那样，您的模型不包含 Employee 的定义，因此您应该这样写:

(from emp in dc.Employee 
    select new Employee { Name = emp.Name ,...

如果你想要一个员工对象，你可以像这样创建一个 View 模型:

public class EmployeeViewModel
{
    public Employee Employee {get; set;}
    public Designation Designation {get; set;}
}

然后这样写你的查询:

select new EmployeeViewModel { Employee = emp , Designation = emp.Designation }).Single();