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
Sum: Calculates the total for a numeric collections.
| 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. |
// 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
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