Build an element with a query : Query « XML LINQ « VB.Net






Build an element with a query

  

Imports System.Collections.Generic

Class Car
  Public PetName As String
  Public ID As Integer
End Class

Module Program
  Sub Main()
    Dim data As New List(Of Car)
    data.Add(New Car With {.PetName = "A", .ID = 10})
    data.Add(New Car With {.PetName = "Pat", .ID = 11})
    data.Add(New Car With {.PetName = "Danny", .ID = 12})
    data.Add(New Car With {.PetName = "B", .ID = 13})

    Dim vehicles As XElement = _
      <Inventory>
        <%= From c In data _
          Select <Car ID=<%= c.ID %>>
                   <PetName><%= c.PetName %></PetName>
                 </Car> %>
      </Inventory>

    Console.WriteLine(vehicles)

  End Sub


End Module

   
    
  








Related examples in the same category

1.Build a query to join the two XML trees on the employee's Id.
2.Loop through all the Employee nodes and insert the new 'TerminationDate' node and the 'Status' attribute
3.Loop through all the HourlyRate elements, setting them to the new payrate, which is the old rate * 5%.
4.Loop through all of the Employee elements and remove the HireDate element.
5.Loop through a node in Xml document
6.Query Xml document by Node value
7.Query for all of the employees that make (HourlyRate) more than $100 an hour
8.Query the XML Tree and get the Name and Hourly Rate elements.
9.Use LINQ to get the tasks for each employee and order them by the employee's name.
10.Using For Each to loop through the result of Xml query
11.Display the employee names and their hourly rate
12.Display the employee names and their new hourly rate.
13.Execute the query and loop through the results, displaying the Information to the screen.
14.Creating new Xml element in the query