Get all cars. Similar to Select * in SQL : Query « LINQ « VB.Net






Get all cars. Similar to Select * in SQL

  

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 allCars = From c In myCars Select c
        For Each c In allCars
            Console.WriteLine("Car: {0}", c)
        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 differences
11.Get only the pet names
12.Join Person and Salaries lists to get the max and min salary
13.Join two object lists together
14.Reflector Linq result
15.Using where clause to check the first name of a Persion
16.Select by a Property
17.Select by object id
18.Query String Array With Operators