releases/3.0.0-beta1/dotnetdoc/api/Apache.Ignite.Sql.IgniteQueryableExtensions.html

<!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>Class IgniteQueryableExtensions | Apache Ignite.NET API Documentation </title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta name="title" content="Class IgniteQueryableExtensions | Apache Ignite.NET API Documentation "> <link rel="icon" href="../images/favicon.ico"> <link rel="stylesheet" href="../styles/docfx.min.css"> <link rel="stylesheet" href="../styles/main.css"> <meta name="docfx:navrel" content="../toc.html"> <meta name="docfx:tocrel" content="toc.html"> <meta name="docfx:rel" content="../"> <meta name="docfx:docurl" content="https://github.com/apache/ignite-3/new/main/apiSpec/new?filename=Apache_Ignite_Sql_IgniteQueryableExtensions.md&value=---%0Auid%3A%20Apache.Ignite.Sql.IgniteQueryableExtensions%0Asummary%3A%20'*You%20can%20override%20summary%20for%20the%20API%20here%20using%20*MARKDOWN*%20syntax'%0A---%0A%0A*Please%20type%20below%20more%20information%20about%20this%20API%3A*%0A%0A"> <script> MathJax = { options: { processHtmlClass: ['tex2jax_process', 'math'] } }; </script> <script type="text/javascript" src="../styles/docfx.min.js"></script> <script type="text/javascript" src="../styles/main.js"></script> </head> <body class="tex2jax_ignore" data-layout="" data-yaml-mime="ManagedReference"> <header class="bg-body border-bottom"> <nav id="autocollapse" class="navbar navbar-expand-md" role="navigation"> <div class="container-xxl flex-nowrap"> <a class="navbar-brand" href="../index.html"> <img id="logo" class="svg" src="../images/logo.svg" alt=""> </a> <button class="btn btn-lg d-md-none border-0" type="button" data-bs-toggle="collapse" data-bs-target="#navpanel" aria-controls="navpanel" aria-expanded="false" aria-label="Toggle navigation"> <i class="bi bi-three-dots"></i> </button> <div class="collapse navbar-collapse" id="navpanel"> <div id="navbar"> <form class="search" role="search" id="search"> <i class="bi bi-search"></i> <input class="form-control" id="search-query" type="search" disabled="" placeholder="Search" autocomplete="off" aria-label="Search"> </form> </div> </div> </div> </nav> </header> <main class="container-xxl"> <div class="toc-offcanvas"> <div class="offcanvas-md offcanvas-start" tabindex="-1" id="tocOffcanvas" aria-labelledby="tocOffcanvasLabel"> <div class="offcanvas-header"> <h5 class="offcanvas-title" id="tocOffcanvasLabel">Table of Contents</h5> <button type="button" class="btn-close" data-bs-dismiss="offcanvas" data-bs-target="#tocOffcanvas" aria-label="Close"></button> </div> <div class="offcanvas-body"> <nav class="toc" id="toc"></nav> </div> </div> </div> <div class="content"> <div class="actionbar"> <button class="btn btn-lg border-0 d-md-none" style="margin-top: -.65em; margin-left: -.8em" type="button" data-bs-toggle="offcanvas" data-bs-target="#tocOffcanvas" aria-controls="tocOffcanvas" aria-expanded="false" aria-label="Show table of contents"> <i class="bi bi-list"></i> </button> <nav id="breadcrumb"></nav> </div> <article data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions"> <h1 id="Apache_Ignite_Sql_IgniteQueryableExtensions" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions" class="text-break"> Class IgniteQueryableExtensions <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Sum.cs/#L35"><i class="bi bi-code-slash"></i></a> </h1> <div class="facts text-secondary"> <dl><dt>Namespace</dt><dd><a class="xref" href="Apache.html">Apache</a>.<a class="xref" href="Apache.Ignite.html">Ignite</a>.<a class="xref" href="Apache.Ignite.Sql.html">Sql</a></dd></dl> <dl><dt>Assembly</dt><dd>Apache.Ignite.dll</dd></dl> </div> <div class="markdown summary"><p>LINQ extensions for Apache Ignite SQL engine.</p> <p></p> Use <a class="xref" href="Apache.Ignite.Table.IRecordView-1.html#Apache_Ignite_Table_IRecordView_1_AsQueryable_Apache_Ignite_Transactions_ITransaction_Apache_Ignite_Sql_QueryableOptions_">AsQueryable(ITransaction?, QueryableOptions?)</a> and <a class="xref" href="Apache.Ignite.Table.IKeyValueView-2.html#Apache_Ignite_Table_IKeyValueView_2_AsQueryable_Apache_Ignite_Transactions_ITransaction_Apache_Ignite_Sql_QueryableOptions_">AsQueryable(ITransaction?, QueryableOptions?)</a> to query Ignite with LINQ, then materialize the query results by calling <a class="xref" href="Apache.Ignite.Sql.IgniteQueryableExtensions.html#Apache_Ignite_Sql_IgniteQueryableExtensions_ToResultSetAsync__1_System_Linq_IQueryable___0__">ToResultSetAsync<T>(IQueryable<T>)</a>. </div> <div class="markdown conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static class IgniteQueryableExtensions</code></pre> </div> <dl class="typelist inheritance"> <dt>Inheritance</dt> <dd> <div><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a></div> <div><span class="xref">IgniteQueryableExtensions</span></div> </dd> </dl> <dl class="typelist derived"> <dt>Inherited Members</dt> <dd> <div> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object.equals#system-object-equals(system-object)">object.Equals(object)</a> </div> <div> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object.equals#system-object-equals(system-object-system-object)">object.Equals(object, object)</a> </div> <div> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object.gethashcode">object.GetHashCode()</a> </div> <div> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object.gettype">object.GetType()</a> </div> <div> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object.memberwiseclone">object.MemberwiseClone()</a> </div> <div> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object.referenceequals">object.ReferenceEquals(object, object)</a> </div> <div> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object.tostring">object.ToString()</a> </div> </dd></dl> <h2 class="section" id="methods">Methods </h2> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_AllAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AllAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_AllAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Boolean___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AllAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Boolean}})"> AllAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.cs/#L130"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Determines whether all elements of a sequence satisfy a condition.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<bool> AllAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, bool>> predicate)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>predicate</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a>>></dt> <dd><p>Predicate.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains <a href="https://learn.microsoft.com/dotnet/csharp/language-reference/builtin-types/bool">true</a> if the source sequence contains any elements; otherwise, <a href="https://learn.microsoft.com/dotnet/csharp/language-reference/builtin-types/bool">false</a>.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_AnyAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AnyAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_AnyAsync__1_System_Linq_IQueryable___0__" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AnyAsync``1(System.Linq.IQueryable{``0})"> AnyAsync<TSource>(IQueryable<TSource>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.cs/#L85"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Determines whether a sequence contains any elements.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<bool> AnyAsync<TSource>(this IQueryable<TSource> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains <a href="https://learn.microsoft.com/dotnet/csharp/language-reference/builtin-types/bool">true</a> if the source sequence contains any elements; otherwise, <a href="https://learn.microsoft.com/dotnet/csharp/language-reference/builtin-types/bool">false</a>.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_AnyAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AnyAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_AnyAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Boolean___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AnyAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Boolean}})"> AnyAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.cs/#L108"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Determines whether any element of a sequence satisfies a condition.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<bool> AnyAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, bool>> predicate)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>predicate</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a>>></dt> <dd><p>Predicate.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains <a href="https://learn.microsoft.com/dotnet/csharp/language-reference/builtin-types/bool">true</a> if the source sequence contains any elements matching the specified predicate; otherwise, <a href="https://learn.microsoft.com/dotnet/csharp/language-reference/builtin-types/bool">false</a>.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_AsAsyncEnumerable_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AsAsyncEnumerable*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_AsAsyncEnumerable__1_System_Linq_IQueryable___0__" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AsAsyncEnumerable``1(System.Linq.IQueryable{``0})"> AsAsyncEnumerable<T>(IQueryable<T>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.cs/#L63"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Executes the Ignite query represented by the provided <code class="paramref">queryable</code> and returns the resulting <a class="xref" href="Apache.Ignite.Sql.IResultSet-1.html">IResultSet<T></a> as <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.collections.generic.iasyncenumerable-1">IAsyncEnumerable<T></a>.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static IAsyncEnumerable<T> AsAsyncEnumerable<T>(this IQueryable<T> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><T></dt> <dd><p>Queryable.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.collections.generic.iasyncenumerable-1">IAsyncEnumerable</a><T></dt> <dd><p>Result set.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>T</code></dt> <dd><p>Result type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_System_Linq_IQueryable_System_Decimal__" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync(System.Linq.IQueryable{System.Decimal})"> AverageAsync(IQueryable<decimal>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Average.cs/#L380"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the average of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<decimal> AverageAsync(this IQueryable<decimal> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.decimal">decimal</a>></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.decimal">decimal</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the average of a sequence of values.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_System_Linq_IQueryable_System_Double__" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync(System.Linq.IQueryable{System.Double})"> AverageAsync(IQueryable<double>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Average.cs/#L212"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the average of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<double> AverageAsync(this IQueryable<double> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a>></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the average of a sequence of values.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_System_Linq_IQueryable_System_Int32__" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync(System.Linq.IQueryable{System.Int32})"> AverageAsync(IQueryable<int>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Average.cs/#L44"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the average of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<double> AverageAsync(this IQueryable<int> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a>></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the average of a sequence of values.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_System_Linq_IQueryable_System_Int64__" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync(System.Linq.IQueryable{System.Int64})"> AverageAsync(IQueryable<long>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Average.cs/#L128"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the average of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<double> AverageAsync(this IQueryable<long> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int64">long</a>></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the average of a sequence of values.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_System_Linq_IQueryable_System_Nullable_System_Decimal___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync(System.Linq.IQueryable{System.Nullable{System.Decimal}})"> AverageAsync(IQueryable<decimal?>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Average.cs/#L422"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the average of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<decimal?> AverageAsync(this IQueryable<decimal?> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.decimal">decimal</a>?></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.decimal">decimal</a>?></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the average of a sequence of values.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_System_Linq_IQueryable_System_Nullable_System_Double___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync(System.Linq.IQueryable{System.Nullable{System.Double}})"> AverageAsync(IQueryable<double?>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Average.cs/#L254"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the average of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<double?> AverageAsync(this IQueryable<double?> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a>?></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a>?></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the average of a sequence of values.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_System_Linq_IQueryable_System_Nullable_System_Int32___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync(System.Linq.IQueryable{System.Nullable{System.Int32}})"> AverageAsync(IQueryable<int?>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Average.cs/#L86"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the average of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<double?> AverageAsync(this IQueryable<int?> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a>?></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a>?></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the average of a sequence of values.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_System_Linq_IQueryable_System_Nullable_System_Int64___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync(System.Linq.IQueryable{System.Nullable{System.Int64}})"> AverageAsync(IQueryable<long?>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Average.cs/#L170"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the average of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<double?> AverageAsync(this IQueryable<long?> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int64">long</a>?></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a>?></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the average of a sequence of values.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_System_Linq_IQueryable_System_Nullable_System_Single___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync(System.Linq.IQueryable{System.Nullable{System.Single}})"> AverageAsync(IQueryable<float?>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Average.cs/#L338"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the average of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<float?> AverageAsync(this IQueryable<float?> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.single">float</a>?></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.single">float</a>?></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the average of a sequence of values.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_System_Linq_IQueryable_System_Single__" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync(System.Linq.IQueryable{System.Single})"> AverageAsync(IQueryable<float>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Average.cs/#L296"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the average of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<float> AverageAsync(this IQueryable<float> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.single">float</a>></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.single">float</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the average of a sequence of values.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Decimal___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Decimal}})"> AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, decimal>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Average.cs/#L401"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the average of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<decimal> AverageAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, decimal>> selector)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>selector</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.decimal">decimal</a>>></dt> <dd><p>A projection function to apply to each element.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.decimal">decimal</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the average of a sequence of values.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Double___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Double}})"> AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, double>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Average.cs/#L233"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the average of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<double> AverageAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, double>> selector)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>selector</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a>>></dt> <dd><p>A projection function to apply to each element.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the average of a sequence of values.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Int32___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Int32}})"> AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, int>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Average.cs/#L65"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the average of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<double> AverageAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, int>> selector)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>selector</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a>>></dt> <dd><p>A projection function to apply to each element.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the average of a sequence of values.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Int64___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Int64}})"> AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, long>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Average.cs/#L149"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the average of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<double> AverageAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, long>> selector)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>selector</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int64">long</a>>></dt> <dd><p>A projection function to apply to each element.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the average of a sequence of values.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Nullable_System_Decimal____" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Nullable{System.Decimal}}})"> AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, decimal?>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Average.cs/#L443"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the average of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<decimal?> AverageAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, decimal?>> selector)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>selector</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.decimal">decimal</a>?>></dt> <dd><p>A projection function to apply to each element.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.decimal">decimal</a>?></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the average of a sequence of values.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Nullable_System_Double____" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Nullable{System.Double}}})"> AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, double?>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Average.cs/#L275"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the average of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<double?> AverageAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, double?>> selector)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>selector</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a>?>></dt> <dd><p>A projection function to apply to each element.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a>?></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the average of a sequence of values.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Nullable_System_Int32____" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Nullable{System.Int32}}})"> AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, int?>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Average.cs/#L107"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the average of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<double?> AverageAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, int?>> selector)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>selector</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a>?>></dt> <dd><p>A projection function to apply to each element.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a>?></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the average of a sequence of values.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Nullable_System_Int64____" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Nullable{System.Int64}}})"> AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, long?>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Average.cs/#L191"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the average of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<double?> AverageAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, long?>> selector)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>selector</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int64">long</a>?>></dt> <dd><p>A projection function to apply to each element.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a>?></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the average of a sequence of values.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Nullable_System_Single____" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Nullable{System.Single}}})"> AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, float?>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Average.cs/#L359"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the average of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<float?> AverageAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, float?>> selector)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>selector</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.single">float</a>?>></dt> <dd><p>A projection function to apply to each element.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.single">float</a>?></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the average of a sequence of values.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_AverageAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Single___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.AverageAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Single}})"> AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, float>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Average.cs/#L317"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the average of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<float> AverageAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, float>> selector)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>selector</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.single">float</a>>></dt> <dd><p>A projection function to apply to each element.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.single">float</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the average of a sequence of values.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_CountAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.CountAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_CountAsync__1_System_Linq_IQueryable___0__" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.CountAsync``1(System.Linq.IQueryable{``0})"> CountAsync<TSource>(IQueryable<TSource>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.cs/#L149"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the number of elements in a sequence.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<int> CountAsync<TSource>(this IQueryable<TSource> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the number of elements in the input sequence.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_CountAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.CountAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_CountAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Boolean___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.CountAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Boolean}})"> CountAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.cs/#L169"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the number of elements in a sequence.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<int> CountAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, bool>> predicate)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>predicate</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a>>></dt> <dd><p>Predicate.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the number of elements in the input sequence.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_ExecuteDeleteAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.ExecuteDeleteAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_ExecuteDeleteAsync__1_System_Linq_IQueryable___0__" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.ExecuteDeleteAsync``1(System.Linq.IQueryable{``0})"> ExecuteDeleteAsync<T>(IQueryable<T>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Dml.cs/#L45"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Removes all rows that are matched by the specified query.</p> <p></p> This method results in "DELETE FROM" distributed SQL query, performing bulk delete (as opposed to fetching all rows locally before deleting them). </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<long> ExecuteDeleteAsync<T>(this IQueryable<T> query)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>query</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><T></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int64">long</a>></dt> <dd><p>Affected row count.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>T</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_ExecuteDeleteAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.ExecuteDeleteAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_ExecuteDeleteAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Boolean___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.ExecuteDeleteAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Boolean}})"> ExecuteDeleteAsync<T>(IQueryable<T>, Expression<Func<T, bool>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Dml.cs/#L66"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Removes all rows that are matched by the specified query.</p> <p></p> This method results in "DELETE FROM .. WHERE .." distributed SQL query, performing bulk delete (as opposed to fetching all rows locally before deleting them). </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<long> ExecuteDeleteAsync<T>(this IQueryable<T> query, Expression<Func<T, bool>> predicate)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>query</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><T></dt> <dd><p>Query.</p> </dd> <dt><code>predicate</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><T, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a>>></dt> <dd><p>Predicate.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int64">long</a>></dt> <dd><p>Affected row count.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>T</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_ExecuteUpdateAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.ExecuteUpdateAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_ExecuteUpdateAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func_Apache_Ignite_Sql_IUpdateDescriptor___0__Apache_Ignite_Sql_IUpdateDescriptor___0____" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.ExecuteUpdateAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{Apache.Ignite.Sql.IUpdateDescriptor{``0},Apache.Ignite.Sql.IUpdateDescriptor{``0}}})"> ExecuteUpdateAsync<T>(IQueryable<T>, Expression<Func<IUpdateDescriptor<T>, IUpdateDescriptor<T>>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Dml.cs/#L87"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Updates all rows that are matched by the specified query.</p> <p></p> This method results in "UPDATE .. WHERE .." distributed SQL query, performing bulk update (as opposed to fetching all rows locally before updating them). </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<long> ExecuteUpdateAsync<T>(this IQueryable<T> query, Expression<Func<IUpdateDescriptor<T>, IUpdateDescriptor<T>>> updateDescriptor)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>query</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><T></dt> <dd><p>Query.</p> </dd> <dt><code>updateDescriptor</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><<a class="xref" href="Apache.Ignite.Sql.IUpdateDescriptor-1.html">IUpdateDescriptor</a><T>, <a class="xref" href="Apache.Ignite.Sql.IUpdateDescriptor-1.html">IUpdateDescriptor</a><T>>></dt> <dd><p>Update descriptor.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int64">long</a>></dt> <dd><p>Affected row count.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>T</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_FirstAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.FirstAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_FirstAsync__1_System_Linq_IQueryable___0__" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.FirstAsync``1(System.Linq.IQueryable{``0})"> FirstAsync<TSource>(IQueryable<TSource>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.cs/#L227"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the first element of a sequence.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<TSource> FirstAsync<TSource>(this IQueryable<TSource> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><TSource></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the first element in the input sequence.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_FirstAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.FirstAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_FirstAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Boolean___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.FirstAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Boolean}})"> FirstAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.cs/#L247"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the first element of a sequence.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<TSource> FirstAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, bool>> predicate)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>predicate</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a>>></dt> <dd><p>Predicate.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><TSource></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the first element in the input sequence.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_FirstOrDefaultAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.FirstOrDefaultAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_FirstOrDefaultAsync__1_System_Linq_IQueryable___0__" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.FirstOrDefaultAsync``1(System.Linq.IQueryable{``0})"> FirstOrDefaultAsync<TSource>(IQueryable<TSource>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.cs/#L268"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the first element of a sequence, or a default value if the sequence contains no elements.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<TSource?> FirstOrDefaultAsync<TSource>(this IQueryable<TSource> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><TSource></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains <a href="https://learn.microsoft.com/dotnet/csharp/language-reference/keywords/default">default</a> ( <code class="typeparamref">TSource</code> ) if <code class="paramref">queryable</code> is empty; otherwise, the first element in <code class="paramref">queryable</code>.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_FirstOrDefaultAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.FirstOrDefaultAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_FirstOrDefaultAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Boolean___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.FirstOrDefaultAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Boolean}})"> FirstOrDefaultAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.cs/#L290"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the first element of a sequence, or a default value if the sequence contains no elements.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<TSource?> FirstOrDefaultAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, bool>> predicate)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>predicate</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a>>></dt> <dd><p>Predicate.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><TSource></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains <a href="https://learn.microsoft.com/dotnet/csharp/language-reference/keywords/default">default</a> ( <code class="typeparamref">TSource</code> ) if <code class="paramref">queryable</code> is empty; otherwise, the first element in <code class="paramref">queryable</code>.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_LongCountAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.LongCountAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_LongCountAsync__1_System_Linq_IQueryable___0__" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.LongCountAsync``1(System.Linq.IQueryable{``0})"> LongCountAsync<TSource>(IQueryable<TSource>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.cs/#L188"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns a <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int64">long</a> that represents the total number of elements in a sequence.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<long> LongCountAsync<TSource>(this IQueryable<TSource> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int64">long</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the number of elements in the input sequence.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_LongCountAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.LongCountAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_LongCountAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Boolean___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.LongCountAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Boolean}})"> LongCountAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.cs/#L208"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns a <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int64">long</a> that represents the total number of elements in a sequence.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<long> LongCountAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, bool>> predicate)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>predicate</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a>>></dt> <dd><p>Predicate.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int64">long</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the number of elements in the input sequence.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_MaxAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.MaxAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_MaxAsync__1_System_Linq_IQueryable___0__" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.MaxAsync``1(System.Linq.IQueryable{``0})"> MaxAsync<TSource>(IQueryable<TSource>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.cs/#L446"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the maximum value of a sequence.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<TSource> MaxAsync<TSource>(this IQueryable<TSource> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><TSource></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the maximum value in the sequence.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_MaxAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.MaxAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_MaxAsync__2_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0___1___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.MaxAsync``2(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,``1}})"> MaxAsync<TSource, TResult>(IQueryable<TSource>, Expression<Func<TSource, TResult>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.cs/#L468"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the maximum value of a sequence.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<TResult> MaxAsync<TSource, TResult>(this IQueryable<TSource> queryable, Expression<Func<TSource, TResult>> selector)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>selector</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, TResult>></dt> <dd><p>A projection function to apply to each element.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><TResult></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the maximum value in the sequence.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> <dt><code>TResult</code></dt> <dd><p>The type of the value returned by the function represented by <code class="paramref">selector</code>.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_MinAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.MinAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_MinAsync__1_System_Linq_IQueryable___0__" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.MinAsync``1(System.Linq.IQueryable{``0})"> MinAsync<TSource>(IQueryable<TSource>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.cs/#L400"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the minimum value of a sequence.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<TSource> MinAsync<TSource>(this IQueryable<TSource> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><TSource></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the minimum value in the sequence.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_MinAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.MinAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_MinAsync__2_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0___1___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.MinAsync``2(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,``1}})"> MinAsync<TSource, TResult>(IQueryable<TSource>, Expression<Func<TSource, TResult>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.cs/#L424"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the minimum value of a sequence.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<TResult> MinAsync<TSource, TResult>(this IQueryable<TSource> queryable, Expression<Func<TSource, TResult>> selector)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>selector</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, TResult>></dt> <dd><p>A projection function to apply to each element.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><TResult></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the minimum value in the sequence.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> <dt><code>TResult</code></dt> <dd><p>The type of the value returned by the function represented by <code class="paramref">selector</code>.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_SingleAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SingleAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_SingleAsync__1_System_Linq_IQueryable___0__" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SingleAsync``1(System.Linq.IQueryable{``0})"> SingleAsync<TSource>(IQueryable<TSource>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.cs/#L312"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the only element of a sequence, and throws an exception if there is not exactly one element in the sequence.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<TSource> SingleAsync<TSource>(this IQueryable<TSource> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><TSource></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the single element of the input sequence.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_SingleAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SingleAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_SingleAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Boolean___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SingleAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Boolean}})"> SingleAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.cs/#L333"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the only element of a sequence, and throws an exception if there is not exactly one element in the sequence.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<TSource> SingleAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, bool>> predicate)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>predicate</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a>>></dt> <dd><p>Predicate.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><TSource></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the single element of the input sequence.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_SingleOrDefaultAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SingleOrDefaultAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_SingleOrDefaultAsync__1_System_Linq_IQueryable___0__" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SingleOrDefaultAsync``1(System.Linq.IQueryable{``0})"> SingleOrDefaultAsync<TSource>(IQueryable<TSource>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.cs/#L355"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>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.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<TSource?> SingleOrDefaultAsync<TSource>(this IQueryable<TSource> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><TSource></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the single element of the input sequence, or <a href="https://learn.microsoft.com/dotnet/csharp/language-reference/keywords/default">default</a> (<code class="typeparamref">TSource</code>) if the sequence contains no elements.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_SingleOrDefaultAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SingleOrDefaultAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_SingleOrDefaultAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Boolean___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SingleOrDefaultAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Boolean}})"> SingleOrDefaultAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.cs/#L378"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>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.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<TSource?> SingleOrDefaultAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, bool>> predicate)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>predicate</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a>>></dt> <dd><p>Predicate.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><TSource></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the single element of the input sequence, or <a href="https://learn.microsoft.com/dotnet/csharp/language-reference/keywords/default">default</a> (<code class="typeparamref">TSource</code>) if the sequence contains no elements.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_System_Linq_IQueryable_System_Decimal__" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync(System.Linq.IQueryable{System.Decimal})"> SumAsync(IQueryable<decimal>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Sum.cs/#L380"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the sum of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<decimal> SumAsync(this IQueryable<decimal> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.decimal">decimal</a>></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.decimal">decimal</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the sum of a sequence of values.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_System_Linq_IQueryable_System_Double__" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync(System.Linq.IQueryable{System.Double})"> SumAsync(IQueryable<double>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Sum.cs/#L296"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the sum of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<double> SumAsync(this IQueryable<double> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a>></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the sum of a sequence of values.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_System_Linq_IQueryable_System_Int32__" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync(System.Linq.IQueryable{System.Int32})"> SumAsync(IQueryable<int>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Sum.cs/#L44"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the sum of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<int> SumAsync(this IQueryable<int> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a>></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the sum of a sequence of values.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_System_Linq_IQueryable_System_Int64__" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync(System.Linq.IQueryable{System.Int64})"> SumAsync(IQueryable<long>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Sum.cs/#L128"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the sum of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<long> SumAsync(this IQueryable<long> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int64">long</a>></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int64">long</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the sum of a sequence of values.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_System_Linq_IQueryable_System_Nullable_System_Decimal___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync(System.Linq.IQueryable{System.Nullable{System.Decimal}})"> SumAsync(IQueryable<decimal?>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Sum.cs/#L422"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the sum of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<decimal?> SumAsync(this IQueryable<decimal?> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.decimal">decimal</a>?></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.decimal">decimal</a>?></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the sum of a sequence of values.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_System_Linq_IQueryable_System_Nullable_System_Double___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync(System.Linq.IQueryable{System.Nullable{System.Double}})"> SumAsync(IQueryable<double?>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Sum.cs/#L338"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the sum of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<double?> SumAsync(this IQueryable<double?> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a>?></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a>?></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the sum of a sequence of values.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_System_Linq_IQueryable_System_Nullable_System_Int32___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync(System.Linq.IQueryable{System.Nullable{System.Int32}})"> SumAsync(IQueryable<int?>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Sum.cs/#L86"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the sum of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<int?> SumAsync(this IQueryable<int?> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a>?></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a>?></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the sum of a sequence of values.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_System_Linq_IQueryable_System_Nullable_System_Int64___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync(System.Linq.IQueryable{System.Nullable{System.Int64}})"> SumAsync(IQueryable<long?>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Sum.cs/#L170"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the sum of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<long?> SumAsync(this IQueryable<long?> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int64">long</a>?></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int64">long</a>?></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the sum of a sequence of values.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_System_Linq_IQueryable_System_Nullable_System_Single___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync(System.Linq.IQueryable{System.Nullable{System.Single}})"> SumAsync(IQueryable<float?>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Sum.cs/#L254"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the sum of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<float?> SumAsync(this IQueryable<float?> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.single">float</a>?></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.single">float</a>?></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the sum of a sequence of values.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_System_Linq_IQueryable_System_Single__" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync(System.Linq.IQueryable{System.Single})"> SumAsync(IQueryable<float>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Sum.cs/#L212"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the sum of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<float> SumAsync(this IQueryable<float> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.single">float</a>></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.single">float</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the sum of a sequence of values.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Decimal___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Decimal}})"> SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, decimal>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Sum.cs/#L401"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the sum of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<decimal> SumAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, decimal>> selector)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>selector</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.decimal">decimal</a>>></dt> <dd><p>A projection function to apply to each element.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.decimal">decimal</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the sum of a sequence of values.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Double___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Double}})"> SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, double>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Sum.cs/#L317"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the sum of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<double> SumAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, double>> selector)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>selector</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a>>></dt> <dd><p>A projection function to apply to each element.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the sum of a sequence of values.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Int32___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Int32}})"> SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, int>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Sum.cs/#L65"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the sum of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<int> SumAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, int>> selector)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>selector</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a>>></dt> <dd><p>A projection function to apply to each element.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the sum of a sequence of values.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Int64___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Int64}})"> SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, long>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Sum.cs/#L149"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the sum of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<long> SumAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, long>> selector)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>selector</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int64">long</a>>></dt> <dd><p>A projection function to apply to each element.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int64">long</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the sum of a sequence of values.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Nullable_System_Decimal____" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Nullable{System.Decimal}}})"> SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, decimal?>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Sum.cs/#L443"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the sum of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<decimal?> SumAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, decimal?>> selector)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>selector</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.decimal">decimal</a>?>></dt> <dd><p>A projection function to apply to each element.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.decimal">decimal</a>?></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the sum of a sequence of values.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Nullable_System_Double____" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Nullable{System.Double}}})"> SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, double?>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Sum.cs/#L359"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the sum of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<double?> SumAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, double?>> selector)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>selector</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a>?>></dt> <dd><p>A projection function to apply to each element.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a>?></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the sum of a sequence of values.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Nullable_System_Int32____" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Nullable{System.Int32}}})"> SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, int?>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Sum.cs/#L107"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the sum of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<int?> SumAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, int?>> selector)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>selector</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a>?>></dt> <dd><p>A projection function to apply to each element.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a>?></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the sum of a sequence of values.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Nullable_System_Int64____" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Nullable{System.Int64}}})"> SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, long?>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Sum.cs/#L191"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the sum of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<long?> SumAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, long?>> selector)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>selector</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int64">long</a>?>></dt> <dd><p>A projection function to apply to each element.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int64">long</a>?></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the sum of a sequence of values.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Nullable_System_Single____" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Nullable{System.Single}}})"> SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, float?>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Sum.cs/#L275"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the sum of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<float?> SumAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, float?>> selector)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>selector</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.single">float</a>?>></dt> <dd><p>A projection function to apply to each element.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.single">float</a>?></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the sum of a sequence of values.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_SumAsync__1_System_Linq_IQueryable___0__System_Linq_Expressions_Expression_System_Func___0_System_Single___" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.SumAsync``1(System.Linq.IQueryable{``0},System.Linq.Expressions.Expression{System.Func{``0,System.Single}})"> SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, float>>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Sum.cs/#L233"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Returns the sum of a sequence of values.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<float> SumAsync<TSource>(this IQueryable<TSource> queryable, Expression<Func<TSource, float>> selector)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>selector</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.expressions.expression-1">Expression</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.single">float</a>>></dt> <dd><p>A projection function to apply to each element.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.single">float</a>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains the sum of a sequence of values.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_ToDictionaryAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.ToDictionaryAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_ToDictionaryAsync__3_System_Linq_IQueryable___0__System_Func___0___1__System_Func___0___2__System_Collections_Generic_IEqualityComparer___1__" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.ToDictionaryAsync``3(System.Linq.IQueryable{``0},System.Func{``0,``1},System.Func{``0,``2},System.Collections.Generic.IEqualityComparer{``1})"> ToDictionaryAsync<TSource, TK, TV>(IQueryable<TSource>, Func<TSource, TK>, Func<TSource, TV>, IEqualityComparer<TK>?) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.cs/#L514"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Creates a <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.collections.generic.dictionary-2">Dictionary<TKey, TValue></a> from an <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable<T></a> by enumerating it asynchronously.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">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</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> <dt><code>keySelector</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, TK></dt> <dd><p>Key selector.</p> </dd> <dt><code>valSelector</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.func-2">Func</a><TSource, TV></dt> <dd><p>Value selector.</p> </dd> <dt><code>comparer</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.collections.generic.iequalitycomparer-1">IEqualityComparer</a><TK></dt> <dd><p>Optional comparer.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.collections.generic.dictionary-2">Dictionary</a><TK, TV>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains a <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.collections.generic.dictionary-2">Dictionary<TKey, TValue></a> that contains elements from the input sequence.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> <dt><code>TK</code></dt> <dd><p>Dictionary key type.</p> </dd> <dt><code>TV</code></dt> <dd><p>Dictionary value type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_ToListAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.ToListAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_ToListAsync__1_System_Linq_IQueryable___0__" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.ToListAsync``1(System.Linq.IQueryable{``0})"> ToListAsync<TSource>(IQueryable<TSource>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.cs/#L490"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Creates a <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.collections.generic.list-1">List<T></a> from an <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable<T></a> by enumerating it asynchronously.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<List<TSource>> ToListAsync<TSource>(this IQueryable<TSource> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><TSource></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="https://learn.microsoft.com/dotnet/api/system.collections.generic.list-1">List</a><TSource>></dt> <dd><p>A <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task">Task</a> representing the asynchronous operation. The task result contains a <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.collections.generic.list-1">List<T></a> that contains elements from the input sequence.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>TSource</code></dt> <dd><p>Element type.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_ToQueryString_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.ToQueryString*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_ToQueryString_System_Linq_IQueryable_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.ToQueryString(System.Linq.IQueryable)"> ToQueryString(IQueryable) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.cs/#L534"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Generates SQL representation of the specified query.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static string ToQueryString(this IQueryable queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable">IQueryable</a></dt> <dd><p>Query.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a></dt> <dd><p>SQL string.</p> </dd> </dl> <a id="Apache_Ignite_Sql_IgniteQueryableExtensions_ToResultSetAsync_" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.ToResultSetAsync*"></a> <h3 id="Apache_Ignite_Sql_IgniteQueryableExtensions_ToResultSetAsync__1_System_Linq_IQueryable___0__" data-uid="Apache.Ignite.Sql.IgniteQueryableExtensions.ToResultSetAsync``1(System.Linq.IQueryable{``0})"> ToResultSetAsync<T>(IQueryable<T>) <a class="header-action link-secondary" title="View source" href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.cs/#L46"><i class="bi bi-code-slash"></i></a> </h3> <div class="markdown level1 summary"><p>Executes the Ignite query represented by the provided <code class="paramref">queryable</code> and returns the resulting <a class="xref" href="Apache.Ignite.Sql.IResultSet-1.html">IResultSet<T></a>.</p> </div> <div class="markdown level1 conceptual"></div> <div class="codewrapper"> <pre><code class="lang-csharp hljs">public static Task<IResultSet<T>> ToResultSetAsync<T>(this IQueryable<T> queryable)</code></pre> </div> <h4 class="section">Parameters</h4> <dl class="parameters"> <dt><code>queryable</code> <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.linq.iqueryable-1">IQueryable</a><T></dt> <dd><p>Queryable.</p> </dd> </dl> <h4 class="section">Returns</h4> <dl class="parameters"> <dt><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.threading.tasks.task-1">Task</a><<a class="xref" href="Apache.Ignite.Sql.IResultSet-1.html">IResultSet</a><T>></dt> <dd><p>Result set.</p> </dd> </dl> <h4 class="section">Type Parameters</h4> <dl class="parameters"> <dt><code>T</code></dt> <dd><p>Result type.</p> </dd> </dl> </article> <div class="contribution d-print-none"> <a href="https://github.com/apache/ignite-3/blob/ignite-19328/modules/platforms/dotnet/Apache.Ignite/Sql/IgniteQueryableExtensions.Sum.cs/#L35" class="edit-link">Edit this page</a> </div> </div> <div class="affix"> <nav id="affix"></nav> </div> </main> <div class="container-xxl search-results" id="search-results"></div> <footer class="border-top"> <div class="container-xxl"> <div class="flex-fill"> Copyright 2024 The Apache Software Foundation </div> </div> </footer> </body> </html>

releases/3.0.0-beta1/dotnetdoc/api/Apache.Ignite.Sql.IgniteQueryableExtensions.html (2,150 lines of code) (raw):