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
Contains: Checks if any elements in a collection satisifies a specified value.
Contains: Checks if any elements in a collection satisifies a specified value. |
Contains: Checks if any elements in a collection satisifies a specified value. |
This Query Expression sample checks whether array of numbers contains value of 5. |
This Query Expression sample checks whether array of numbers contains value of 5. |
// A Query Expression cannot be constructed for Contains() in C#. // Consider using a Lambda Expression instead.
' A Query Expression cannot be constructed for Contains() in C#. ' Consider using a Lambda Expression instead.
let Sample_Contains_Linq() = let numbers = [|1; 3; 5; 7; 9|] let result = query { for n in numbers do select n contains 5 } Debug.WriteLine(sprintf "Sequence contains the value 5:") Debug.WriteLine(sprintf "%b" result)Output:
Sequence contains the value 5: true
static void Sample_Contains_Lambda() { int[] numbers = { 1, 3, 5, 7, 9 }; var result = numbers.Contains(5); Debug.WriteLine("sequence contains the value 5:"); Debug.WriteLine(result); }Output:
Sequence contains the value 5: True
Private Shared Sub Sample_Contains_Lambda() Dim numbers As Integer() = {1, 3, 5, 7, 9} Dim result = numbers.Contains(5) Debug.WriteLine("Sequence contains the value 5:") Debug.WriteLine(result) End SubOutput:
Sequence contains the value 5: True
let Sample_Contains_Lambda() = let numbers = [|1; 3; 5; 7; 9|] let result = numbers.Contains(5) Debug.WriteLine(sprintf "Sequence contains the value 5:") Debug.WriteLine(sprintf "%b" result)Output:
Sequence contains the value 5: true