sql语句写成vb.net 的linq语句。来帮帮小弟我吧
日期：2014-05-20 浏览次数：20937 次
sql语句写成vb.net 的linq语句。。求助求助，来帮帮我吧。
select Mainid ,secondNo2,thirdNo2,fourNo2 from(
select * from(
select * from Main as t1 left join Sec as t2 on t1.MainNo1 = t2.secondNo1) as a
left join Third on a.MainNo2=Third.thirdNo1) as b
left join Four on b.MainNo3 = Four .fourNo1
怎么写成vb.net 的linq语句啊。。。好心人帮帮吧。真心不会了
------解决方案--------------------
select Mainid ,secondNo2,thirdNo2,fourNo2 from(
select * from(
select * from Main as t1 left join Sec as t2 on t1.MainNo1 = t2.secondNo1) as a
left join Third on a.MainNo2=Third.thirdNo1) as b
left join Four on b.MainNo3 = Four .fourNo1
怎么写成vb.net 的linq语句啊。。。好心人帮帮吧。真心不会了
VB.NET
LINQ
SQL
------解决方案--------------------
Dim query = From b In (From a In (From t1 In MainJoin t2 In Sec On t1.MainNo1 = t2.secondNo1 Into lg1From t2 In lg1.DefaultIfEmpty()t1)Join td In Third On a.MainNo2 = td.thirdNo1 Into lg2From td In lg2.DefaultIfEmpty()a)Join f In Four On b.MainNo3 = f.fourNo1 Into lg3From f In lg3.DefaultIfEmpty()New With { _
b.Mainid, _
b.secnondNo2, _
b.thridNo2, _
Key .fourNo2 = If(f Is Nothing, 0, f.fourNo2) _
}
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
