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
Average: Computes the average value for a numeric collections.
| Average: Computes the average value for a numeric collections. |
| Average: Computes the average value for a numeric collections. |
| This Lambda Expression sample calculates the average of values in array. |
| This Lambda Expression sample calculates the average of values in array. |
// A Query Expression cannot be constructed for Average() in C#. // Consider using a Lambda Expression instead.
Private Shared Sub Sample_Average_Linq()
Dim numbers As Integer() = {10, 10, 11, 11}
Dim result = Aggregate n In numbers Into Average()
Debug.WriteLine("Average is:")
Debug.WriteLine(result)
End Sub
Output: Average is: 10.5
// There is no Average() for Query Expressions in F#, but it has the similar "averageBy".
let Sample_Average_Linq() =
let numbers = [|10; 10; 11; 11|]
let result = query {
for n in numbers do
averageBy (float n)
}
Debug.WriteLine(sprintf "Average is:")
Debug.WriteLine(sprintf "%f" result)
Output: Average is: 10.500000
static void Sample_Average_Lambda()
{
int[] numbers = { 10, 10, 11, 11 };
var result = numbers.Average();
Debug.WriteLine("Average is:");
Debug.WriteLine(result);
}
Output: Average is: 10.5
Private Shared Sub Sample_Average_Lambda()
Dim numbers As Integer() = {10, 10, 11, 11}
Dim result = numbers.Average()
Debug.WriteLine("Average is:")
Debug.WriteLine(result)
End Sub
Output: Average is: 10.5
let Sample_Average_Lambda() =
let numbers = [|10; 10; 11; 11|]
let result = numbers.Average()
Debug.WriteLine(sprintf "Average is:")
Debug.WriteLine(sprintf "%f" result)
Output: Average is: 10.500000