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
LongCount: Returns the number of elements in collections larger than Int32.MaxValue.
LongCount: Returns the number of elements in collections larger than Int32.MaxValue. |
LongCount: Returns the number of elements in collections larger than Int32.MaxValue. |
This Query Expression sample counts elements in array larger than Int32.MaxValue. |
This Query Expression sample counts elements in array larger than Int32.MaxValue. |
// A Query Expression cannot be constructed for LongCount() in C#. // Consider using a Lambda Expression instead.
' Use LongCount() when you expect the result to be greater than Int32.MaxValue() Private Shared Sub Sample_LongCount_Linq() ' Create array which is 5 elements larger than Int32.MaxValue Dim largeArr = Enumerable.Range(0, Int32.MaxValue).Concat(Enumerable.Range(0, 5)) Dim result = Aggregate a In largeArr Into LongCount() Debug.WriteLine("Counting largeArr elements:") Debug.WriteLine(result) End SubOutput:
Counting largeArr elements: 2147483652
// A Query Expression cannot be constructed for LongCount() in F#. // Consider using a Lambda Expression instead.
// Use LongCount() when you expect the result to be greater than Int32.MaxValue() static void Sample_LongCount_Lambda() { // Create array which is 5 elements larger than Int32.MaxValue var largeArr = Enumerable.Range(0, Int32.MaxValue).Concat(Enumerable.Range(0, 5)); Int64 result = largeArr.LongCount(); Debug.WriteLine("Counting largeArr elements:"); Debug.WriteLine(result); }Output:
Counting largeArr elements: 2147483652
' Use LongCount() when you expect the result to be greater than Int32.MaxValue() Private Shared Sub Sample_LongCount_Lambda() ' Create array which is 5 elements larger than Int32.MaxValue Dim largeArr = Enumerable.Range(0, Int32.MaxValue).Concat(Enumerable.Range(0, 5)) Dim result As Int64 = largeArr.LongCount() Debug.WriteLine("Counting largeArr elements:") Debug.WriteLine(result) End SubOutput:
Counting largeArr elements: 2147483652
// Use LongCount() when you expect the result to be greater than Int32.MaxValue() let Sample_LongCount_Lambda() = // Create array which is 5 elements larger than Int32.MaxValue let largeArr = Enumerable.Range(0, Int32.MaxValue).Concat(Enumerable.Range(0, 5)) let result = largeArr.LongCount(); Debug.WriteLine(sprintf "Counting largeArr elements:") Debug.WriteLine(sprintf "%d" result)Output:
Counting largeArr elements: 2147483652