Aggregation
Aggregate, Average, Count, LongCount, Max, Min, Sum
Conversion
AsEnumerable, Cast, OfType, ToArray, ToDictionary, ToList, ToLookup
Element
ElementAt, ElementAtOrDefault, First, FirstOrDefault, Last, LastOrDefault, Single, SingleOrDefault
ElementAt
ElementAtOrDefault
First (simple)
First (conditional)
FirstOrDefault
Last
LastOrDefault (simple)
LastOrDefault (conditional)
Single
SingleOrDefault
Generation
DefaultIfEmpty, Empty, Range, Repeat
Grouping
GroupBy
Join
GroupJoin, Join
Ordering
OrderBy, OrderByDescending, Reverse, ThenBy, ThenByDescending
OrderBy (simple - numbers)
OrderBy (simple - dates)
OrderBy (simple - objects)
OrderByDescending
Reverse
ThenBy
ThenByDescending
Other
Concat, SequenceEqual, Zip
Partitioning
Skip, SkipWhile, Take, TakeWhile
Projection
Select, SelectMany
Quantifiers
All, Any, Contains
Restriction
Where
Set
Distinct, Except, Intersect, Union
Close
Where: Filters elements from a collection to satisfy a specified condition.
| Where: Filters elements from a collection to satisfy a specified condition. |
| Where: Filters elements from a collection to satisfy a specified condition. |
| This Lambda Expression sample finds numbers with values >= 15 and values <= 25. |
| This Lambda Expression sample finds numbers with values >= 15 and values <= 25. |
static void Sample_Where_Linq_Numbers()
{
int[] numbers = { 5, 10, 15, 20, 25, 30 };
var result = from n in numbers
where n >= 15 && n <= 25
select n;
Debug.WriteLine("Numbers being >= 15 and <= 25:");
foreach (var number in result)
Debug.WriteLine(number);
}
Output: Numbers being >= 15 and <= 25: 15 20 25
Private Shared Sub Sample_Where_Linq_Numbers()
Dim numbers As Integer() = {5, 10, 15, 20, 25, 30}
Dim result = From n In numbers Where n >= 15 AndAlso n <= 25
Debug.WriteLine("Numbers being >= 15 and <= 25:")
For Each number In result
Debug.WriteLine(number)
Next
End Sub
Output: Numbers being >= 15 and <= 25: 15 20 25
let Sample_Where_Linq_Numbers() =
let numbers = [5; 10; 15; 20; 25; 30]
let result = query {
for n in numbers do
where (n >= 15 && n <= 25)
}
Debug.WriteLine(sprintf "Numbers being >= 15 and <= 25:")
for number in result do
Debug.WriteLine(sprintf "%d" number)
Output: Numbers being >= 15 and <= 25: 15 20 25
static void Sample_Where_Lambda_Numbers()
{
int[] numbers = { 5, 10, 15, 20, 25, 30 };
var result = numbers.Where(n => n >= 15 && n <= 25);
Debug.WriteLine("Numbers being >= 15 and <= 25:");
foreach (var number in result)
Debug.WriteLine(number);
}
Output: Numbers being >= 15 and <= 25: 15 20 25
Private Shared Sub Sample_Where_Lambda_Numbers()
Dim numbers As Integer() = {5, 10, 15, 20, 25, 30}
Dim result = numbers.Where(Function(n) n >= 15 AndAlso n <= 25)
Debug.WriteLine("Numbers being >= 15 and <= 25:")
For Each number In result
Debug.WriteLine(number)
Next
End Sub
Output: Numbers being >= 15 and <= 25: 15 20 25
let Sample_Where_Lambda_Numbers() =
let numbers = [5; 10; 15; 20; 25; 30]
let result = numbers.Where(fun n -> n >= 15 && n <= 25);
Debug.WriteLine(sprintf "Numbers being >= 15 and <= 25:")
for number in result do
Debug.WriteLine(sprintf "%d" number)
Output: Numbers being >= 15 and <= 25: 15 20 25