读书人

在 LINQ to Entities 查询中无法构造实

发布时间: 2013-11-26 22:51:31 作者: rapoo

在 LINQ to Entities 查询中无法构造实体或复杂类型
我要做一个链接查询left join


ViewBag.List = (from a in Member
join b in MemberInfo on a.MemberId equals b.MemberId into ab
from c in ab.DefaultIfEmpty(new MemberInfo() { RealName = "hehe" })
select new { a.MemberId, c.RealName }).ToList();

直接报错呢
[解决办法]
第一个问题:

ViewBag.List = (from a in Member
join b in MemberInfo on a.MemberId equals b.MemberId into ab
from c in ab.DefaultIfEmpty()
select new { a.MemberId, RealName =c==null?"hehe":c.RealName }).ToList();


第二个问题:
返回结果不要使用匿名类即可

读书人网 >asp.net

热点推荐