EF 多条件 加常量 左连接怎么写?在线等,急急急!!!!
select a.*,b.ID as id3,b.Name as name3,c.Name as name2,c.ID as ID2,d.Name as name1,d.ID id1
from good_StyleTag as a
left join good_Tag as b on a.TagID=b.ID and b.[Level]=3
left join good_Tag as c on (b.ParentID=c.ID ) or (a.TagID=c.ID and c.Level=2)
left join good_Tag as d on (c.ParentID=d.ID ) or (a.TagID=d.ID and d.Level=1)
where a.StyleID='A01002'
我想要达到这个sql,请问ef ling查询怎么写?