LINQSamples.com
  • Samples
  • Tutorials
  • About
  • Links
  • Contact
LINQ to Objects

Aggregation

Aggregate, Average, Count, LongCount, Max, Min, Sum

      Aggregate (simple)       Aggregate (seed)       Average       Count       LongCount       Max       Min       Sum

Conversion

AsEnumerable, Cast, OfType, ToArray, ToDictionary, ToList, ToLookup

      AsEnumerable       Cast       OfType       ToArray       ToDictionary (simple)       ToDictionary (conditional)       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

      DefaultIfEmpty (simple)       DefaultIfEmpty (default value)       Empty       Range       Repeat

Grouping

GroupBy

      GroupBy

Join

GroupJoin, Join

      GroupJoin (left outer join)       Join (inner join)

Ordering

OrderBy, OrderByDescending, Reverse, ThenBy, ThenByDescending

      OrderBy (simple - numbers)       OrderBy (simple - dates)       OrderBy (simple - objects)       OrderByDescending       Reverse       ThenBy       ThenByDescending

Other

Concat, SequenceEqual, Zip

      Concat (simple - numbers)       Concat (simple - strings)       SequenceEqual       Zip

Partitioning

Skip, SkipWhile, Take, TakeWhile

      Skip       SkipWhile       Take       TakeWhile

Projection

Select, SelectMany

      Select (simple)       Select (anonymous type)       Select (indexed)       SelectMany (cross join)

Quantifiers

All, Any, Contains

      All       Any       Contains

Restriction

Where

      Where (simple - numbers)       Where (simple - objects)       Where (indexed)

Set

Distinct, Except, Intersect, Union

      Distinct       Except       Intersect       Union
  Close

Distinct

Lambda Query

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.

  • C#
  • VB.Net
  • F#
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
  • C#
  • VB.Net
  • F#
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

Share this sample on:

© 2023 - LINQSamples.com | Terms Of Service  -  Privacy Policy