Equals vs = in query

  

Imports System
Imports System.Collections.Generic
Imports System.Data
Imports System.Linq
Imports System.Text
Imports System.Globalization

Module Example
   Public Sub Main()

      Dim ArrayA As Integer() = New Integer() {1, 2, 3, 4, 8}
      Dim ArrayB As Integer() = New Integer() {1, 3, 5, 7, 8}

      Dim Joined = From QueryA In ArrayA _
                 Join QueryB In ArrayB _
                 On QueryA Equals QueryB _
                 Select QueryA, QueryB

      Console.WriteLine("Join Results:")

      For Each OutPair In Joined
         Console.WriteLine(OutPair.QueryA.ToString() + " - " + _
            OutPair.QueryB.ToString())
      Next


      Dim Joined2 = From QueryA In ArrayA _
                 From QueryB In ArrayB _
                 Where QueryA = QueryB _
                 Select QueryA, QueryB

      Console.WriteLine("Two From Results:")

      For Each OutPair In Joined2
         Console.WriteLine(OutPair.QueryA.ToString() + " - " + _
            OutPair.QueryB.ToString())
      Next


   End Sub 
End Module

Related examples in the same category

1.	Where with a function
2.	Check String start-with value
3.	Query for String length
4.	Filtering (Where): Using a Where clause to find all projects that are out of stock.
5.	Where Drilldown
6.	Find files created within the last year
7.	Linq to query File System: shows all mapped network drives
8.	Shows all public methods in an assembly, with duplicates removed
9.	Shows all public methods in an assembly.
10.	Filtering Numbers
11.	Indexed Where
12.	An indexed Where clause that returns digits whose name is shorter than their value

Equals vs = in query : Where « LINQ « VB.Net

Related examples in the same category