我正在尝试检索列表EmployeeDTO
来自存储在 Employee 表中的数据库。每个员工都可以拥有一项或多项专长。专业存储在OrganizationSpecialtyType
. Employee
and OrganizationSpecialtyType
与“多对多”相关EmployeeSpecialty
table.
我使用以下查询来实现此目的,并得到了如标题所示的异常:
var q = _context.Employee.Where(p => employeeEMIIDs.Contains(p.EmployeeID))
.Select(p => new EmployeeDTO
{
EmployeeID = p.EmployeeID,
GenderTypeID = p.GenderTypeID,
FirstName = p.FirstName,
LastName = p.LastName,
Name = p.Name,
MiddleName = p.MiddleName,
DOB = p.DOB,
Suffix = p.Suffix,
Title = p.Title,
Specialty = p.EmployeeSpecialty
.ToDictionary(d => d.OrganizationSpecialtyType.SpecialtyTypeID, d => d.OrganizationSpecialtyType.Name)
}
);
In the EmployeeDTO
财产类别Specialty
是类型public Dictionary<int, string>
.
如果我执行此查询,一切正常:
var spec = _context.Employee.Where(p => p.EmployeeID == -9070).FirstOrDefault()
.EmployeeSpecialty.ToDictionary(d =>
d.OrganizationSpecialtyType.SpecialtyTypeID,
d => d.OrganizationSpecialtyType.Name);
我如何解决我的第一个查询以获得EmployeeDTO
有特长吗?
Thanks.