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

Sum

Lambda Query

Sum: Calculates the total for a numeric collections.

Sum: Calculates the total for a numeric collections.

This Lambda Expression sample sums three numbers in array.

This Lambda Expression sample sums three numbers in array.

  • C#
  • VB.Net
  • F#
// A Query Expression cannot be constructed for Sum() in C#.
// Consider using a Lambda Expression instead.
Private Shared Sub Sample_Sum_Linq()
    Dim numbers As Integer() = {2, 5, 10}

    Dim result = Aggregate n In numbers Into Sum()

    Debug.WriteLine("Summing the numbers yields:")
    Debug.WriteLine(result)
End Sub
Output:
Summing the numbers yields:
17
// There is no Sum() for Query Expressions in F#, but it has the similar "sumBy".
let Sample_Sum_Linq() =
    let numbers = [|2; 5; 10|]

    let result = query {
        for n in numbers do
        sumBy n
    }

    Debug.WriteLine(sprintf "Summing the numbers yields:")
    Debug.WriteLine(sprintf "%d" result)
Output:
Summing the numbers yields:
17
  • C#
  • VB.Net
  • F#
static void Sample_Sum_Lambda()
{
    int[] numbers = { 2, 5, 10 };

    var result = numbers.Sum();

    Debug.WriteLine("Summing the numbers yields:");
    Debug.WriteLine(result);
}
Output:
Summing the numbers yields:
17
Private Shared Sub Sample_Sum_Lambda()
    Dim numbers As Integer() = {2, 5, 10}

    Dim result = numbers.Sum()

    Debug.WriteLine("Summing the numbers yields:")
    Debug.WriteLine(result)
End Sub
Output:
Summing the numbers yields:
17
let Sample_Sum_Lambda() =
    let numbers = [|2; 5; 10|]

    let result = numbers.Sum()

    Debug.WriteLine(sprintf "Summing the numbers yields:")
    Debug.WriteLine(sprintf "%d" result)
Output:
Summing the numbers yields:
17

Share this sample on:

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