我使用实体框架与Linq使用左连接。我尝试了很多代码。但是得到错误。我的代码如下:
var ABC = (from p in AgEntities.tbl_PrayerRequest
join u in AgEntities.tbl_UserMaster
on p.User_IndexID equals u.User_IndexID into lj
from s in lj.DefaultIfEmpty()
select new { p.RequestID, p.RequestName, p.RequestEmail, s.User_LoginID }).ToList();
但是我得到了下面的错误。
错误:LINQ to Entities不识别该方法。
System.Collections.Generic。IEnumerable
1[Solution.Bussines.Entities.tbl_UserMaster] DefaultIfEmpty[tbl_UserMaster](System.Collections.Generic.IEnumerable
[solution . businesses . entities . tbl_usermaster])'方法,该方法不能转换为存储表达式
var ABC = (from p in AgEntities.tbl_PrayerRequest
join u in AgEntities.tbl_UserMaster
on p.User_IndexID equals u.User_IndexID into lj
from s in lj.DefaultIfEmpty()
select new { p.RequestID, p.RequestName, p.RequestEmail,
User_LoginID =s==null?0: s.User_LoginID }).ToList();