Class IgniteQueryableExtensions

Namespace

Apache.Ignite.Sql

Assembly

Apache.Ignite.dll

LINQ extensions for Apache Ignite SQL engine.

Use AsQueryable(ITransaction?, QueryableOptions?) and AsQueryable(ITransaction?, QueryableOptions?) to query Ignite with LINQ, then materialize the query results by calling ToResultSetAsync<T>(IQueryable<T>).

public static class IgniteQueryableExtensions

Inheritance

object

IgniteQueryableExtensions

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Methods

AllAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>)

Determines whether all elements of a sequence satisfy a condition.

public static Task<bool> AllAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, bool>> predicate)

Parameters

queryable IQueryable<TSource>

Query.

predicate Expression<Func<TSource, bool>>

Predicate.

Returns

Task<bool>

A Task representing the asynchronous operation. The task result contains true if the source sequence contains any elements; otherwise, false.

Type Parameters

TSource

Element type.

AnyAsync<TSource>(IQueryable<TSource>)

Determines whether a sequence contains any elements.

public static Task<bool> AnyAsync<TSource>(this IQueryable<TSource> queryable)

Parameters

queryable IQueryable<TSource>

Query.

Returns

Task<bool>

A Task representing the asynchronous operation. The task result contains true if the source sequence contains any elements; otherwise, false.

Type Parameters

TSource

Element type.

AnyAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>)

Determines whether any element of a sequence satisfies a condition.

public static Task<bool> AnyAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, bool>> predicate)

Parameters

queryable IQueryable<TSource>

Query.

predicate Expression<Func<TSource, bool>>

Predicate.

Returns

Task<bool>

A Task representing the asynchronous operation. The task result contains true if the source sequence contains any elements matching the specified predicate; otherwise, false.

Type Parameters

TSource

Element type.

AsAsyncEnumerable<T>(IQueryable<T>)

Executes the Ignite query represented by the provided queryable and returns the resulting IResultSet<T> as IAsyncEnumerable<T>.

public static IAsyncEnumerable<T> AsAsyncEnumerable<T>(this IQueryable<T> queryable)

Parameters

queryable IQueryable<T>

Queryable.

Returns

IAsyncEnumerable<T>

Result set.

Type Parameters

T

Result type.

AverageAsync(IQueryable<decimal>)

Returns the average of a sequence of values.

public static Task<decimal> AverageAsync(this IQueryable<decimal> queryable)

Parameters

queryable IQueryable<decimal>

Query.

Returns

Task<decimal>

A Task representing the asynchronous operation. The task result contains the average of a sequence of values.

AverageAsync(IQueryable<double>)

Returns the average of a sequence of values.

public static Task<double> AverageAsync(this IQueryable<double> queryable)

Parameters

queryable IQueryable<double>

Query.

Returns

Task<double>

A Task representing the asynchronous operation. The task result contains the average of a sequence of values.

AverageAsync(IQueryable<int>)

Returns the average of a sequence of values.

public static Task<double> AverageAsync(this IQueryable<int> queryable)

Parameters

queryable IQueryable<int>

Query.

Returns

Task<double>

A Task representing the asynchronous operation. The task result contains the average of a sequence of values.

AverageAsync(IQueryable<long>)

Returns the average of a sequence of values.

public static Task<double> AverageAsync(this IQueryable<long> queryable)

Parameters

queryable IQueryable<long>

Query.

Returns

Task<double>

A Task representing the asynchronous operation. The task result contains the average of a sequence of values.

AverageAsync(IQueryable<decimal?>)

Returns the average of a sequence of values.

public static Task<decimal?> AverageAsync(this IQueryable<decimal?> queryable)

Parameters

queryable IQueryable<decimal?>

Query.

Returns

Task<decimal?>

A Task representing the asynchronous operation. The task result contains the average of a sequence of values.

AverageAsync(IQueryable<double?>)

Returns the average of a sequence of values.

public static Task<double?> AverageAsync(this IQueryable<double?> queryable)

Parameters

queryable IQueryable<double?>

Query.

Returns

Task<double?>

A Task representing the asynchronous operation. The task result contains the average of a sequence of values.

AverageAsync(IQueryable<int?>)

Returns the average of a sequence of values.

public static Task<double?> AverageAsync(this IQueryable<int?> queryable)

Parameters

queryable IQueryable<int?>

Query.

Returns

Task<double?>

A Task representing the asynchronous operation. The task result contains the average of a sequence of values.

AverageAsync(IQueryable<long?>)

Returns the average of a sequence of values.

public static Task<double?> AverageAsync(this IQueryable<long?> queryable)

Parameters

queryable IQueryable<long?>

Query.

Returns

Task<double?>

A Task representing the asynchronous operation. The task result contains the average of a sequence of values.

AverageAsync(IQueryable<float?>)

Returns the average of a sequence of values.

public static Task<float?> AverageAsync(this IQueryable<float?> queryable)

Parameters

queryable IQueryable<float?>

Query.

Returns

Task<float?>

A Task representing the asynchronous operation. The task result contains the average of a sequence of values.

AverageAsync(IQueryable<float>)

Returns the average of a sequence of values.

public static Task<float> AverageAsync(this IQueryable<float> queryable)

Parameters

queryable IQueryable<float>

Query.

Returns

Task<float>

A Task representing the asynchronous operation. The task result contains the average of a sequence of values.

AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, decimal>>)

Returns the average of a sequence of values.

public static Task<decimal> AverageAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, decimal>> selector)

Parameters

queryable IQueryable<TSource>

Query.

selector Expression<Func<TSource, decimal>>

A projection function to apply to each element.

Returns

Task<decimal>

A Task representing the asynchronous operation. The task result contains the average of a sequence of values.

Type Parameters

TSource

Element type.

AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, double>>)

Returns the average of a sequence of values.

public static Task<double> AverageAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, double>> selector)

Parameters

queryable IQueryable<TSource>

Query.

selector Expression<Func<TSource, double>>

A projection function to apply to each element.

Returns

Task<double>

A Task representing the asynchronous operation. The task result contains the average of a sequence of values.

Type Parameters

TSource

Element type.

AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, int>>)

Returns the average of a sequence of values.

public static Task<double> AverageAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, int>> selector)

Parameters

queryable IQueryable<TSource>

Query.

selector Expression<Func<TSource, int>>

A projection function to apply to each element.

Returns

Task<double>

A Task representing the asynchronous operation. The task result contains the average of a sequence of values.

Type Parameters

TSource

Element type.

AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, long>>)

Returns the average of a sequence of values.

public static Task<double> AverageAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, long>> selector)

Parameters

queryable IQueryable<TSource>

Query.

selector Expression<Func<TSource, long>>

A projection function to apply to each element.

Returns

Task<double>

A Task representing the asynchronous operation. The task result contains the average of a sequence of values.

Type Parameters

TSource

Element type.

AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, decimal?>>)

Returns the average of a sequence of values.

public static Task<decimal?> AverageAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, decimal?>> selector)

Parameters

queryable IQueryable<TSource>

Query.

selector Expression<Func<TSource, decimal?>>

A projection function to apply to each element.

Returns

Task<decimal?>

A Task representing the asynchronous operation. The task result contains the average of a sequence of values.

Type Parameters

TSource

Element type.

AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, double?>>)

Returns the average of a sequence of values.

public static Task<double?> AverageAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, double?>> selector)

Parameters

queryable IQueryable<TSource>

Query.

selector Expression<Func<TSource, double?>>

A projection function to apply to each element.

Returns

Task<double?>

A Task representing the asynchronous operation. The task result contains the average of a sequence of values.

Type Parameters

TSource

Element type.

AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, int?>>)

Returns the average of a sequence of values.

public static Task<double?> AverageAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, int?>> selector)

Parameters

queryable IQueryable<TSource>

Query.

selector Expression<Func<TSource, int?>>

A projection function to apply to each element.

Returns

Task<double?>

A Task representing the asynchronous operation. The task result contains the average of a sequence of values.

Type Parameters

TSource

Element type.

AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, long?>>)

Returns the average of a sequence of values.

public static Task<double?> AverageAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, long?>> selector)

Parameters

queryable IQueryable<TSource>

Query.

selector Expression<Func<TSource, long?>>

A projection function to apply to each element.

Returns

Task<double?>

A Task representing the asynchronous operation. The task result contains the average of a sequence of values.

Type Parameters

TSource

Element type.

AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, float?>>)

Returns the average of a sequence of values.

public static Task<float?> AverageAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, float?>> selector)

Parameters

queryable IQueryable<TSource>

Query.

selector Expression<Func<TSource, float?>>

A projection function to apply to each element.

Returns

Task<float?>

A Task representing the asynchronous operation. The task result contains the average of a sequence of values.

Type Parameters

TSource

Element type.

AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, float>>)

Returns the average of a sequence of values.

public static Task<float> AverageAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, float>> selector)

Parameters

queryable IQueryable<TSource>

Query.

selector Expression<Func<TSource, float>>

A projection function to apply to each element.

Returns

Task<float>

A Task representing the asynchronous operation. The task result contains the average of a sequence of values.

Type Parameters

TSource

Element type.

CountAsync<TSource>(IQueryable<TSource>)

Returns the number of elements in a sequence.

public static Task<int> CountAsync<TSource>(this IQueryable<TSource> queryable)

Parameters

queryable IQueryable<TSource>

Query.

Returns

Task<int>

A Task representing the asynchronous operation. The task result contains the number of elements in the input sequence.

Type Parameters

TSource

Element type.

CountAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>)

Returns the number of elements in a sequence.

public static Task<int> CountAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, bool>> predicate)

Parameters

queryable IQueryable<TSource>

Query.

predicate Expression<Func<TSource, bool>>

Predicate.

Returns

Task<int>

A Task representing the asynchronous operation. The task result contains the number of elements in the input sequence.

Type Parameters

TSource

Element type.

ExecuteDeleteAsync<T>(IQueryable<T>)

Removes all rows that are matched by the specified query.

This method results in "DELETE FROM" distributed SQL query, performing bulk delete (as opposed to fetching all rows locally before deleting them).

public static Task<long> ExecuteDeleteAsync<T>(this IQueryable<T> query)

Parameters

query IQueryable<T>

Query.

Returns

Task<long>

Affected row count.

Type Parameters

T

Element type.

ExecuteDeleteAsync<T>(IQueryable<T>, Expression<Func<T, bool>>)

Removes all rows that are matched by the specified query.

This method results in "DELETE FROM .. WHERE .." distributed SQL query, performing bulk delete (as opposed to fetching all rows locally before deleting them).

public static Task<long> ExecuteDeleteAsync<T>(this IQueryable<T> query, Expression<Func<T, bool>> predicate)

Parameters

query IQueryable<T>

Query.

predicate Expression<Func<T, bool>>

Predicate.

Returns

Task<long>

Affected row count.

Type Parameters

T

Element type.

ExecuteUpdateAsync<T>(IQueryable<T>, Expression<Func<IUpdateDescriptor<T>, IUpdateDescriptor<T>>>)

Updates all rows that are matched by the specified query.

This method results in "UPDATE .. WHERE .." distributed SQL query, performing bulk update (as opposed to fetching all rows locally before updating them).

public static Task<long> ExecuteUpdateAsync<T>(this IQueryable<T> query, Expression<Func<IUpdateDescriptor<T>, IUpdateDescriptor<T>>> updateDescriptor)

Parameters

query IQueryable<T>

Query.

updateDescriptor Expression<Func<IUpdateDescriptor<T>, IUpdateDescriptor<T>>>

Update descriptor.

Returns

Task<long>

Affected row count.

Type Parameters

T

Element type.

FirstAsync<TSource>(IQueryable<TSource>)

Returns the first element of a sequence.

public static Task<TSource> FirstAsync<TSource>(this IQueryable<TSource> queryable)

Parameters

queryable IQueryable<TSource>

Query.

Returns

Task<TSource>

A Task representing the asynchronous operation. The task result contains the first element in the input sequence.

Type Parameters

TSource

Element type.

FirstAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>)

Returns the first element of a sequence.

public static Task<TSource> FirstAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, bool>> predicate)

Parameters

queryable IQueryable<TSource>

Query.

predicate Expression<Func<TSource, bool>>

Predicate.

Returns

Task<TSource>

A Task representing the asynchronous operation. The task result contains the first element in the input sequence.

Type Parameters

TSource

Element type.

FirstOrDefaultAsync<TSource>(IQueryable<TSource>)

Returns the first element of a sequence, or a default value if the sequence contains no elements.

public static Task<TSource?> FirstOrDefaultAsync<TSource>(this IQueryable<TSource> queryable)

Parameters

queryable IQueryable<TSource>

Query.

Returns

Task<TSource>

A Task representing the asynchronous operation. The task result contains default ( TSource ) if queryable is empty; otherwise, the first element in queryable.

Type Parameters

TSource

Element type.

FirstOrDefaultAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>)

Returns the first element of a sequence, or a default value if the sequence contains no elements.

public static Task<TSource?> FirstOrDefaultAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, bool>> predicate)

Parameters

queryable IQueryable<TSource>

Query.

predicate Expression<Func<TSource, bool>>

Predicate.

Returns

Task<TSource>

A Task representing the asynchronous operation. The task result contains default ( TSource ) if queryable is empty; otherwise, the first element in queryable.

Type Parameters

TSource

Element type.

LongCountAsync<TSource>(IQueryable<TSource>)

Returns a long that represents the total number of elements in a sequence.

public static Task<long> LongCountAsync<TSource>(this IQueryable<TSource> queryable)

Parameters

queryable IQueryable<TSource>

Query.

Returns

Task<long>

A Task representing the asynchronous operation. The task result contains the number of elements in the input sequence.

Type Parameters

TSource

Element type.

LongCountAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>)

Returns a long that represents the total number of elements in a sequence.

public static Task<long> LongCountAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, bool>> predicate)

Parameters

queryable IQueryable<TSource>

Query.

predicate Expression<Func<TSource, bool>>

Predicate.

Returns

Task<long>

A Task representing the asynchronous operation. The task result contains the number of elements in the input sequence.

Type Parameters

TSource

Element type.

MaxAsync<TSource>(IQueryable<TSource>)

Returns the maximum value of a sequence.

public static Task<TSource> MaxAsync<TSource>(this IQueryable<TSource> queryable)

Parameters

queryable IQueryable<TSource>

Query.

Returns

Task<TSource>

A Task representing the asynchronous operation. The task result contains the maximum value in the sequence.

Type Parameters

TSource

Element type.

MaxAsync<TSource, TResult>(IQueryable<TSource>, Expression<Func<TSource, TResult>>)

Returns the maximum value of a sequence.

public static Task<TResult> MaxAsync<TSource, TResult>(this IQueryable<TSource> queryable, Expression<Func<TSource, TResult>> selector)

Parameters

queryable IQueryable<TSource>

Query.

selector Expression<Func<TSource, TResult>>

A projection function to apply to each element.

Returns

Task<TResult>

A Task representing the asynchronous operation. The task result contains the maximum value in the sequence.

Type Parameters

TSource

Element type.

TResult

The type of the value returned by the function represented by selector.

MinAsync<TSource>(IQueryable<TSource>)

Returns the minimum value of a sequence.

public static Task<TSource> MinAsync<TSource>(this IQueryable<TSource> queryable)

Parameters

queryable IQueryable<TSource>

Query.

Returns

Task<TSource>

A Task representing the asynchronous operation. The task result contains the minimum value in the sequence.

Type Parameters

TSource

Element type.

MinAsync<TSource, TResult>(IQueryable<TSource>, Expression<Func<TSource, TResult>>)

Returns the minimum value of a sequence.

public static Task<TResult> MinAsync<TSource, TResult>(this IQueryable<TSource> queryable, Expression<Func<TSource, TResult>> selector)

Parameters

queryable IQueryable<TSource>

Query.

selector Expression<Func<TSource, TResult>>

A projection function to apply to each element.

Returns

Task<TResult>

A Task representing the asynchronous operation. The task result contains the minimum value in the sequence.

Type Parameters

TSource

Element type.

TResult

The type of the value returned by the function represented by selector.

SingleAsync<TSource>(IQueryable<TSource>)

Returns the only element of a sequence, and throws an exception if there is not exactly one element in the sequence.

public static Task<TSource> SingleAsync<TSource>(this IQueryable<TSource> queryable)

Parameters

queryable IQueryable<TSource>

Query.

Returns

Task<TSource>

A Task representing the asynchronous operation. The task result contains the single element of the input sequence.

Type Parameters

TSource

Element type.

SingleAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>)

Returns the only element of a sequence, and throws an exception if there is not exactly one element in the sequence.

public static Task<TSource> SingleAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, bool>> predicate)

Parameters

queryable IQueryable<TSource>

Query.

predicate Expression<Func<TSource, bool>>

Predicate.

Returns

Task<TSource>

A Task representing the asynchronous operation. The task result contains the single element of the input sequence.

Type Parameters

TSource

Element type.

SingleOrDefaultAsync<TSource>(IQueryable<TSource>)

Returns the only element of a sequence, or a default value if the sequence is empty; throws an exception if there is more than one element in the sequence.

public static Task<TSource?> SingleOrDefaultAsync<TSource>(this IQueryable<TSource> queryable)

Parameters

queryable IQueryable<TSource>

Query.

Returns

Task<TSource>

A Task representing the asynchronous operation. The task result contains the single element of the input sequence, or default (TSource) if the sequence contains no elements.

Type Parameters

TSource

Element type.

SingleOrDefaultAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>)

Returns the only element of a sequence, or a default value if the sequence is empty; throws an exception if there is more than one element in the sequence.

public static Task<TSource?> SingleOrDefaultAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, bool>> predicate)

Parameters

queryable IQueryable<TSource>

Query.

predicate Expression<Func<TSource, bool>>

Predicate.

Returns

Task<TSource>

A Task representing the asynchronous operation. The task result contains the single element of the input sequence, or default (TSource) if the sequence contains no elements.

Type Parameters

TSource

Element type.

SumAsync(IQueryable<decimal>)

Returns the sum of a sequence of values.

public static Task<decimal> SumAsync(this IQueryable<decimal> queryable)

Parameters

queryable IQueryable<decimal>

Query.

Returns

Task<decimal>

A Task representing the asynchronous operation. The task result contains the sum of a sequence of values.

SumAsync(IQueryable<double>)

Returns the sum of a sequence of values.

public static Task<double> SumAsync(this IQueryable<double> queryable)

Parameters

queryable IQueryable<double>

Query.

Returns

Task<double>

A Task representing the asynchronous operation. The task result contains the sum of a sequence of values.

SumAsync(IQueryable<int>)

Returns the sum of a sequence of values.

public static Task<int> SumAsync(this IQueryable<int> queryable)

Parameters

queryable IQueryable<int>

Query.

Returns

Task<int>

A Task representing the asynchronous operation. The task result contains the sum of a sequence of values.

SumAsync(IQueryable<long>)

Returns the sum of a sequence of values.

public static Task<long> SumAsync(this IQueryable<long> queryable)

Parameters

queryable IQueryable<long>

Query.

Returns

Task<long>

A Task representing the asynchronous operation. The task result contains the sum of a sequence of values.

SumAsync(IQueryable<decimal?>)

Returns the sum of a sequence of values.

public static Task<decimal?> SumAsync(this IQueryable<decimal?> queryable)

Parameters

queryable IQueryable<decimal?>

Query.

Returns

Task<decimal?>

A Task representing the asynchronous operation. The task result contains the sum of a sequence of values.

SumAsync(IQueryable<double?>)

Returns the sum of a sequence of values.

public static Task<double?> SumAsync(this IQueryable<double?> queryable)

Parameters

queryable IQueryable<double?>

Query.

Returns

Task<double?>

A Task representing the asynchronous operation. The task result contains the sum of a sequence of values.

SumAsync(IQueryable<int?>)

Returns the sum of a sequence of values.

public static Task<int?> SumAsync(this IQueryable<int?> queryable)

Parameters

queryable IQueryable<int?>

Query.

Returns

Task<int?>

A Task representing the asynchronous operation. The task result contains the sum of a sequence of values.

SumAsync(IQueryable<long?>)

Returns the sum of a sequence of values.

public static Task<long?> SumAsync(this IQueryable<long?> queryable)

Parameters

queryable IQueryable<long?>

Query.

Returns

Task<long?>

A Task representing the asynchronous operation. The task result contains the sum of a sequence of values.

SumAsync(IQueryable<float?>)

Returns the sum of a sequence of values.

public static Task<float?> SumAsync(this IQueryable<float?> queryable)

Parameters

queryable IQueryable<float?>

Query.

Returns

Task<float?>

A Task representing the asynchronous operation. The task result contains the sum of a sequence of values.

SumAsync(IQueryable<float>)

Returns the sum of a sequence of values.

public static Task<float> SumAsync(this IQueryable<float> queryable)

Parameters

queryable IQueryable<float>

Query.

Returns

Task<float>

A Task representing the asynchronous operation. The task result contains the sum of a sequence of values.

SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, decimal>>)

Returns the sum of a sequence of values.

public static Task<decimal> SumAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, decimal>> selector)

Parameters

queryable IQueryable<TSource>

Query.

selector Expression<Func<TSource, decimal>>

A projection function to apply to each element.

Returns

Task<decimal>

A Task representing the asynchronous operation. The task result contains the sum of a sequence of values.

Type Parameters

TSource

Element type.

SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, double>>)

Returns the sum of a sequence of values.

public static Task<double> SumAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, double>> selector)

Parameters

queryable IQueryable<TSource>

Query.

selector Expression<Func<TSource, double>>

A projection function to apply to each element.

Returns

Task<double>

A Task representing the asynchronous operation. The task result contains the sum of a sequence of values.

Type Parameters

TSource

Element type.

SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, int>>)

Returns the sum of a sequence of values.

public static Task<int> SumAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, int>> selector)

Parameters

queryable IQueryable<TSource>

Query.

selector Expression<Func<TSource, int>>

A projection function to apply to each element.

Returns

Task<int>

A Task representing the asynchronous operation. The task result contains the sum of a sequence of values.

Type Parameters

TSource

Element type.

SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, long>>)

Returns the sum of a sequence of values.

public static Task<long> SumAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, long>> selector)

Parameters

queryable IQueryable<TSource>

Query.

selector Expression<Func<TSource, long>>

A projection function to apply to each element.

Returns

Task<long>

A Task representing the asynchronous operation. The task result contains the sum of a sequence of values.

Type Parameters

TSource

Element type.

SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, decimal?>>)

Returns the sum of a sequence of values.

public static Task<decimal?> SumAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, decimal?>> selector)

Parameters

queryable IQueryable<TSource>

Query.

selector Expression<Func<TSource, decimal?>>

A projection function to apply to each element.

Returns

Task<decimal?>

A Task representing the asynchronous operation. The task result contains the sum of a sequence of values.

Type Parameters

TSource

Element type.

SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, double?>>)

Returns the sum of a sequence of values.

public static Task<double?> SumAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, double?>> selector)

Parameters

queryable IQueryable<TSource>

Query.

selector Expression<Func<TSource, double?>>

A projection function to apply to each element.

Returns

Task<double?>

A Task representing the asynchronous operation. The task result contains the sum of a sequence of values.

Type Parameters

TSource

Element type.

SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, int?>>)

Returns the sum of a sequence of values.

public static Task<int?> SumAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, int?>> selector)

Parameters

queryable IQueryable<TSource>

Query.

selector Expression<Func<TSource, int?>>

A projection function to apply to each element.

Returns

Task<int?>

A Task representing the asynchronous operation. The task result contains the sum of a sequence of values.

Type Parameters

TSource

Element type.

SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, long?>>)

Returns the sum of a sequence of values.

public static Task<long?> SumAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, long?>> selector)

Parameters

queryable IQueryable<TSource>

Query.

selector Expression<Func<TSource, long?>>

A projection function to apply to each element.

Returns

Task<long?>

A Task representing the asynchronous operation. The task result contains the sum of a sequence of values.

Type Parameters

TSource

Element type.

SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, float?>>)

Returns the sum of a sequence of values.

public static Task<float?> SumAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, float?>> selector)

Parameters

queryable IQueryable<TSource>

Query.

selector Expression<Func<TSource, float?>>

A projection function to apply to each element.

Returns

Task<float?>

A Task representing the asynchronous operation. The task result contains the sum of a sequence of values.

Type Parameters

TSource

Element type.

SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, float>>)

Returns the sum of a sequence of values.

public static Task<float> SumAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, float>> selector)

Parameters

queryable IQueryable<TSource>

Query.

selector Expression<Func<TSource, float>>

A projection function to apply to each element.

Returns

Task<float>

A Task representing the asynchronous operation. The task result contains the sum of a sequence of values.

Type Parameters

TSource

Element type.

ToDictionaryAsync<TSource, TK, TV>(IQueryable<TSource>, Func<TSource, TK>, Func<TSource, TV>, IEqualityComparer<TK>?)

Creates a Dictionary<TKey, TValue> from an IQueryable<T> by enumerating it asynchronously.

public static Task<Dictionary<TK, TV>> ToDictionaryAsync<TSource, TK, TV>(this IQueryable<TSource> queryable, Func<TSource, TK> keySelector, Func<TSource, TV> valSelector, IEqualityComparer<TK>? comparer = null) where TK : notnull

Parameters

queryable IQueryable<TSource>

Query.

keySelector Func<TSource, TK>

Key selector.

valSelector Func<TSource, TV>

Value selector.

comparer IEqualityComparer<TK>

Optional comparer.

Returns

Task<Dictionary<TK, TV>>

A Task representing the asynchronous operation. The task result contains a Dictionary<TKey, TValue> that contains elements from the input sequence.

Type Parameters

TSource

Element type.

TK

Dictionary key type.

TV

Dictionary value type.

ToListAsync<TSource>(IQueryable<TSource>)

Creates a List<T> from an IQueryable<T> by enumerating it asynchronously.

public static Task<List<TSource>> ToListAsync<TSource>(this IQueryable<TSource> queryable)

Parameters

queryable IQueryable<TSource>

Query.

Returns

Task<List<TSource>>

A Task representing the asynchronous operation. The task result contains a List<T> that contains elements from the input sequence.

Type Parameters

TSource

Element type.

ToQueryString(IQueryable)

Generates SQL representation of the specified query.

public static string ToQueryString(this IQueryable queryable)

Parameters

queryable IQueryable

Query.

Returns

string

SQL string.

ToResultSetAsync<T>(IQueryable<T>)

Executes the Ignite query represented by the provided queryable and returns the resulting IResultSet<T>.

public static Task<IResultSet<T>> ToResultSetAsync<T>(this IQueryable<T> queryable)

Parameters

queryable IQueryable<T>

Queryable.

Returns

Task<IResultSet<T>>

Result set.

Type Parameters

T

Result type.