在vb.net中使用LINQ的新手问题

Imports System.Linq

Dim numbers = {1, 2, 3, 4, 5}

Dim result = From n In numbers
              Where n Mod 2 = 0
              Select n

For Each num In result
    Console.WriteLine(num)
Next

Imports System.Data.Linq

Dim db As New DataContext("connectionString")

Dim customers = From c In db.Customers
                Where c.City = "London"
                Select c

For Each customer In customers
    Console.WriteLine(customer.Name)
Next

Dim numbers = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10}

Dim pageSize = 3
Dim currentPage = 2

Dim result = numbers.Skip((currentPage - 1) * pageSize).Take(pageSize)

For Each num In result
    Console.WriteLine(num)
Next

Dim numbers = {5, 3, 8, 4, 2, 7, 1, 9, 6}

Dim result = From n In numbers
              Order By n Descending
              Select n

For Each num In result
    Console.WriteLine(num)
Next

Imports System.Linq

Dim customers = {
    New With {.Name = "John", .City = "London"},
    New With {.Name = "Jane", .City = "London"},
    New With {.Name = "Bob", .City = "Paris"},
    New With {.Name = "Alice", .City = "Paris"}
}

Dim result = From c In customers
              Group By c.City Into Customers = Group
              Select City, Customers

For Each group In result
    Console.WriteLine("City: " & group.City)
    For Each customer In group.Customers
        Console.WriteLine("  " & customer.Name)
    Next
Next