linq调用mysql函数_c# – linq exception：只能从LINQ to Entities调用此函数

我正在尝试获取保存在缓存中的数据.但它会在“select new FilteRSSrsLog”行中引发异常.例外：此函数只能从LINQ到实体调用

List reportServerDB = UpdateCache();

var reportLog = (from r in reportServerDB

orderby r.TimeStart descending

where ((model.reportName == null ? true : r.ItemPath.Contains(model.reportName)) &&

(model.reportFolder == null ? true : r.ItemPath.Contains(model.reportFolder)) &&

(r.TimeStart >= startDateTime) &&

(r.TimeStart <= endDateTime)

)

select new FilteRSSrsLog

{

UserName = r.UserName,ReportName = r.ItemPath,ReportFolder = r.ItemPath,Format = r.Format,Parameters = r.Parameters,TimeStart = r.TimeStart,TimeEnd = r.TimeEnd,TotalTime = EntityFunctions.DiffMilliseconds(r.TimeStart,r.TimeEnd)

});

如果我删除“选择新的FilteRSSrsLog”代码块并写入“select r”它可以工作.但我只需要那些颜色,那么我该怎么做才能解决这个问题呢？