我有一个很长的 Linq To Entities 查询:-
reports = db.CallProfileDailies
.Join(db.ReportDailyTotals,
cpd => cpd.Date,
rdt => rdt.Date,
(cpd, rdt) => new { cpd = cpd, rdt = rdt })
.Where(a => a.cpd.Skill == a.rdt.Skill)
.Join(db.SummaryIntervalTotals,
a => a.rdt.Date,
sit => sit.Date,
(a, sit) => new { cpd = a.cpd, rdt = a.rdt, sit = sit })
.Where(a => a.rdt.Skill == a.sit.Skill)
.Select((a, i) => new ReportModel
{
AverageAbandonDelay = a.sit.AvgAbanTime,
AverageAfterCallWorkTime = a.sit.AvgAcwTime,
AverageHandleTime = (a.sit.AvgAcwTime + a.sit.AvgAcdTime),
AverageSpeedOfAnswer = a.sit.AvgSpeedAns,
AverageTalkTime = a.sit.AvgAcdTime,
CallsAnswered = a.sit.AcdCalls,
Date = a.sit.Date.ToString(),
MaximumDelay = a.sit.MaxDelay,
PercentageAbandon = (a.sit.AbanCalls / (a.sit.AcdCalls + a.sit.AbanCalls)),
TotalCallsAbandon = a.sit.AbanCalls,
TotalCallsOffered = (a.sit.AcdCalls + a.sit.AbanCalls),
TotalHandleTime = (a.rdt.HoldTime + a.rdt.AcdTime + a.rdt.AcwTime)
}).Take(5).ToList();
我在运行时收到以下错误:-
LINQ to Entities 无法识别
方法
'System.Linq.IQueryable`1[ExpediaReports.Models.ReportModel]
选择[f_AnonymousType1`3,ReportModel](System.Linq.IQueryable`1[f_AnonymousType1`3[ExpediaReports.CallProfileDaily,ExpediaReports.ReportDailyTotal,ExpediaReports.SummaryIntervalTotal]],
System.Linq.Expressions.Expression`1[System.Func`3[f__AnonymousType1`3[ExpediaReports.CallProfileDaily,ExpediaReports.ReportDailyTotal,ExpediaReports.SummaryIntervalTotal],System.Int32,ExpediaReports.Models.ReportModel]])'
方法,并且该方法不能
翻译成商店表达式。
我只是想了解这个错误是什么意思。我什至无法读取它(Linq To Entities)无法识别的方法。
如何读取此错误并识别无法识别的方法,以便我可以相应地更改我的查询?
这些字符在这里意味着什么:`'等。