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
OrderBy: Sorts a collection in ascending order.
| OrderBy: Sorts a collection in ascending order. |
| OrderBy: Sorts a collection in ascending order. |
| This Lambda Expression sample sorts array of numbers in ascending order. |
| This Lambda Expression sample sorts array of numbers in ascending order. |
static void Sample_OrderBy_Linq_Numbers()
{
int[] numbers = { 7, 9, 5 };
var result = from n in numbers
orderby n
select n;
Debug.WriteLine("Ordered list of numbers:");
foreach (int number in result)
Debug.WriteLine(number);
}
Output: Ordered list of numbers: 5 7 9
Private Shared Sub Sample_OrderBy_Linq_Numbers()
Dim numbers As Integer() = {7, 9, 5}
Dim result = From n In numbers Order By n
Debug.WriteLine("Ordered list of numbers:")
For Each number As Integer In result
Debug.WriteLine(number)
Next
End Sub
Output: Ordered list of numbers: 5 7 9
// There is no OrderBy() for Query Expressions in F#, but it has the similar "sortBy".
let Sample_OrderBy_Linq_Numbers() =
let numbers = [|7; 9; 5|]
let result = query {
for n in numbers do
sortBy n
select n
}
Debug.WriteLine(sprintf "Ordered list of numbers:")
for number in result do
Debug.WriteLine(sprintf "%d" number)
Output: Ordered list of numbers: 5 7 9
static void Sample_OrderBy_Lambda_Numbers()
{
int[] numbers = { 7, 9, 5 };
var result = numbers.OrderBy(n => n);
Debug.WriteLine("Ordered list of numbers:");
foreach (int number in result)
Debug.WriteLine(number);
}
Output: Ordered list of numbers: 5 7 9
Private Shared Sub Sample_OrderBy_Lambda_Numbers()
Dim numbers As Integer() = {7, 9, 5}
Dim result = numbers.OrderBy(Function(n) n)
Debug.WriteLine("Ordered list of numbers:")
For Each number As Integer In result
Debug.WriteLine(number)
Next
End Sub
Output: Ordered list of numbers: 5 7 9
let Sample_OrderBy_Lambda_Numbers() =
let numbers = [|7; 9; 5|]
let result = numbers.OrderBy(fun n -> n);
Debug.WriteLine(sprintf "Ordered list of numbers:")
for number in result do
Debug.WriteLine(sprintf "%d" number)
Output: Ordered list of numbers: 5 7 9