Select by a Property

  

Public Class Car
  Public PetName As String = String.Empty
  Public Color As String = String.Empty
  Public Speed As Integer
  Public Make As String = String.Empty

  Public Overloads Overrides Function ToString() As String
    Return String.Format("Make={0}, Color={1}, Speed={2}, PetName={3}", Make, Color, Speed, PetName)
  End Function
End Class

Module Program

  Sub Main()
    Dim myCars As New List(Of Car)(New Car() { _
    New Car With {.PetName = "D", .Color = "Silver", .Speed = 100, .Make = "BMW"}, _
    New Car With {.PetName = "C", .Color = "Tan", .Speed = 90, .Make = "BMW"}, _
    New Car With {.PetName = "B", .Color = "Rust", .Speed = 5, .Make = "Yugo"}, _
    New Car With {.PetName = "A", .Color = "White", .Speed = 43, .Make = "Ford"}})

    Dim onlyBMWs = From c In myCars Where c.Make = "BMW" Select c
    For Each n In onlyBMWs
      Console.WriteLine("Name: {0}", n)
    Next
  End Sub
End Module

Related examples in the same category

1.	Convert Linq result to Array
2.	Convert Linq result to List
3.	Linq Over Array
4.	Linq Over int Array
5.	A select statement against object list
6.	Filter by name length
7.	Find the cars that are going less than 55 mph, and order by descending PetName
8.	Create a query expression
9.	Convert query to a list of string
10.	Get all cars. Similar to Select * in SQL
11.	Get differences
12.	Get only the pet names
13.	Join Person and Salaries lists to get the max and min salary
14.	Join two object lists together
15.	Reflector Linq result
16.	Using where clause to check the first name of a Persion
17.	Select by object id
18.	Query String Array With Operators

Select by a Property : Query « LINQ « VB.Net

Related examples in the same category