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
Concat: Concatenates (combines) two collections.
Concat: Concatenates (combines) two collections. |
Concat: Concatenates (combines) two collections. |
This Query Expression sample concatenates two arrays of numbers. |
This Query Expression sample concatenates two arrays of numbers. |
// A Query Expression cannot be constructed for Concat() in C#. // Consider using a Lambda Expression instead.
' A Query Expression cannot be constructed for Concat() in VB.NET. ' Consider using a Lambda Expression instead.
// A Query Expression cannot be constructed for Concat() in F#. // Consider using a Lambda Expression instead.
static void Sample_Concat_Lambda_Numbers() { int[] numbers1 = { 1, 2, 3 }; int[] numbers2 = { 4, 5, 6 }; var result = numbers1.Concat(numbers2); Debug.WriteLine("Concatenating numbers1 and numbers2 gives:"); foreach (int number in result) Debug.WriteLine(number); }Output:
Concatenating numbers1 and numbers2 gives: 1 2 3 4 5 6
Private Shared Sub Sample_Concat_Lambda_Numbers() Dim numbers1 As Integer() = {1, 2, 3} Dim numbers2 As Integer() = {4, 5, 6} Dim result = numbers1.Concat(numbers2) Debug.WriteLine("Concatenating numbers1 and numbers2 gives:") For Each number As Integer In result Debug.WriteLine(number) Next End SubOutput:
Concatenating numbers1 and numbers2 gives: 1 2 3 4 5 6
let Sample_Concat_Lambda_Numbers() = let numbers1 = [|1; 2; 3|] let numbers2 = [|4; 5; 6|] let result = numbers1.Concat(numbers2) Debug.WriteLine(sprintf "Concatenating numbers1 and numbers2 gives:") for number in result do Debug.WriteLine(sprintf "%d" number)Output:
Concatenating numbers1 and numbers2 gives: 1 2 3 4 5 6