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
Aggregate: Performs a specified operation to each element in a collection, while carrying the result forward.
Aggregate: Performs a specified operation to each element in a collection, while carrying the result forward. |
Aggregate: Performs a specified operation to each element in a collection, while carrying the result forward. |
This Query Expression sample aggregates numbers in array by multiplication. |
This Query Expression sample aggregates numbers in array by multiplication. |
// A Query Expression cannot be constructed for Aggregate() in C#. // Consider using a Lambda Expression instead.
' A Query Expression cannot be constructed for Aggregate() in VB.NET. ' Consider using a Lambda Expression instead.
// A Query Expression cannot be constructed for Aggregate() in F#. // Consider using a Lambda Expression instead.
private static void Sample_Aggregate_Lambda_Simple() { var numbers = new int[] { 1, 2, 3, 4, 5 }; var result = numbers.Aggregate((a, b) => a * b); Debug.WriteLine("Aggregated numbers by multiplication:"); Debug.WriteLine(result); }Output:
Aggregated numbers by multiplication: 120
Private Shared Sub Sample_Aggregate_Lambda_Simple() Dim numbers = New Integer() {1, 2, 3, 4, 5} Dim result = numbers.Aggregate(Function(a, b) a * b) Debug.WriteLine("Aggregated numbers by multiplication:") Debug.WriteLine(result) End SubOutput:
Aggregated numbers by multiplication: 120
let Sample_Aggregate_Lambda_Simple() = let numbers = [|1; 2; 3; 4; 5|] let result = numbers.Aggregate(fun a b -> a * b) Debug.WriteLine(sprintf "Aggregated numbers by multiplication:") Debug.WriteLine(sprintf "%d" result)Output:
Aggregated numbers by multiplication: 120