Here we will see that how to
declare a temporary variable inside the LinQ Query using Let keyword.
The Let Keyword
LINQ has a keyword let that allow
one to create temporary variable inside the query and perform the required
action. We can assign the result of manipulation to temporary variable inside
query and we can use that temporary variable to another manipulation.
Using Let keyword
Taking two two integer array that
is Arrayfirst,
arraysecond.
Dim Arrayfirst As Integer() = New Integer() {1, 2, 3}
Dim Arraysecond As Integer() = New Integer() {1, 2, 3}
Now using Let keyword to find
square value which are greater then 4.
Dim Squares = From Queryfirst
In Arrayfirst From
Querysecond In Arraysecond
Let TheSquare = Queryfirst * Querysecond
Where TheSquare > 4
Select Queryfirst, Querysecond, TheSquare
For example
Let's take a simple example of
Linq query I am using two integer array to find square and after finding the
square of the integer value I will use let keyword to find square value which
are greater then 4.
Module Module1
Sub Main()
Dim Arrayfirst As Integer() = New Integer() {1, 2, 3}
Dim Arraysecond As Integer() = New Integer() {1, 2, 3}
Dim Squares = From
Queryfirst In Arrayfirst
From Querysecond In
Arraysecond
Let TheSquare = Queryfirst * Querysecond
Where TheSquare > 4
Select Queryfirst, Querysecond, TheSquare
For Each
ThisSquare In Squares
Console.WriteLine(ThisSquare.TheSquare.ToString())
Next
End Sub
End Module
OUTPUT
