Interface ExtendedEnumerable<TSource>
- Type Parameters:
TSource
- Element type
- All Known Subinterfaces:
Enumerable<T>
,ExtendedOrderedEnumerable<T>
,ExtendedOrderedQueryable<T>
,org.apache.calcite.linq4j.ExtendedQueryable<TSource>
,Grouping<K,
,V> Lookup<K,
,V> OrderedEnumerable<T>
,OrderedQueryable<T>
,Queryable<T>
,QueryableDefaults.Replayable<T>
,RawQueryable<T>
- All Known Implementing Classes:
AbstractEnumerable
,AbstractEnumerable2
,AbstractQueryable
,AbstractTableQueryable
,BaseQueryable
,CassandraTable.CassandraQueryable
,DefaultEnumerable
,ElasticsearchTable.ElasticsearchQueryable
,GeodeTable.GeodeQueryable
,InnodbTable.InnodbQueryable
,Interpreter
,MemoryEnumerable
,MongoTable.MongoQueryable
,QueryableDefaults.NonLeafReplayableQueryable
,QueryableDefaults.ReplayableQueryable
,QueryProviderImpl.QueryableImpl
,ResultSetEnumerable
,SpatialTypeFunctions.GridEnumerable
,SplunkQuery
Enumerable
.-
Method Summary
Modifier and TypeMethodDescription<TAccumulate>
@PolyNull TAccumulateaggregate
(@PolyNull TAccumulate seed, Function2<@PolyNull TAccumulate, TSource, @PolyNull TAccumulate> func) Applies an accumulator function over a sequence.@Nullable TSource
Applies an accumulator function over a sequence.<TAccumulate,
TResult>
TResultaggregate
(TAccumulate seed, Function2<TAccumulate, TSource, TAccumulate> func, Function1<TAccumulate, TResult> selector) Applies an accumulator function over a sequence.boolean
all
(Predicate1<TSource> predicate) Determines whether all elements of a sequence satisfy a condition.boolean
any()
Determines whether a sequence contains any elements.boolean
any
(Predicate1<TSource> predicate) Determines whether any element of a sequence satisfies a condition.Returns the input typed asEnumerable<TSource>
.<TInner,
TKey, TResult>
Enumerable<TResult>asofJoin
(Enumerable<TInner> inner, Function1<TSource, TKey> outerKeySelector, Function1<TInner, TKey> innerKeySelector, Function2<TSource, @Nullable TInner, TResult> resultSelector, Predicate2<TSource, TInner> matchComparator, Comparator<TInner> timestampComparator, boolean generateNullsOnRight) Correlates elements of two sequences based on - matching keys - a comparator for timestamps.Converts an Enumerable to aQueryable
.average
(BigDecimalFunction1<TSource> selector) Computes the average of a sequence of Decimal values that are obtained by invoking a transform function on each element of the input sequence.double
average
(DoubleFunction1<TSource> selector) Computes the average of a sequence of Double values that are obtained by invoking a transform function on each element of the input sequence.float
average
(FloatFunction1<TSource> selector) Computes the average of a sequence of Float values that are obtained by invoking a transform function on each element of the input sequence.int
average
(IntegerFunction1<TSource> selector) Computes the average of a sequence of int values that are obtained by invoking a transform function on each element of the input sequence.long
average
(LongFunction1<TSource> selector) Computes the average of a sequence of long values that are obtained by invoking a transform function on each element of the input sequence.average
(NullableBigDecimalFunction1<TSource> selector) Computes the average of a sequence of nullable Decimal values that are obtained by invoking a transform function on each element of the input sequence.average
(NullableDoubleFunction1<TSource> selector) Computes the average of a sequence of nullable Double values that are obtained by invoking a transform function on each element of the input sequence.average
(NullableFloatFunction1<TSource> selector) Computes the average of a sequence of nullable Float values that are obtained by invoking a transform function on each element of the input sequence.average
(NullableIntegerFunction1<TSource> selector) Computes the average of a sequence of nullable int values that are obtained by invoking a transform function on each element of the input sequence.average
(NullableLongFunction1<TSource> selector) Computes the average of a sequence of nullable long values that are obtained by invoking a transform function on each element of the input sequence.<T2> Enumerable<T2>
Converts the elements of this Enumerable to the specified type.concat
(Enumerable<TSource> enumerable1) Concatenates two sequences.boolean
Determines whether a sequence contains a specified element by using the default equality comparer.boolean
contains
(TSource element, EqualityComparer<TSource> comparer) Determines whether a sequence contains a specified element by using a specifiedEqualityComparer<TSource>
.<TInner,
TResult>
Enumerable<TResult>correlateJoin
(JoinType joinType, Function1<TSource, Enumerable<TInner>> inner, Function2<TSource, TInner, TResult> resultSelector) For each row of the current enumerable returns the correlated rows from theinner
enumerable (nested loops join).int
count()
Returns the number of elements in a sequence.int
count
(Predicate1<TSource> predicate) Returns a number that represents how many elements in the specified sequence satisfy a condition.Enumerable<@Nullable TSource>
Returns the elements of the specified sequence or the type parameter's default value in a singleton collection if the sequence is empty.Enumerable<@PolyNull TSource>
defaultIfEmpty
(@PolyNull TSource value) Returns the elements of the specified sequence or the specified value in a singleton collection if the sequence is empty.distinct()
Returns distinct elements from a sequence by using the default equality comparer to compare values.distinct
(EqualityComparer<TSource> comparer) Returns distinct elements from a sequence by using a specifiedEqualityComparer<TSource>
to compare values.elementAt
(int index) Returns the element at a specified index in a sequence.@Nullable TSource
elementAtOrDefault
(int index) Returns the element at a specified index in a sequence or a default value if the index is out of range.except
(Enumerable<TSource> enumerable1) Produces the set difference of two sequences by using the default equality comparer to compare values, eliminate duplicates.except
(Enumerable<TSource> enumerable1, boolean all) Produces the set difference of two sequences by using the default equality comparer to compare values, usingall
to indicate whether to eliminate duplicates.except
(Enumerable<TSource> enumerable1, EqualityComparer<TSource> comparer) Produces the set difference of two sequences by using the specifiedEqualityComparer<TSource>
to compare values, eliminate duplicates.except
(Enumerable<TSource> enumerable1, EqualityComparer<TSource> comparer, boolean all) Produces the set difference of two sequences by using the specifiedEqualityComparer<TSource>
to compare values, usingall
to indicate whether to eliminate duplicates.first()
Returns the first element of a sequence.first
(Predicate1<TSource> predicate) Returns the first element in a sequence that satisfies a specified condition.@Nullable TSource
Returns the first element of a sequence, or a default value if the sequence contains no elements.@Nullable TSource
firstOrDefault
(Predicate1<TSource> predicate) Returns the first element of the sequence that satisfies a condition or a default value if no such element is found.<R> @Nullable R
Performs an operation for each member of this enumeration.<TKey> Enumerable<Grouping<TKey,
TSource>> Groups the elements of a sequence according to a specified key selector function.<TKey> Enumerable<Grouping<TKey,
TSource>> groupBy
(Function1<TSource, TKey> keySelector, EqualityComparer<TKey> comparer) Groups the elements of a sequence according to a specified key selector function and compares the keys by using a specified comparer.<TKey,
TAccumulate, TResult>
Enumerable<TResult>groupBy
(Function1<TSource, TKey> keySelector, Function0<TAccumulate> accumulatorInitializer, Function2<TAccumulate, TSource, TAccumulate> accumulatorAdder, Function2<TKey, TAccumulate, TResult> resultSelector) Groups the elements of a sequence according to a specified key selector function, initializing an accumulator for each group and adding to it each time an element with the same key is seen.<TKey,
TAccumulate, TResult>
Enumerable<TResult>groupBy
(Function1<TSource, TKey> keySelector, Function0<TAccumulate> accumulatorInitializer, Function2<TAccumulate, TSource, TAccumulate> accumulatorAdder, Function2<TKey, TAccumulate, TResult> resultSelector, EqualityComparer<TKey> comparer) Groups the elements of a sequence according to a specified key selector function, initializing an accumulator for each group and adding to it each time an element with the same key is seen.<TKey,
TElement>
Enumerable<Grouping<TKey,TElement>> Groups the elements of a sequence according to a specified key selector function and projects the elements for each group by using a specified function.<TKey,
TElement>
Enumerable<Grouping<TKey,TElement>> groupBy
(Function1<TSource, TKey> keySelector, Function1<TSource, TElement> elementSelector, EqualityComparer<TKey> comparer) Groups the elements of a sequence according to a key selector function.<TKey,
TElement, TResult>
Enumerable<TResult>groupBy
(Function1<TSource, TKey> keySelector, Function1<TSource, TElement> elementSelector, Function2<TKey, Enumerable<TElement>, TResult> resultSelector) Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key.<TKey,
TElement, TResult>
Enumerable<TResult>groupBy
(Function1<TSource, TKey> keySelector, Function1<TSource, TElement> elementSelector, Function2<TKey, Enumerable<TElement>, TResult> resultSelector, EqualityComparer<TKey> comparer) Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key.<TKey,
TResult>
Enumerable<TResult>groupBy
(Function1<TSource, TKey> keySelector, Function2<TKey, Enumerable<TSource>, TResult> resultSelector) Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key.<TKey,
TResult>
Enumerable<TResult>groupBy
(Function1<TSource, TKey> keySelector, Function2<TKey, Enumerable<TSource>, TResult> resultSelector, EqualityComparer<TKey> comparer) Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key.<TInner,
TKey, TResult>
Enumerable<TResult>groupJoin
(Enumerable<TInner> inner, Function1<TSource, TKey> outerKeySelector, Function1<TInner, TKey> innerKeySelector, Function2<TSource, Enumerable<TInner>, TResult> resultSelector) Correlates the elements of two sequences based on equality of keys and groups the results.<TInner,
TKey, TResult>
Enumerable<TResult>groupJoin
(Enumerable<TInner> inner, Function1<TSource, TKey> outerKeySelector, Function1<TInner, TKey> innerKeySelector, Function2<TSource, Enumerable<TInner>, TResult> resultSelector, EqualityComparer<TKey> comparer) Correlates the elements of two sequences based on key equality and groups the results.<TInner,
TKey, TResult>
Enumerable<TResult>hashJoin
(Enumerable<TInner> inner, Function1<TSource, TKey> outerKeySelector, Function1<TInner, TKey> innerKeySelector, Function2<TSource, TInner, TResult> resultSelector) Correlates the elements of two sequences based on matching keys.<TInner,
TKey, TResult>
Enumerable<TResult>hashJoin
(Enumerable<TInner> inner, Function1<TSource, TKey> outerKeySelector, Function1<TInner, TKey> innerKeySelector, Function2<TSource, TInner, TResult> resultSelector, @Nullable EqualityComparer<TKey> comparer, boolean generateNullsOnLeft, boolean generateNullsOnRight) Correlates the elements of two sequences based on matching keys, with optional outer join semantics.<TInner,
TKey, TResult>
Enumerable<TResult>hashJoin
(Enumerable<TInner> inner, Function1<TSource, TKey> outerKeySelector, Function1<TInner, TKey> innerKeySelector, Function2<TSource, TInner, TResult> resultSelector, EqualityComparer<TKey> comparer) Correlates the elements of two sequences based on matching keys.<TInner,
TKey, TResult>
Enumerable<TResult>hashJoin
(Enumerable<TInner> inner, Function1<TSource, TKey> outerKeySelector, Function1<TInner, TKey> innerKeySelector, Function2<TSource, TInner, TResult> resultSelector, EqualityComparer<TKey> comparer, boolean generateNullsOnLeft, boolean generateNullsOnRight, Predicate2<TSource, TInner> predicate) Correlates the elements of two sequences based on matching keys, with optional outer join semantics.intersect
(Enumerable<TSource> enumerable1) Produces the set intersection of two sequences by using the default equality comparer to compare values, eliminate duplicates.intersect
(Enumerable<TSource> enumerable1, boolean all) Produces the set intersection of two sequences by using the default equality comparer to compare values, usingall
to indicate whether to eliminate duplicates.intersect
(Enumerable<TSource> enumerable1, EqualityComparer<TSource> comparer) Produces the set intersection of two sequences by using the specifiedEqualityComparer<TSource>
to compare values, eliminate duplicates.intersect
(Enumerable<TSource> enumerable1, EqualityComparer<TSource> comparer, boolean all) Produces the set intersection of two sequences by using the specifiedEqualityComparer<TSource>
to compare values, usingall
to indicate whether to eliminate duplicates.<C extends Collection<? super TSource>>
Cinto
(C sink) Copies the contents of this sequence into a collection.last()
Returns the last element of a sequence.last
(Predicate1<TSource> predicate) Returns the last element of a sequence that satisfies a specified condition.@Nullable TSource
Returns the last element of a sequence, or a default value if the sequence contains no elements.@Nullable TSource
lastOrDefault
(Predicate1<TSource> predicate) Returns the last element of a sequence that satisfies a condition or a default value if no such element is found.long
Returns an long that represents the total number of elements in a sequence.long
longCount
(Predicate1<TSource> predicate) Returns an long that represents how many elements in a sequence satisfy a condition.@Nullable TSource
max()
Returns the maximum value in a generic sequence.@Nullable BigDecimal
max
(BigDecimalFunction1<TSource> selector) Invokes a transform function on each element of a sequence and returns the maximum Decimal value.double
max
(DoubleFunction1<TSource> selector) Invokes a transform function on each element of a sequence and returns the maximum Double value.float
max
(FloatFunction1<TSource> selector) Invokes a transform function on each element of a sequence and returns the maximum Float value.<TResult extends Comparable<TResult>>
@Nullable TResultInvokes a transform function on each element of a generic sequence and returns the maximum resulting value.int
max
(IntegerFunction1<TSource> selector) Invokes a transform function on each element of a sequence and returns the maximum int value.long
max
(LongFunction1<TSource> selector) Invokes a transform function on each element of a sequence and returns the maximum long value.@Nullable BigDecimal
max
(NullableBigDecimalFunction1<TSource> selector) Invokes a transform function on each element of a sequence and returns the maximum nullable Decimal value.@Nullable Double
max
(NullableDoubleFunction1<TSource> selector) Invokes a transform function on each element of a sequence and returns the maximum nullable Double value.@Nullable Float
max
(NullableFloatFunction1<TSource> selector) Invokes a transform function on each element of a sequence and returns the maximum nullable Float value.@Nullable Integer
max
(NullableIntegerFunction1<TSource> selector) Invokes a transform function on each element of a sequence and returns the maximum nullable int value.@Nullable Long
max
(NullableLongFunction1<TSource> selector) Invokes a transform function on each element of a sequence and returns the maximum nullable long value.@Nullable TSource
min()
Returns the minimum value in a generic sequence.@Nullable BigDecimal
min
(BigDecimalFunction1<TSource> selector) Invokes a transform function on each element of a sequence and returns the minimum Decimal value.double
min
(DoubleFunction1<TSource> selector) Invokes a transform function on each element of a sequence and returns the minimum Double value.float
min
(FloatFunction1<TSource> selector) Invokes a transform function on each element of a sequence and returns the minimum Float value.<TResult extends Comparable<TResult>>
@Nullable TResultInvokes a transform function on each element of a generic sequence and returns the minimum resulting value.int
min
(IntegerFunction1<TSource> selector) Invokes a transform function on each element of a sequence and returns the minimum int value.long
min
(LongFunction1<TSource> selector) Invokes a transform function on each element of a sequence and returns the minimum long value.@Nullable BigDecimal
min
(NullableBigDecimalFunction1<TSource> selector) Invokes a transform function on each element of a sequence and returns the minimum nullable Decimal value.@Nullable Double
min
(NullableDoubleFunction1<TSource> selector) Invokes a transform function on each element of a sequence and returns the minimum nullable Double value.@Nullable Float
min
(NullableFloatFunction1<TSource> selector) Invokes a transform function on each element of a sequence and returns the minimum nullable Float value.@Nullable Integer
min
(NullableIntegerFunction1<TSource> selector) Invokes a transform function on each element of a sequence and returns the minimum nullable int value.@Nullable Long
min
(NullableLongFunction1<TSource> selector) Invokes a transform function on each element of a sequence and returns the minimum nullable long value.<TResult> Enumerable<TResult>
Filters the elements of an Enumerable based on a specified type.<TKey extends Comparable>
Enumerable<TSource>Sorts the elements of a sequence in ascending order according to a key.<TKey> Enumerable<TSource>
orderBy
(Function1<TSource, TKey> keySelector, Comparator<TKey> comparator) Sorts the elements of a sequence in ascending order by using a specified comparer.<TKey extends Comparable>
Enumerable<TSource>orderByDescending
(Function1<TSource, TKey> keySelector) Sorts the elements of a sequence in descending order according to a key.<TKey> Enumerable<TSource>
orderByDescending
(Function1<TSource, TKey> keySelector, Comparator<TKey> comparator) Sorts the elements of a sequence in descending order by using a specified comparer.<C extends Collection<? super TSource>>
CremoveAll
(C sink) Removes the contents of this sequence from a collection.reverse()
Inverts the order of the elements in a sequence.<TResult> Enumerable<TResult>
Projects each element of a sequence into a new form.<TResult> Enumerable<TResult>
Projects each element of a sequence into a new form by incorporating the element's index.<TCollection,
TResult>
Enumerable<TResult>selectMany
(Function1<TSource, Enumerable<TCollection>> collectionSelector, Function2<TSource, TCollection, TResult> resultSelector) Projects each element of a sequence to anEnumerable<TSource>
, flattens the resulting sequences into one sequence, and invokes a result selector function on each element therein.<TResult> Enumerable<TResult>
selectMany
(Function1<TSource, Enumerable<TResult>> selector) Projects each element of a sequence to anEnumerable<TSource>
and flattens the resulting sequences into one sequence.<TCollection,
TResult>
Enumerable<TResult>selectMany
(Function2<TSource, Integer, Enumerable<TCollection>> collectionSelector, Function2<TSource, TCollection, TResult> resultSelector) Projects each element of a sequence to anEnumerable<TSource>
, flattens the resulting sequences into one sequence, and invokes a result selector function on each element therein.<TResult> Enumerable<TResult>
selectMany
(Function2<TSource, Integer, Enumerable<TResult>> selector) Projects each element of a sequence to anEnumerable<TSource>
, and flattens the resulting sequences into one sequence.boolean
sequenceEqual
(Enumerable<TSource> enumerable1) Determines whether two sequences are equal by comparing the elements by using the default equality comparer for their type.boolean
sequenceEqual
(Enumerable<TSource> enumerable1, EqualityComparer<TSource> comparer) Determines whether two sequences are equal by comparing their elements by using a specifiedEqualityComparer<TSource>
.single()
Returns the only element of a sequence, and throws an exception if there is not exactly one element in the sequence.single
(Predicate1<TSource> predicate) Returns the only element of a sequence that satisfies a specified condition, and throws an exception if more than one such element exists.@Nullable TSource
Returns the only element of a sequence, or a default value if the sequence is empty; this method throws an exception if there is more than one element in the sequence.@Nullable TSource
singleOrDefault
(Predicate1<TSource> predicate) Returns the only element of a sequence that satisfies a specified condition or a default value if no such element exists; this method throws an exception if more than one element satisfies the condition.skip
(int count) Bypasses a specified number of elements in a sequence and then returns the remaining elements.skipWhile
(Predicate1<TSource> predicate) Bypasses elements in a sequence as long as a specified condition is true and then returns the remaining elements.skipWhile
(Predicate2<TSource, Integer> predicate) Bypasses elements in a sequence as long as a specified condition is true and then returns the remaining elements.<TKey,
TAccumulate, TResult>
Enumerable<TResult>sortedGroupBy
(Function1<TSource, TKey> keySelector, Function0<TAccumulate> accumulatorInitializer, Function2<TAccumulate, TSource, TAccumulate> accumulatorAdder, Function2<TKey, TAccumulate, TResult> resultSelector, Comparator<TKey> comparator) Group keys are sorted already.sum
(BigDecimalFunction1<TSource> selector) Computes the sum of the sequence of Decimal values that are obtained by invoking a transform function on each element of the input sequence.double
sum
(DoubleFunction1<TSource> selector) Computes the sum of the sequence of Double values that are obtained by invoking a transform function on each element of the input sequence.float
sum
(FloatFunction1<TSource> selector) Computes the sum of the sequence of Float values that are obtained by invoking a transform function on each element of the input sequence.int
sum
(IntegerFunction1<TSource> selector) Computes the sum of the sequence of int values that are obtained by invoking a transform function on each element of the input sequence.long
sum
(LongFunction1<TSource> selector) Computes the sum of the sequence of long values that are obtained by invoking a transform function on each element of the input sequence.sum
(NullableBigDecimalFunction1<TSource> selector) Computes the sum of the sequence of nullable Decimal values that are obtained by invoking a transform function on each element of the input sequence.sum
(NullableDoubleFunction1<TSource> selector) Computes the sum of the sequence of nullable Double values that are obtained by invoking a transform function on each element of the input sequence.sum
(NullableFloatFunction1<TSource> selector) Computes the sum of the sequence of nullable Float values that are obtained by invoking a transform function on each element of the input sequence.sum
(NullableIntegerFunction1<TSource> selector) Computes the sum of the sequence of nullable int values that are obtained by invoking a transform function on each element of the input sequence.sum
(NullableLongFunction1<TSource> selector) Computes the sum of the sequence of nullable long values that are obtained by invoking a transform function on each element of the input sequence.take
(int count) Returns a specified number of contiguous elements from the start of a sequence.takeWhile
(Predicate1<TSource> predicate) Returns elements from a sequence as long as a specified condition is true.takeWhile
(Predicate2<TSource, Integer> predicate) Returns elements from a sequence as long as a specified condition is true.toList()
Creates aList<TSource>
from anEnumerable<TSource>
.Creates aLookup<TKey, TElement>
from anEnumerable<TSource>
according to a specified key selector function.toLookup
(Function1<TSource, TKey> keySelector, EqualityComparer<TKey> comparer) Creates aLookup<TKey, TElement>
from anEnumerable<TSource>
according to a specified key selector function and key comparer.<TKey,
TElement>
Lookup<TKey,TElement> Creates aLookup<TKey, TElement>
from anEnumerable<TSource>
according to specified key selector and element selector functions.<TKey,
TElement>
Lookup<TKey,TElement> toLookup
(Function1<TSource, TKey> keySelector, Function1<TSource, TElement> elementSelector, EqualityComparer<TKey> comparer) Creates aLookup<TKey, TElement>
from anEnumerable<TSource>
according to a specified key selector function, a comparer and an element selector function.Creates aMap<TKey, TValue>
from anEnumerable<TSource>
according to a specified key selector function.toMap
(Function1<TSource, TKey> keySelector, EqualityComparer<TKey> comparer) Creates aMap<TKey, TValue>
from anEnumerable<TSource>
according to a specified key selector function and key comparer.<TKey,
TElement>
Map<TKey,TElement> Creates aMap<TKey, TValue>
from anEnumerable<TSource>
according to specified key selector and element selector functions.<TKey,
TElement>
Map<TKey,TElement> toMap
(Function1<TSource, TKey> keySelector, Function1<TSource, TElement> elementSelector, EqualityComparer<TKey> comparer) Creates aMap<TKey, TValue>
from anEnumerable<TSource>
according to a specified key selector function, a comparer, and an element selector function.union
(Enumerable<TSource> source1) Produces the set union of two sequences by using the default equality comparer.union
(Enumerable<TSource> source1, EqualityComparer<TSource> comparer) Produces the set union of two sequences by using a specifiedEqualityComparer<TSource>
.where
(Predicate1<TSource> predicate) Filters a sequence of values based on a predicate.where
(Predicate2<TSource, Integer> predicate) Filters a sequence of values based on a predicate.<T1,
TResult>
Enumerable<TResult>zip
(Enumerable<T1> source1, Function2<TSource, T1, TResult> resultSelector) Applies a specified function to the corresponding elements of two sequences, producing a sequence of the results.
-
Method Details
-
foreach
Performs an operation for each member of this enumeration.Returns the value returned by the function for the last element in this enumeration, or null if this enumeration is empty.
- Type Parameters:
R
- Return type- Parameters:
func
- Operation
-
aggregate
Applies an accumulator function over a sequence. -
aggregate
<TAccumulate> @PolyNull TAccumulate aggregate(@PolyNull TAccumulate seed, Function2<@PolyNull TAccumulate, TSource, @PolyNull TAccumulate> func) Applies an accumulator function over a sequence. The specified seed value is used as the initial accumulator value.If
seed
is not null, the result is never null. -
aggregate
<TAccumulate,TResult> TResult aggregate(TAccumulate seed, Function2<TAccumulate, TSource, TAccumulate> func, Function1<TAccumulate, TResult> selector) Applies an accumulator function over a sequence. The specified seed value is used as the initial accumulator value, and the specified function is used to select the result value. -
all
Determines whether all elements of a sequence satisfy a condition. -
any
boolean any()Determines whether a sequence contains any elements. (Defined by Enumerable.) -
any
Determines whether any element of a sequence satisfies a condition. -
asEnumerable
Enumerable<TSource> asEnumerable()Returns the input typed asEnumerable<TSource>
.This method has no effect other than to change the compile-time type of source from a type that implements
Enumerable<TSource>
toEnumerable<TSource>
itself.asEnumerable<TSource>(Enumerable<TSource>)
can be used to choose between query implementations when a sequence implementsEnumerable<TSource>
but also has a different set of public query methods available. For example, given a generic class Table that implementsEnumerable<TSource>
and has its own methods such aswhere
,select
, andselectMany
, a call towhere
would invoke the publicwhere
method ofTable
. ATable
type that represents a database table could have awhere
method that takes the predicate argument as an expression tree and converts the tree to SQL for remote execution. If remote execution is not desired, for example because the predicate invokes a local method, theasEnumerable<TSource>
method can be used to hide the custom methods and instead make the standard query operators available. -
asQueryable
Converts an Enumerable to aQueryable
.If the type of source implements
Queryable
, this method returns it directly. Otherwise, it returns aQueryable
that executes queries by calling the equivalent query operator methods inEnumerable
instead of those inQueryable
.Analogous to the LINQ's Enumerable.AsQueryable extension method.
- Returns:
- A queryable
-
average
Computes the average of a sequence of Decimal values that are obtained by invoking a transform function on each element of the input sequence. -
average
Computes the average of a sequence of nullable Decimal values that are obtained by invoking a transform function on each element of the input sequence. -
average
Computes the average of a sequence of Double values that are obtained by invoking a transform function on each element of the input sequence. -
average
Computes the average of a sequence of nullable Double values that are obtained by invoking a transform function on each element of the input sequence. -
average
Computes the average of a sequence of int values that are obtained by invoking a transform function on each element of the input sequence. -
average
Computes the average of a sequence of nullable int values that are obtained by invoking a transform function on each element of the input sequence. -
average
Computes the average of a sequence of long values that are obtained by invoking a transform function on each element of the input sequence. -
average
Computes the average of a sequence of nullable long values that are obtained by invoking a transform function on each element of the input sequence. -
average
Computes the average of a sequence of Float values that are obtained by invoking a transform function on each element of the input sequence. -
average
Computes the average of a sequence of nullable Float values that are obtained by invoking a transform function on each element of the input sequence. -
cast
Converts the elements of this Enumerable to the specified type.This method is implemented by using deferred execution. The immediate return value is an object that stores all the information that is required to perform the action. The query represented by this method is not executed until the object is enumerated either by calling its
RawEnumerable.enumerator()
method directly or by usingfor (... in ...)
.If an element cannot be cast to type TResult, the
Enumerator.current()
method will throw aClassCastException
a exception when the element it accessed. To obtain only those elements that can be cast to type TResult, use theofType(Class)
method instead. -
concat
Concatenates two sequences. -
contains
Determines whether a sequence contains a specified element by using the default equality comparer. -
contains
Determines whether a sequence contains a specified element by using a specifiedEqualityComparer<TSource>
. -
count
int count()Returns the number of elements in a sequence. -
count
Returns a number that represents how many elements in the specified sequence satisfy a condition. -
defaultIfEmpty
Enumerable<@Nullable TSource> defaultIfEmpty()Returns the elements of the specified sequence or the type parameter's default value in a singleton collection if the sequence is empty. -
defaultIfEmpty
Returns the elements of the specified sequence or the specified value in a singleton collection if the sequence is empty.If
value
is not null, the result is never null. -
distinct
Enumerable<TSource> distinct()Returns distinct elements from a sequence by using the default equality comparer to compare values. -
distinct
Returns distinct elements from a sequence by using a specifiedEqualityComparer<TSource>
to compare values. -
elementAt
Returns the element at a specified index in a sequence. -
elementAtOrDefault
Returns the element at a specified index in a sequence or a default value if the index is out of range. -
except
Produces the set difference of two sequences by using the default equality comparer to compare values, eliminate duplicates. (Defined by Enumerable.) -
except
Produces the set difference of two sequences by using the default equality comparer to compare values, usingall
to indicate whether to eliminate duplicates. (Defined by Enumerable.) -
except
Produces the set difference of two sequences by using the specifiedEqualityComparer<TSource>
to compare values, eliminate duplicates. -
except
Enumerable<TSource> except(Enumerable<TSource> enumerable1, EqualityComparer<TSource> comparer, boolean all) Produces the set difference of two sequences by using the specifiedEqualityComparer<TSource>
to compare values, usingall
to indicate whether to eliminate duplicates. -
first
TSource first()Returns the first element of a sequence. (Defined by Enumerable.) -
first
Returns the first element in a sequence that satisfies a specified condition. -
firstOrDefault
@Nullable TSource firstOrDefault()Returns the first element of a sequence, or a default value if the sequence contains no elements. -
firstOrDefault
Returns the first element of the sequence that satisfies a condition or a default value if no such element is found. -
groupBy
Groups the elements of a sequence according to a specified key selector function. -
groupBy
<TKey> Enumerable<Grouping<TKey,TSource>> groupBy(Function1<TSource, TKey> keySelector, EqualityComparer<TKey> comparer) Groups the elements of a sequence according to a specified key selector function and compares the keys by using a specified comparer. -
groupBy
<TKey,TElement> Enumerable<Grouping<TKey,TElement>> groupBy(Function1<TSource, TKey> keySelector, Function1<TSource, TElement> elementSelector) Groups the elements of a sequence according to a specified key selector function and projects the elements for each group by using a specified function. -
groupBy
<TKey,TElement> Enumerable<Grouping<TKey,TElement>> groupBy(Function1<TSource, TKey> keySelector, Function1<TSource, TElement> elementSelector, EqualityComparer<TKey> comparer) Groups the elements of a sequence according to a key selector function. The keys are compared by using a comparer and each group's elements are projected by using a specified function. -
groupBy
<TKey,TResult> Enumerable<TResult> groupBy(Function1<TSource, TKey> keySelector, Function2<TKey, Enumerable<TSource>, TResult> resultSelector) Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key. -
groupBy
<TKey,TResult> Enumerable<TResult> groupBy(Function1<TSource, TKey> keySelector, Function2<TKey, Enumerable<TSource>, TResult> resultSelector, EqualityComparer<TKey> comparer) Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key. The keys are compared by using a specified comparer. -
groupBy
<TKey,TElement, Enumerable<TResult> groupByTResult> (Function1<TSource, TKey> keySelector, Function1<TSource, TElement> elementSelector, Function2<TKey, Enumerable<TElement>, TResult> resultSelector) Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key. The elements of each group are projected by using a specified function. -
groupBy
<TKey,TElement, Enumerable<TResult> groupByTResult> (Function1<TSource, TKey> keySelector, Function1<TSource, TElement> elementSelector, Function2<TKey, Enumerable<TElement>, TResult> resultSelector, EqualityComparer<TKey> comparer) Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key. Key values are compared by using a specified comparer, and the elements of each group are projected by using a specified function. -
groupBy
<TKey,TAccumulate, Enumerable<TResult> groupByTResult> (Function1<TSource, TKey> keySelector, Function0<TAccumulate> accumulatorInitializer, Function2<TAccumulate, TSource, TAccumulate> accumulatorAdder, Function2<TKey, TAccumulate, TResult> resultSelector) Groups the elements of a sequence according to a specified key selector function, initializing an accumulator for each group and adding to it each time an element with the same key is seen. Creates a result value from each accumulator and its key using a specified function. -
groupBy
<TKey,TAccumulate, Enumerable<TResult> groupByTResult> (Function1<TSource, TKey> keySelector, Function0<TAccumulate> accumulatorInitializer, Function2<TAccumulate, TSource, TAccumulate> accumulatorAdder, Function2<TKey, TAccumulate, TResult> resultSelector, EqualityComparer<TKey> comparer) Groups the elements of a sequence according to a specified key selector function, initializing an accumulator for each group and adding to it each time an element with the same key is seen. Creates a result value from each accumulator and its key using a specified function. Key values are compared by using a specified comparer. -
sortedGroupBy
<TKey,TAccumulate, Enumerable<TResult> sortedGroupByTResult> (Function1<TSource, TKey> keySelector, Function0<TAccumulate> accumulatorInitializer, Function2<TAccumulate, TSource, TAccumulate> accumulatorAdder, Function2<TKey, TAccumulate, TResult> resultSelector, Comparator<TKey> comparator) Group keys are sorted already. Key values are compared by using a specified comparator. Groups the elements of a sequence according to a specified key selector function and initializing one accumulator at a time. Go over elements sequentially, adding to accumulator each time an element with the same key is seen. When key changes, creates a result value from the accumulator and then re-initializes the accumulator. In the case of NULL values in group keys, the comparator must be able to support NULL values by giving a consistent sort ordering. -
groupJoin
<TInner,TKey, Enumerable<TResult> groupJoinTResult> (Enumerable<TInner> inner, Function1<TSource, TKey> outerKeySelector, Function1<TInner, TKey> innerKeySelector, Function2<TSource, Enumerable<TInner>, TResult> resultSelector) Correlates the elements of two sequences based on equality of keys and groups the results. The default equality comparer is used to compare keys. -
groupJoin
<TInner,TKey, Enumerable<TResult> groupJoinTResult> (Enumerable<TInner> inner, Function1<TSource, TKey> outerKeySelector, Function1<TInner, TKey> innerKeySelector, Function2<TSource, Enumerable<TInner>, TResult> resultSelector, EqualityComparer<TKey> comparer) Correlates the elements of two sequences based on key equality and groups the results. A specifiedEqualityComparer<TSource>
is used to compare keys. -
intersect
Produces the set intersection of two sequences by using the default equality comparer to compare values, eliminate duplicates. (Defined by Enumerable.) -
intersect
Produces the set intersection of two sequences by using the default equality comparer to compare values, usingall
to indicate whether to eliminate duplicates. (Defined by Enumerable.) -
intersect
Produces the set intersection of two sequences by using the specifiedEqualityComparer<TSource>
to compare values, eliminate duplicates. -
intersect
Enumerable<TSource> intersect(Enumerable<TSource> enumerable1, EqualityComparer<TSource> comparer, boolean all) Produces the set intersection of two sequences by using the specifiedEqualityComparer<TSource>
to compare values, usingall
to indicate whether to eliminate duplicates. -
into
Copies the contents of this sequence into a collection. -
removeAll
Removes the contents of this sequence from a collection. -
hashJoin
<TInner,TKey, Enumerable<TResult> hashJoinTResult> (Enumerable<TInner> inner, Function1<TSource, TKey> outerKeySelector, Function1<TInner, TKey> innerKeySelector, Function2<TSource, TInner, TResult> resultSelector) Correlates the elements of two sequences based on matching keys. The default equality comparer is used to compare keys. -
hashJoin
<TInner,TKey, Enumerable<TResult> hashJoinTResult> (Enumerable<TInner> inner, Function1<TSource, TKey> outerKeySelector, Function1<TInner, TKey> innerKeySelector, Function2<TSource, TInner, TResult> resultSelector, EqualityComparer<TKey> comparer) Correlates the elements of two sequences based on matching keys. A specifiedEqualityComparer<TSource>
is used to compare keys. -
asofJoin
<TInner,TKey, Enumerable<TResult> asofJoinTResult> (Enumerable<TInner> inner, Function1<TSource, TKey> outerKeySelector, Function1<TInner, TKey> innerKeySelector, Function2<TSource, @Nullable TInner, TResult> resultSelector, Predicate2<TSource, TInner> matchComparator, Comparator<TInner> timestampComparator, boolean generateNullsOnRight) Correlates elements of two sequences based on - matching keys - a comparator for timestamps.- Parameters:
inner
- Inner sequenceouterKeySelector
- Function that extracts a key from the outer collectioninnerKeySelector
- Function that extracts a key from the inner collectionresultSelector
- Function that computes the join resultmatchComparator
- Function that compares an outer row and an inner row for timestamptimestampComparator
- Function that compares two inner rows for timestampgenerateNullsOnRight
- If true, this a left join
-
hashJoin
<TInner,TKey, Enumerable<TResult> hashJoinTResult> (Enumerable<TInner> inner, Function1<TSource, TKey> outerKeySelector, Function1<TInner, TKey> innerKeySelector, Function2<TSource, TInner, TResult> resultSelector, @Nullable EqualityComparer<TKey> comparer, boolean generateNullsOnLeft, boolean generateNullsOnRight) Correlates the elements of two sequences based on matching keys, with optional outer join semantics. A specifiedEqualityComparer<TSource>
is used to compare keys.A left join generates nulls on right, and vice versa:
Join types Join type generateNullsOnLeft generateNullsOnRight INNER false false LEFT false true RIGHT true false FULL true true -
hashJoin
<TInner,TKey, Enumerable<TResult> hashJoinTResult> (Enumerable<TInner> inner, Function1<TSource, TKey> outerKeySelector, Function1<TInner, TKey> innerKeySelector, Function2<TSource, TInner, TResult> resultSelector, EqualityComparer<TKey> comparer, boolean generateNullsOnLeft, boolean generateNullsOnRight, Predicate2<TSource, TInner> predicate) Correlates the elements of two sequences based on matching keys, with optional outer join semantics. A specifiedEqualityComparer<TSource>
is used to compare keys.A left join generates nulls on right, and vice versa:
Join types Join type generateNullsOnLeft generateNullsOnRight INNER false false LEFT false true RIGHT true false FULL true true A predicate is used to filter the join result per-row
-
correlateJoin
<TInner,TResult> Enumerable<TResult> correlateJoin(JoinType joinType, Function1<TSource, Enumerable<TInner>> inner, Function2<TSource, TInner, TResult> resultSelector) For each row of the current enumerable returns the correlated rows from theinner
enumerable (nested loops join).- Parameters:
joinType
- inner, left, semi or anti join typeinner
- generator of inner enumerableresultSelector
- selector of the result. For semi/anti join inner argument is always null.
-
last
TSource last()Returns the last element of a sequence. (Defined by Enumerable.) -
last
Returns the last element of a sequence that satisfies a specified condition. -
lastOrDefault
@Nullable TSource lastOrDefault()Returns the last element of a sequence, or a default value if the sequence contains no elements. -
lastOrDefault
Returns the last element of a sequence that satisfies a condition or a default value if no such element is found. -
longCount
long longCount()Returns an long that represents the total number of elements in a sequence. -
longCount
Returns an long that represents how many elements in a sequence satisfy a condition. -
max
@Nullable TSource max()Returns the maximum value in a generic sequence. -
max
Invokes a transform function on each element of a sequence and returns the maximum Decimal value. -
max
Invokes a transform function on each element of a sequence and returns the maximum nullable Decimal value. -
max
Invokes a transform function on each element of a sequence and returns the maximum Double value. -
max
Invokes a transform function on each element of a sequence and returns the maximum nullable Double value. -
max
Invokes a transform function on each element of a sequence and returns the maximum int value. -
max
Invokes a transform function on each element of a sequence and returns the maximum nullable int value. (Defined by Enumerable.) -
max
Invokes a transform function on each element of a sequence and returns the maximum long value. -
max
Invokes a transform function on each element of a sequence and returns the maximum nullable long value. (Defined by Enumerable.) -
max
Invokes a transform function on each element of a sequence and returns the maximum Float value. -
max
Invokes a transform function on each element of a sequence and returns the maximum nullable Float value. -
max
Invokes a transform function on each element of a generic sequence and returns the maximum resulting value. -
min
@Nullable TSource min()Returns the minimum value in a generic sequence. -
min
Invokes a transform function on each element of a sequence and returns the minimum Decimal value. -
min
Invokes a transform function on each element of a sequence and returns the minimum nullable Decimal value. -
min
Invokes a transform function on each element of a sequence and returns the minimum Double value. -
min
Invokes a transform function on each element of a sequence and returns the minimum nullable Double value. -
min
Invokes a transform function on each element of a sequence and returns the minimum int value. -
min
Invokes a transform function on each element of a sequence and returns the minimum nullable int value. (Defined by Enumerable.) -
min
Invokes a transform function on each element of a sequence and returns the minimum long value. -
min
Invokes a transform function on each element of a sequence and returns the minimum nullable long value. (Defined by Enumerable.) -
min
Invokes a transform function on each element of a sequence and returns the minimum Float value. -
min
Invokes a transform function on each element of a sequence and returns the minimum nullable Float value. -
min
Invokes a transform function on each element of a generic sequence and returns the minimum resulting value. -
ofType
Filters the elements of an Enumerable based on a specified type.Analogous to LINQ's Enumerable.OfType extension method.
- Type Parameters:
TResult
- Target type- Parameters:
clazz
- Target type- Returns:
- Collection of T2
-
orderBy
Sorts the elements of a sequence in ascending order according to a key. -
orderBy
<TKey> Enumerable<TSource> orderBy(Function1<TSource, TKey> keySelector, Comparator<TKey> comparator) Sorts the elements of a sequence in ascending order by using a specified comparer. -
orderByDescending
<TKey extends Comparable> Enumerable<TSource> orderByDescending(Function1<TSource, TKey> keySelector) Sorts the elements of a sequence in descending order according to a key. -
orderByDescending
<TKey> Enumerable<TSource> orderByDescending(Function1<TSource, TKey> keySelector, Comparator<TKey> comparator) Sorts the elements of a sequence in descending order by using a specified comparer. -
reverse
Enumerable<TSource> reverse()Inverts the order of the elements in a sequence. -
select
Projects each element of a sequence into a new form. -
select
Projects each element of a sequence into a new form by incorporating the element's index. -
selectMany
Projects each element of a sequence to anEnumerable<TSource>
and flattens the resulting sequences into one sequence. -
selectMany
Projects each element of a sequence to anEnumerable<TSource>
, and flattens the resulting sequences into one sequence. The index of each source element is used in the projected form of that element. -
selectMany
<TCollection,TResult> Enumerable<TResult> selectMany(Function2<TSource, Integer, Enumerable<TCollection>> collectionSelector, Function2<TSource, TCollection, TResult> resultSelector) Projects each element of a sequence to anEnumerable<TSource>
, flattens the resulting sequences into one sequence, and invokes a result selector function on each element therein. The index of each source element is used in the intermediate projected form of that element. -
selectMany
<TCollection,TResult> Enumerable<TResult> selectMany(Function1<TSource, Enumerable<TCollection>> collectionSelector, Function2<TSource, TCollection, TResult> resultSelector) Projects each element of a sequence to anEnumerable<TSource>
, flattens the resulting sequences into one sequence, and invokes a result selector function on each element therein. -
sequenceEqual
Determines whether two sequences are equal by comparing the elements by using the default equality comparer for their type. -
sequenceEqual
Determines whether two sequences are equal by comparing their elements by using a specifiedEqualityComparer<TSource>
. -
single
TSource single()Returns the only element of a sequence, and throws an exception if there is not exactly one element in the sequence. -
single
Returns the only element of a sequence that satisfies a specified condition, and throws an exception if more than one such element exists. -
singleOrDefault
@Nullable TSource singleOrDefault()Returns the only element of a sequence, or a default value if the sequence is empty; this method throws an exception if there is more than one element in the sequence. -
singleOrDefault
Returns the only element of a sequence that satisfies a specified condition or a default value if no such element exists; this method throws an exception if more than one element satisfies the condition. -
skip
Bypasses a specified number of elements in a sequence and then returns the remaining elements. -
skipWhile
Bypasses elements in a sequence as long as a specified condition is true and then returns the remaining elements. -
skipWhile
Bypasses elements in a sequence as long as a specified condition is true and then returns the remaining elements. The element's index is used in the logic of the predicate function. -
sum
Computes the sum of the sequence of Decimal values that are obtained by invoking a transform function on each element of the input sequence. -
sum
Computes the sum of the sequence of nullable Decimal values that are obtained by invoking a transform function on each element of the input sequence. -
sum
Computes the sum of the sequence of Double values that are obtained by invoking a transform function on each element of the input sequence. -
sum
Computes the sum of the sequence of nullable Double values that are obtained by invoking a transform function on each element of the input sequence. -
sum
Computes the sum of the sequence of int values that are obtained by invoking a transform function on each element of the input sequence. -
sum
Computes the sum of the sequence of nullable int values that are obtained by invoking a transform function on each element of the input sequence. -
sum
Computes the sum of the sequence of long values that are obtained by invoking a transform function on each element of the input sequence. -
sum
Computes the sum of the sequence of nullable long values that are obtained by invoking a transform function on each element of the input sequence. -
sum
Computes the sum of the sequence of Float values that are obtained by invoking a transform function on each element of the input sequence. -
sum
Computes the sum of the sequence of nullable Float values that are obtained by invoking a transform function on each element of the input sequence. -
take
Returns a specified number of contiguous elements from the start of a sequence. -
takeWhile
Returns elements from a sequence as long as a specified condition is true. -
takeWhile
Returns elements from a sequence as long as a specified condition is true. The element's index is used in the logic of the predicate function. -
toMap
Creates aMap<TKey, TValue>
from anEnumerable<TSource>
according to a specified key selector function.NOTE: Called
toDictionary
in LINQ.NET. -
toMap
<TKey> Map<TKey,TSource> toMap(Function1<TSource, TKey> keySelector, EqualityComparer<TKey> comparer) Creates aMap<TKey, TValue>
from anEnumerable<TSource>
according to a specified key selector function and key comparer. -
toMap
<TKey,TElement> Map<TKey,TElement> toMap(Function1<TSource, TKey> keySelector, Function1<TSource, TElement> elementSelector) Creates aMap<TKey, TValue>
from anEnumerable<TSource>
according to specified key selector and element selector functions. -
toMap
<TKey,TElement> Map<TKey,TElement> toMap(Function1<TSource, TKey> keySelector, Function1<TSource, TElement> elementSelector, EqualityComparer<TKey> comparer) Creates aMap<TKey, TValue>
from anEnumerable<TSource>
according to a specified key selector function, a comparer, and an element selector function. -
toList
Creates aList<TSource>
from anEnumerable<TSource>
. -
toLookup
Creates aLookup<TKey, TElement>
from anEnumerable<TSource>
according to a specified key selector function. -
toLookup
<TKey> Lookup<TKey,TSource> toLookup(Function1<TSource, TKey> keySelector, EqualityComparer<TKey> comparer) Creates aLookup<TKey, TElement>
from anEnumerable<TSource>
according to a specified key selector function and key comparer. -
toLookup
<TKey,TElement> Lookup<TKey,TElement> toLookup(Function1<TSource, TKey> keySelector, Function1<TSource, TElement> elementSelector) Creates aLookup<TKey, TElement>
from anEnumerable<TSource>
according to specified key selector and element selector functions. -
toLookup
<TKey,TElement> Lookup<TKey,TElement> toLookup(Function1<TSource, TKey> keySelector, Function1<TSource, TElement> elementSelector, EqualityComparer<TKey> comparer) Creates aLookup<TKey, TElement>
from anEnumerable<TSource>
according to a specified key selector function, a comparer and an element selector function. -
union
Produces the set union of two sequences by using the default equality comparer. -
union
Produces the set union of two sequences by using a specifiedEqualityComparer<TSource>
. -
where
Filters a sequence of values based on a predicate. -
where
Filters a sequence of values based on a predicate. Each element's index is used in the logic of the predicate function. -
zip
<T1,TResult> Enumerable<TResult> zip(Enumerable<T1> source1, Function2<TSource, T1, TResult> resultSelector) Applies a specified function to the corresponding elements of two sequences, producing a sequence of the results.
-