62,040
社区成员
发帖
与我相关
我的任务
分享
var queryNew = from i in query
join c in context.ass_ba_category on i.CategoryId equals c.CategoryId
join ic in context.ass_ba_itemcustom on i.ItemId equals ic.ItemId into temp1
from iice in temp1.DefaultIfEmpty()
join l in context.ass_ba_location on i.LocationId equals l.LocationId into temp2
from ile in temp2.DefaultIfEmpty()
select new ass_ba_itemIndexVm()