LINQ to VB. NET

 

Some users have asked if the [idea-. NET Framework 3.5 Data Development Guide] has the VB. NET version,

This depends on the publishing house. Generally, if a review is not completed, it is unlikely that the publishing house will invest in data for publishing.

For the same subject, but for different languages, there will be no VB. NET version, depending on the volume of arguments.

Anywhere, I have always had a plan to change the examples in this tutorial to the VB. NET version. If the VB. NET version can

For example, the example published by Li can be put in this example.

If the press still does not allow me to publish the VB. NET version after a review, I can put examples in the blog at any time

If this parameter is set, the VB. NET protocol is used.

In fact, in terms of the LINQ into method, the difference between VB. NET and C # is not big. You can see the following program.

 

Imports system. LINQ public class program shared sub main () testjoin () end sub 'let operation operator shared sub uselet () dim list as string () = {"code6421 Huang ", "Tom do", "Cathy Chang"} dim result = From S1 in list _ let words = s1.split ("") _ from word in words _ Let W = word. tolower () _ where W (0) = "C" _ select word for each item in result console. writeline (item) Next console. readline () end sub 'lambda expression for VB.net shared sub testlastwithcondition () dim numbers () = {8, 9, 10, 7} console. writeline (numbers. last (function (x) x> 7) console. readline () end sub 'anonymous' join formula shared sub testjoin () dim p1 () = {New {. name = "code6421 ",. address = "taipai"}, _ new {. name = "Tom ",. address = "taipai"}, _ new {. name = "jeffray ",. address = "NY"} dim P2 () = {New {. name = "code6421 ",. title = "manager"}, _ new {. name = "Tom ",. title = "director"}, _ new {. name = "jeffray ",. title = "programmer" }}dim P3 () = {New {. name = "code6421 ",. hand = "right"}, _ new {. name = "Tom ",. hand = "right"}, _ new {. name = "jeffray ",. hand = "Left"} dim P4 = from S in P1 _ join S1 in P2 on S. name equals s1.name _ join S2 in P3 on S. name equals s2.name _ select new {. name = S. name ,. address = S. address ,. title = s1.title ,. hand = s2.hand} for each item in P4 console. writeline ("name {0}, address {1}, title {2}, hand {3}", item. name, item. address, item. title, item. hand) Next console. readline () end sub end class

 

The difference between the lambda Evaluate Method in the testlastwithcondition program and the select new (anonymous) Evaluate Method in testjoin.