Select by object id : Query « LINQ « VB.Net






Select by object id

  

Imports System.Collections.Generic
Imports System.Linq

Imports System.Runtime.CompilerServices

Public Class Person
    Public ID As Integer
    Public IDRole As Integer
    Public LastName As String
    Public FirstName As String
End Class


Module Module1

    Sub Main()
        Dim people As New List(Of Person)(New Person() { _
            New Person With {.ID = 1, .IDRole = 1, .LastName = "A", .FirstName = "Brad"}, _
            New Person With {.ID = 2, .IDRole = 2, .LastName = "G", .FirstName = "Tom"} _
        })


        Dim query = From p In people Where p.ID = 1 Select p


    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 a Property
18.Query String Array With Operators