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
Distinct: Removes duplicate elements from a collection.
| Distinct: Removes duplicate elements from a collection. |
| Distinct: Removes duplicate elements from a collection. |
| This Lambda Expression sample takes only distinct numbers from array. |
| This Lambda Expression sample takes only distinct numbers from array. |
static void Sample_Distinct_Linq()
{
int[] numbers = { 1, 2, 2, 3, 5, 6, 6, 6, 8, 9 };
var result = (from n in numbers.Distinct()
select n);
Debug.WriteLine("Distinct removes duplicate elements:");
foreach (int number in result)
Debug.WriteLine(number);
}
Output: Distinct removes duplicate elements: 1 2 3 5 6 8 9
Private Shared Sub Sample_Distinct_Linq()
Dim numbers As Integer() = {1, 2, 2, 3, 5, 6, 6, 6, 8, 9}
Dim result = (From n In numbers
Distinct
Select n)
Debug.WriteLine("Distinct removes duplicate elements:")
For Each number As Integer In result
Debug.WriteLine(number)
Next
End Sub
Output: Distinct removes duplicate elements: 1 2 3 5 6 8 9
let Sample_Distinct_Linq() =
let numbers = [|1; 2; 2; 3; 5; 6; 6; 6; 8; 9|]
let result = query {
for n in numbers do
distinct
select n
}
Debug.WriteLine(sprintf "Distinct removes duplicate elements:")
for number in result do
Debug.WriteLine(sprintf "%d" number)
Output: Distinct removes duplicate elements: 1 2 3 5 6 8 9
static void Sample_Distinct_Lambda()
{
int[] numbers = { 1, 2, 2, 3, 5, 6, 6, 6, 8, 9 };
var result = numbers.Distinct();
Debug.WriteLine("Distinct removes duplicate elements:");
foreach (int number in result)
Debug.WriteLine(number);
}
Output: Distinct removes duplicate elements: 1 2 3 5 6 8 9
Private Shared Sub Sample_Distinct_Lambda()
Dim numbers As Integer() = {1, 2, 2, 3, 5, 6, 6, 6, 8, 9}
Dim result = numbers.Distinct()
Debug.WriteLine("Distinct removes duplicate elements:")
For Each number As Integer In result
Debug.WriteLine(number)
Next
End Sub
Output: Distinct removes duplicate elements: 1 2 3 5 6 8 9
let Sample_Distinct_Lambda() =
let numbers = [|1; 2; 2; 3; 5; 6; 6; 6; 8; 9|]
let result = numbers.Distinct()
Debug.WriteLine(sprintf "Distinct removes duplicate elements:")
for number in result do
Debug.WriteLine(sprintf "%d" number)
Output: Distinct removes duplicate elements: 1 2 3 5 6 8 9