我在LINQPad中测试过以下查询,它可以正常运行,但是VS2010不喜欢它。
var topJobs = from j in streetlightDBEntities.Job
let mjobid = from m in streetlightDBEntities.Job.Include("Streetlight")
where m.Streetlight.StreetlightId == j.Streetlight.StreetlightId
orderby m.DateCompleted descending
select m.JobId
where mjobid.Take(5).Contains(j.JobId)
select j.JobId;
var notTopJobs = streetlightDBEntities.Job.Where(c => !topJobs.Contains(c.JobId));
我遇到了以下错误:
LINQ to Entities 不认识方法 'Boolean Contains[String](System.Linq.IQueryable`1[System.String], System.String)',这个方法不能被转换成存储表达式。