实体或复杂类型'SJAMsSynchMetroModel.tblActionItem'不能在 LINQ to 实体查询中构造

Question

我有一个具有多个关系的表，我正试图显示来自两个不同表的多个列。我有一个linq语句，但是当我运行此代码时，我会得到以下错误：

实体或复杂类型"SJAMsSynchMetroModel.tblActionItem"不能可以在LINQ to Entities查询中构造。

我的代码：

public ActionResult ActionItems(string Status)
{
tblActionItem actionitems = new tblActionItem();
if (Status == null)
{
var incc = (from sa in db.tblActionItems
join trid in db.tblTripReports on sa.TripReportID equals trid.tripreportID
join cust in db.tblCustomers on trid.Customer_ID equals cust.CustomerID
join emp in db.tblEmployees on cust.EmployeeID equals emp.EmployeeID
select
new tblActionItem
{
Status = sa.Status,
Action_Item = sa.Action_Item,
Owners = sa.Owners,
Due_Date = sa.Due_Date,
Updated = sa.Updated,
CreateDate = sa.CreateDate,
Sales = emp.Sales
}).ToList();
return View(incc);
//return View(db.tblActionItems.ToList());
}
}

Answer 1

您可能应该使用一个中间状态。

var intermediate = (from sa in db.tblActionItems
join trid in db.tblTripReports on sa.TripReportID equals trid.tripreportID
join cust in db.tblCustomers on trid.Customer_ID equals cust.CustomerID
join emp in db.tblEmployees on cust.EmployeeID equals emp.EmployeeID
select
new 
{
Status = sa.Status,
Action_Item = sa.Action_Item,
Owners = sa.Owners,
Due_Date = sa.Due_Date,
Updated = sa.Updated,
CreateDate = sa.CreateDate,
Sales = emp.Sales
}).ToList();
var result = intermediate.Select(x=> new tblActionItem {
Status = x.Status,
Action_Item = x.ActionItem,
Owners = x.Owners,
Due_Date = x.DueDate;
Updated =x.Update,
CreateDate = x.CreateDate,
Sales = x.Sales
});