SQL语句转换成linq语句或者lamda表达式
0
[待解决问题]
select A.* from A,B,C where A.BId=B.Id and B.CId=C.Id and C.Province='天津'
所有回答(2)
0
var query1 =
from
a in A
join
b in B
join
c in C
on a.Bid equals b.id on b.Cid equals c.Id on c.Province equals '天津'
select a;
0
按道理上述应该不和逻辑，按照不合逻辑的翻译如下
A.Select(t=>t.Id==B.Id && ........)
符合逻辑如下
A.Select(t=>B.Any(g=>g.Id==t.Id) && ........)