Visual Basic 2015 Unleashed

Building Complex Queries with Anonymous Types

Same as you would do with other LINQ providers, you can build complex queries taking advantage of anonymous types in LINQ to DataSets. The following code shows how you can join information from the Orders and Order_Details tables retrieving information on order details for each order made by the given customer. Projection is accomplished by generating anonymous types:

Click here to view code image

Private Sub QueryOrderDetails(CustomerID As String)    Dim query = From ord In NwindDataSet.Orders                Where ord.CustomerID = CustomerID                Join det In NwindDataSet.Order_Details                On det.OrderID Equals ord.OrderID                Select New With {.OrderID = ord.OrderID, ...