Momentum .NET

Appearance

Class DbDataSourceExtensions ​

Namespace: Momentum.Extensions.Data
Assembly: Momentum.Extensions.dll

csharp
public static class DbDataSourceExtensions

Inheritance ​

object ← DbDataSourceExtensions

Inherited Members ​

object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()

Methods ​

SpCall<TResult>(DbDataSource, string, IDbParamsProvider, Func<DbConnection, Func<CommandDefinition, Task<TResult>>>, CancellationToken) ​

csharp
public static Task<TResult> SpCall<TResult>(this DbDataSource dataSource, string spName, IDbParamsProvider parameters, Func<DbConnection, Func<CommandDefinition, Task<TResult>>> dbFunction, CancellationToken cancellationToken = default)

Parameters ​

dataSource DbDataSource

spName string

parameters IDbParamsProvider

dbFunction Func<DbConnection, Func<CommandDefinition, Task<TResult>>>

cancellationToken CancellationToken

Returns ​

Task<TResult>

Type Parameters ​

TResult

SpExecute(DbDataSource, string, IDbParamsProvider, CancellationToken) ​

Executes a stored procedure that returns the number of affected rows.

csharp
public static Task<int> SpExecute(this DbDataSource dataSource, string spName, IDbParamsProvider parameters, CancellationToken cancellationToken = default)

Parameters ​

dataSource DbDataSource

The DbDataSource data source.

spName string

The name of the stored procedure.

parameters IDbParamsProvider

Provider for command parameters.

cancellationToken CancellationToken

Cancellation token.

Returns ​

Task<int>

The number of affected rows.

SpQuery<TResult>(DbDataSource, string, IDbParamsProvider, CancellationToken) ​

Query data using a stored procedure that returns a collection of TResult.

csharp
public static Task<IEnumerable<TResult>> SpQuery<TResult>(this DbDataSource dataSource, string spName, IDbParamsProvider parameters, CancellationToken cancellationToken = default)

Parameters ​

dataSource DbDataSource

The DbDataSource data source.

spName string

The name of the stored procedure.

parameters IDbParamsProvider

Provider for sp parameters.

cancellationToken CancellationToken

Cancellation token.

Returns ​

Task<IEnumerable<TResult>>

Collection of TResult

Type Parameters ​

TResult

Momentum .NET