表A
======
tbid int
tbName nvarchar(50)
表B
parentId int ,
childrenId int
referenceName nvarchar(50)
sql语句
select * from A t1 left join B t2 on t1.tbid =t2.parentId or t1.tbid =t2.childrenid
问linq 语句如何写?
相关分类