linq 左连接问题

[放羊娃儿]

var query = from g in wfEntities.prepay
join p in wfEntities.project on g.ProjectCode equals p.Code
join u in wfEntities.userinfo on g.PrepayUser equals u.ID
join h in wfEntities.userinfo on g.HandlerUserId equals h.ID into ght
from gh in ght.DefaultIfEmpty()
select new PrepayInfoDTO
{
Id = g.Id,
Amount = g.Amount,
PrepayCode = g.PrepayCode,
PrepayDate = g.PrepayDate,
PrepayUser = g.PrepayUser,
PrepayUserName = u.FullName,
HandlerUserId = gh == null ? 0 : gh.ID,
HandlerUserName = gh == null ? "" : gh.FullName,
ProjectCode = g.ProjectCode,
ProjectName = p.Name,
UseNotes = g.UseNotes,
DataState = g.DataState
};
这样子出现了“LINQ to Entities 不识别方法“System.Collections.Generic.IEnumerable”这样的问题？有人知道吗？

[Lancc1314]

太复杂了，没写过怎么繁琐的linq

[threenewbee]

select PrepayInfoDTO 这个要删除，返回匿名类型

[moonwrite]

using System.Collections.Generic; using System.Linq; using System.Data.Entity; 还有添加EntityFramework.dll了么

[放羊娃儿]

引用 1 楼 caozhy 的回复:

select PrepayInfoDTO 这个要删除，返回匿名类型

跟这个无关，我试了，还是一样出错