Class ConnectionQueryExtensions

Namespace

Rinku

Assembly

Rinku.dll

Runs SQL without declaring a QueryCommand first. Calls that use the same SQL string share one command. Use GetOrCreateCommand(string) to configure that command.

public static class ConnectionQueryExtensions

Inheritance

object

ConnectionQueryExtensions

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Fields

CommandCache

The commands used by SQL string extension methods. A caller may also add a command under a custom key.

public static readonly ConcurrentDictionary<string, QueryCommand> CommandCache

Field Value

ConcurrentDictionary<string, QueryCommand>

Methods

Execute(DbConnection, string, out DbCommand, object?, DbTransaction?, int?)

Runs sql and returns the affected-row count, handing back the command in cmd to read output parameters and dispose.

public static int Execute(this DbConnection cnn, string sql, out DbCommand cmd, object? parametersObj = null, DbTransaction? transaction = null, int? timeout = null)

Parameters

cnn DbConnection

sql string

cmd DbCommand

parametersObj object

transaction DbTransaction

timeout int?

Returns

int

Execute(DbConnection, string, object?, DbTransaction?, int?)

Runs sql and returns the affected-row count.

public static int Execute(this DbConnection cnn, string sql, object? parametersObj = null, DbTransaction? transaction = null, int? timeout = null)

Parameters

cnn DbConnection

sql string

parametersObj object

transaction DbTransaction

timeout int?

Returns

int

Execute(IDbConnection, string, out IDbCommand, object?, IDbTransaction?, int?)

Runs sql and returns the affected-row count, handing back the command in cmd to read output parameters and dispose.

public static int Execute(this IDbConnection cnn, string sql, out IDbCommand cmd, object? parametersObj = null, IDbTransaction? transaction = null, int? timeout = null)

Parameters

cnn IDbConnection

sql string

cmd IDbCommand

parametersObj object

transaction IDbTransaction

timeout int?

Returns

int

Execute(IDbConnection, string, object?, IDbTransaction?, int?)

Runs sql and returns the affected-row count.

public static int Execute(this IDbConnection cnn, string sql, object? parametersObj = null, IDbTransaction? transaction = null, int? timeout = null)

Parameters

cnn IDbConnection

sql string

parametersObj object

transaction IDbTransaction

timeout int?

Returns

int

ExecuteAsync(DbConnection, string, out DbCommand, object?, DbTransaction?, int?, CancellationToken)

Asynchronously runs sql and returns the affected-row count, handing back the command in cmd to read output parameters and dispose.

public static Task<int> ExecuteAsync(this DbConnection cnn, string sql, out DbCommand cmd, object? parametersObj = null, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default)

Parameters

cnn DbConnection

sql string

cmd DbCommand

parametersObj object

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

Task<int>

ExecuteAsync(DbConnection, string, object?, DbTransaction?, int?, CancellationToken)

Asynchronously runs sql and returns the affected-row count.

public static Task<int> ExecuteAsync(this DbConnection cnn, string sql, object? parametersObj = null, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default)

Parameters

cnn DbConnection

sql string

parametersObj object

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

Task<int>

ExecuteAsync(IDbConnection, string, out IDbCommand, object?, IDbTransaction?, int?, CancellationToken)

Asynchronously runs sql and returns the affected-row count, handing back the command in cmd to read output parameters and dispose.

public static Task<int> ExecuteAsync(this IDbConnection cnn, string sql, out IDbCommand cmd, object? parametersObj = null, IDbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default)

Parameters

cnn IDbConnection

sql string

cmd IDbCommand

parametersObj object

transaction IDbTransaction

timeout int?

ct CancellationToken

Returns

Task<int>

ExecuteAsync(IDbConnection, string, object?, IDbTransaction?, int?, CancellationToken)

Asynchronously runs sql and returns the affected-row count.

public static Task<int> ExecuteAsync(this IDbConnection cnn, string sql, object? parametersObj = null, IDbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default)

Parameters

cnn IDbConnection

sql string

parametersObj object

transaction IDbTransaction

timeout int?

ct CancellationToken

Returns

Task<int>

ExecuteAsync<TObj>(DbConnection, string, TObj, DbTransaction?, int?, CancellationToken)

Asynchronously runs sql with a statically typed parameter object and returns the affected-row count.

public static Task<int> ExecuteAsync<TObj>(this DbConnection cnn, string sql, TObj parametersObj, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn DbConnection

sql string

parametersObj TObj

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

Task<int>

Type Parameters

TObj

ExecuteAsync<TObj>(DbConnection, string, ref TObj, DbTransaction?, int?, CancellationToken)

Asynchronously runs sql taking the parameter object by reference to avoid a copy, and returns the affected-row count.

public static Task<int> ExecuteAsync<TObj>(this DbConnection cnn, string sql, ref TObj parametersObj, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn DbConnection

sql string

parametersObj TObj

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

Task<int>

Type Parameters

TObj

ExecuteAsync<TObj>(IDbConnection, string, TObj, IDbTransaction?, int?, CancellationToken)

Asynchronously runs sql with a statically typed parameter object and returns the affected-row count.

public static Task<int> ExecuteAsync<TObj>(this IDbConnection cnn, string sql, TObj parametersObj, IDbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn IDbConnection

sql string

parametersObj TObj

transaction IDbTransaction

timeout int?

ct CancellationToken

Returns

Task<int>

Type Parameters

TObj

ExecuteAsync<TObj>(IDbConnection, string, ref TObj, IDbTransaction?, int?, CancellationToken)

Asynchronously runs sql taking the parameter object by reference to avoid a copy, and returns the affected-row count.

public static Task<int> ExecuteAsync<TObj>(this IDbConnection cnn, string sql, ref TObj parametersObj, IDbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn IDbConnection

sql string

parametersObj TObj

transaction IDbTransaction

timeout int?

ct CancellationToken

Returns

Task<int>

Type Parameters

TObj

ExecuteMultiReader(DbConnection, string, out DbCommand, object?, CommandBehavior, DbTransaction?, int?)

Runs sql and returns a MultiReader over its result sets, with the owning command in cmd.

public static MultiReader ExecuteMultiReader(this DbConnection cnn, string sql, out DbCommand cmd, object? parametersObj = null, CommandBehavior behavior = CommandBehavior.Default, DbTransaction? transaction = null, int? timeout = null)

Parameters

cnn DbConnection

sql string

cmd DbCommand

parametersObj object

behavior CommandBehavior

transaction DbTransaction

timeout int?

Returns

MultiReader

ExecuteMultiReader(DbConnection, string, object?, CommandBehavior, DbTransaction?, int?)

Runs sql and returns an owning MultiReader.

public static MultiReader ExecuteMultiReader(this DbConnection cnn, string sql, object? parametersObj = null, CommandBehavior behavior = CommandBehavior.Default, DbTransaction? transaction = null, int? timeout = null)

Parameters

cnn DbConnection

sql string

parametersObj object

behavior CommandBehavior

transaction DbTransaction

timeout int?

Returns

MultiReader

ExecuteMultiReader(IDbConnection, string, out IDbCommand, object?, CommandBehavior, IDbTransaction?, int?)

Runs sql and returns a MultiReader over its result sets, with the owning command in cmd.

public static MultiReader ExecuteMultiReader(this IDbConnection cnn, string sql, out IDbCommand cmd, object? parametersObj = null, CommandBehavior behavior = CommandBehavior.Default, IDbTransaction? transaction = null, int? timeout = null)

Parameters

cnn IDbConnection

sql string

cmd IDbCommand

parametersObj object

behavior CommandBehavior

transaction IDbTransaction

timeout int?

Returns

MultiReader

ExecuteMultiReader(IDbConnection, string, object?, CommandBehavior, IDbTransaction?, int?)

public static MultiReader ExecuteMultiReader(this IDbConnection cnn, string sql, object? parametersObj = null, CommandBehavior behavior = CommandBehavior.Default, IDbTransaction? transaction = null, int? timeout = null)

Parameters

cnn IDbConnection

sql string

parametersObj object

behavior CommandBehavior

transaction IDbTransaction

timeout int?

Returns

MultiReader

ExecuteMultiReaderAsync(DbConnection, string, out DbCommand, object?, CommandBehavior, DbTransaction?, int?, CancellationToken)

Asynchronously runs sql and returns a MultiReader over its result sets, with the owning command in cmd.

public static Task<MultiReader> ExecuteMultiReaderAsync(this DbConnection cnn, string sql, out DbCommand cmd, object? parametersObj = null, CommandBehavior behavior = CommandBehavior.Default, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default)

Parameters

cnn DbConnection

sql string

cmd DbCommand

parametersObj object

behavior CommandBehavior

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

Task<MultiReader>

ExecuteMultiReaderAsync(DbConnection, string, object?, CommandBehavior, DbTransaction?, int?, CancellationToken)

public static Task<MultiReader> ExecuteMultiReaderAsync(this DbConnection cnn, string sql, object? parametersObj = null, CommandBehavior behavior = CommandBehavior.Default, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default)

Parameters

cnn DbConnection

sql string

parametersObj object

behavior CommandBehavior

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

Task<MultiReader>

ExecuteMultiReaderAsync(IDbConnection, string, out IDbCommand, object?, CommandBehavior, IDbTransaction?, int?, CancellationToken)

Asynchronously runs sql and returns a MultiReader over its result sets, with the owning command in cmd.

public static Task<MultiReader> ExecuteMultiReaderAsync(this IDbConnection cnn, string sql, out IDbCommand cmd, object? parametersObj = null, CommandBehavior behavior = CommandBehavior.Default, IDbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default)

Parameters

cnn IDbConnection

sql string

cmd IDbCommand

parametersObj object

behavior CommandBehavior

transaction IDbTransaction

timeout int?

ct CancellationToken

Returns

Task<MultiReader>

ExecuteMultiReaderAsync(IDbConnection, string, object?, CommandBehavior, IDbTransaction?, int?, CancellationToken)

public static Task<MultiReader> ExecuteMultiReaderAsync(this IDbConnection cnn, string sql, object? parametersObj = null, CommandBehavior behavior = CommandBehavior.Default, IDbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default)

Parameters

cnn IDbConnection

sql string

parametersObj object

behavior CommandBehavior

transaction IDbTransaction

timeout int?

ct CancellationToken

Returns

Task<MultiReader>

ExecuteMultiReaderAsync<TObj>(DbConnection, string, out DbCommand, TObj, CommandBehavior, DbTransaction?, int?, CancellationToken)

Asynchronously runs sql with a statically typed parameter object and returns a MultiReader over its result sets, with the owning command in cmd.

public static Task<MultiReader> ExecuteMultiReaderAsync<TObj>(this DbConnection cnn, string sql, out DbCommand cmd, TObj parametersObj, CommandBehavior behavior = CommandBehavior.Default, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn DbConnection

sql string

cmd DbCommand

parametersObj TObj

behavior CommandBehavior

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

Task<MultiReader>

Type Parameters

TObj

ExecuteMultiReaderAsync<TObj>(DbConnection, string, out DbCommand, ref TObj, CommandBehavior, DbTransaction?, int?, CancellationToken)

Asynchronously runs sql taking the parameter object by reference to avoid a copy, and returns a MultiReader over its result sets, with the owning command in cmd.

public static Task<MultiReader> ExecuteMultiReaderAsync<TObj>(this DbConnection cnn, string sql, out DbCommand cmd, ref TObj parametersObj, CommandBehavior behavior = CommandBehavior.Default, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn DbConnection

sql string

cmd DbCommand

parametersObj TObj

behavior CommandBehavior

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

Task<MultiReader>

Type Parameters

TObj

ExecuteMultiReaderAsync<TObj>(DbConnection, string, TObj, CommandBehavior, DbTransaction?, int?, CancellationToken)

public static Task<MultiReader> ExecuteMultiReaderAsync<TObj>(this DbConnection cnn, string sql, TObj parametersObj, CommandBehavior behavior = CommandBehavior.Default, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn DbConnection

sql string

parametersObj TObj

behavior CommandBehavior

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

Task<MultiReader>

Type Parameters

TObj

ExecuteMultiReaderAsync<TObj>(DbConnection, string, ref TObj, CommandBehavior, DbTransaction?, int?, CancellationToken)

public static Task<MultiReader> ExecuteMultiReaderAsync<TObj>(this DbConnection cnn, string sql, ref TObj parametersObj, CommandBehavior behavior = CommandBehavior.Default, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn DbConnection

sql string

parametersObj TObj

behavior CommandBehavior

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

Task<MultiReader>

Type Parameters

TObj

ExecuteMultiReaderAsync<TObj>(IDbConnection, string, out IDbCommand, TObj, CommandBehavior, IDbTransaction?, int?, CancellationToken)

Asynchronously runs sql with a statically typed parameter object and returns a MultiReader over its result sets, with the owning command in cmd.

public static Task<MultiReader> ExecuteMultiReaderAsync<TObj>(this IDbConnection cnn, string sql, out IDbCommand cmd, TObj parametersObj, CommandBehavior behavior = CommandBehavior.Default, IDbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn IDbConnection

sql string

cmd IDbCommand

parametersObj TObj

behavior CommandBehavior

transaction IDbTransaction

timeout int?

ct CancellationToken

Returns

Task<MultiReader>

Type Parameters

TObj

ExecuteMultiReaderAsync<TObj>(IDbConnection, string, out IDbCommand, ref TObj, CommandBehavior, IDbTransaction?, int?, CancellationToken)

Asynchronously runs sql taking the parameter object by reference to avoid a copy, and returns a MultiReader over its result sets, with the owning command in cmd.

public static Task<MultiReader> ExecuteMultiReaderAsync<TObj>(this IDbConnection cnn, string sql, out IDbCommand cmd, ref TObj parametersObj, CommandBehavior behavior = CommandBehavior.Default, IDbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn IDbConnection

sql string

cmd IDbCommand

parametersObj TObj

behavior CommandBehavior

transaction IDbTransaction

timeout int?

ct CancellationToken

Returns

Task<MultiReader>

Type Parameters

TObj

ExecuteMultiReaderAsync<TObj>(IDbConnection, string, TObj, CommandBehavior, IDbTransaction?, int?, CancellationToken)

public static Task<MultiReader> ExecuteMultiReaderAsync<TObj>(this IDbConnection cnn, string sql, TObj parametersObj, CommandBehavior behavior = CommandBehavior.Default, IDbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn IDbConnection

sql string

parametersObj TObj

behavior CommandBehavior

transaction IDbTransaction

timeout int?

ct CancellationToken

Returns

Task<MultiReader>

Type Parameters

TObj

ExecuteMultiReaderAsync<TObj>(IDbConnection, string, ref TObj, CommandBehavior, IDbTransaction?, int?, CancellationToken)

public static Task<MultiReader> ExecuteMultiReaderAsync<TObj>(this IDbConnection cnn, string sql, ref TObj parametersObj, CommandBehavior behavior = CommandBehavior.Default, IDbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn IDbConnection

sql string

parametersObj TObj

behavior CommandBehavior

transaction IDbTransaction

timeout int?

ct CancellationToken

Returns

Task<MultiReader>

Type Parameters

TObj

ExecuteMultiReader<TObj>(DbConnection, string, out DbCommand, TObj, CommandBehavior, DbTransaction?, int?)

Runs sql with a statically typed parameter object and returns a MultiReader over its result sets, with the owning command in cmd.

public static MultiReader ExecuteMultiReader<TObj>(this DbConnection cnn, string sql, out DbCommand cmd, TObj parametersObj, CommandBehavior behavior = CommandBehavior.Default, DbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn DbConnection

sql string

cmd DbCommand

parametersObj TObj

behavior CommandBehavior

transaction DbTransaction

timeout int?

Returns

MultiReader

Type Parameters

TObj

ExecuteMultiReader<TObj>(DbConnection, string, out DbCommand, ref TObj, CommandBehavior, DbTransaction?, int?)

Runs sql taking the parameter object by reference to avoid a copy, and returns a MultiReader over its result sets, with the owning command in cmd.

public static MultiReader ExecuteMultiReader<TObj>(this DbConnection cnn, string sql, out DbCommand cmd, ref TObj parametersObj, CommandBehavior behavior = CommandBehavior.Default, DbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn DbConnection

sql string

cmd DbCommand

parametersObj TObj

behavior CommandBehavior

transaction DbTransaction

timeout int?

Returns

MultiReader

Type Parameters

TObj

ExecuteMultiReader<TObj>(DbConnection, string, TObj, CommandBehavior, DbTransaction?, int?)

public static MultiReader ExecuteMultiReader<TObj>(this DbConnection cnn, string sql, TObj parametersObj, CommandBehavior behavior = CommandBehavior.Default, DbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn DbConnection

sql string

parametersObj TObj

behavior CommandBehavior

transaction DbTransaction

timeout int?

Returns

MultiReader

Type Parameters

TObj

ExecuteMultiReader<TObj>(DbConnection, string, ref TObj, CommandBehavior, DbTransaction?, int?)

public static MultiReader ExecuteMultiReader<TObj>(this DbConnection cnn, string sql, ref TObj parametersObj, CommandBehavior behavior = CommandBehavior.Default, DbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn DbConnection

sql string

parametersObj TObj

behavior CommandBehavior

transaction DbTransaction

timeout int?

Returns

MultiReader

Type Parameters

TObj

ExecuteMultiReader<TObj>(IDbConnection, string, out IDbCommand, TObj, CommandBehavior, IDbTransaction?, int?)

Runs sql with a statically typed parameter object and returns a MultiReader over its result sets, with the owning command in cmd.

public static MultiReader ExecuteMultiReader<TObj>(this IDbConnection cnn, string sql, out IDbCommand cmd, TObj parametersObj, CommandBehavior behavior = CommandBehavior.Default, IDbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn IDbConnection

sql string

cmd IDbCommand

parametersObj TObj

behavior CommandBehavior

transaction IDbTransaction

timeout int?

Returns

MultiReader

Type Parameters

TObj

ExecuteMultiReader<TObj>(IDbConnection, string, out IDbCommand, ref TObj, CommandBehavior, IDbTransaction?, int?)

Runs sql taking the parameter object by reference to avoid a copy, and returns a MultiReader over its result sets, with the owning command in cmd.

public static MultiReader ExecuteMultiReader<TObj>(this IDbConnection cnn, string sql, out IDbCommand cmd, ref TObj parametersObj, CommandBehavior behavior = CommandBehavior.Default, IDbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn IDbConnection

sql string

cmd IDbCommand

parametersObj TObj

behavior CommandBehavior

transaction IDbTransaction

timeout int?

Returns

MultiReader

Type Parameters

TObj

ExecuteMultiReader<TObj>(IDbConnection, string, TObj, CommandBehavior, IDbTransaction?, int?)

public static MultiReader ExecuteMultiReader<TObj>(this IDbConnection cnn, string sql, TObj parametersObj, CommandBehavior behavior = CommandBehavior.Default, IDbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn IDbConnection

sql string

parametersObj TObj

behavior CommandBehavior

transaction IDbTransaction

timeout int?

Returns

MultiReader

Type Parameters

TObj

ExecuteMultiReader<TObj>(IDbConnection, string, ref TObj, CommandBehavior, IDbTransaction?, int?)

public static MultiReader ExecuteMultiReader<TObj>(this IDbConnection cnn, string sql, ref TObj parametersObj, CommandBehavior behavior = CommandBehavior.Default, IDbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn IDbConnection

sql string

parametersObj TObj

behavior CommandBehavior

transaction IDbTransaction

timeout int?

Returns

MultiReader

Type Parameters

TObj

ExecuteReader(DbConnection, string, out DbCommand, object?, CommandBehavior, DbTransaction?, int?)

Runs sql and returns its DbDataReader, with the owning command in cmd.

public static DbDataReader ExecuteReader(this DbConnection cnn, string sql, out DbCommand cmd, object? parametersObj = null, CommandBehavior behavior = CommandBehavior.Default, DbTransaction? transaction = null, int? timeout = null)

Parameters

cnn DbConnection

sql string

cmd DbCommand

parametersObj object

behavior CommandBehavior

transaction DbTransaction

timeout int?

Returns

DbDataReader

ExecuteReader(IDbConnection, string, out IDbCommand, object?, CommandBehavior, IDbTransaction?, int?)

Runs sql and returns its DbDataReader, with the owning command in cmd.

public static DbDataReader ExecuteReader(this IDbConnection cnn, string sql, out IDbCommand cmd, object? parametersObj = null, CommandBehavior behavior = CommandBehavior.Default, IDbTransaction? transaction = null, int? timeout = null)

Parameters

cnn IDbConnection

sql string

cmd IDbCommand

parametersObj object

behavior CommandBehavior

transaction IDbTransaction

timeout int?

Returns

DbDataReader

ExecuteReaderAsync(DbConnection, string, out DbCommand, object?, CommandBehavior, DbTransaction?, int?, CancellationToken)

Asynchronously runs sql and returns its DbDataReader, with the owning command in cmd.

public static Task<DbDataReader> ExecuteReaderAsync(this DbConnection cnn, string sql, out DbCommand cmd, object? parametersObj = null, CommandBehavior behavior = CommandBehavior.Default, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default)

Parameters

cnn DbConnection

sql string

cmd DbCommand

parametersObj object

behavior CommandBehavior

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

Task<DbDataReader>

ExecuteReaderAsync(IDbConnection, string, out IDbCommand, object?, CommandBehavior, IDbTransaction?, int?, CancellationToken)

Asynchronously runs sql and returns its DbDataReader, with the owning command in cmd.

public static Task<DbDataReader> ExecuteReaderAsync(this IDbConnection cnn, string sql, out IDbCommand cmd, object? parametersObj = null, CommandBehavior behavior = CommandBehavior.Default, IDbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default)

Parameters

cnn IDbConnection

sql string

cmd IDbCommand

parametersObj object

behavior CommandBehavior

transaction IDbTransaction

timeout int?

ct CancellationToken

Returns

Task<DbDataReader>

ExecuteReaderAsync<TObj>(DbConnection, string, out DbCommand, TObj, CommandBehavior, DbTransaction?, int?, CancellationToken)

Asynchronously runs sql with a statically typed parameter object and returns its DbDataReader, with the owning command in cmd.

public static Task<DbDataReader> ExecuteReaderAsync<TObj>(this DbConnection cnn, string sql, out DbCommand cmd, TObj parametersObj, CommandBehavior behavior = CommandBehavior.Default, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn DbConnection

sql string

cmd DbCommand

parametersObj TObj

behavior CommandBehavior

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

Task<DbDataReader>

Type Parameters

TObj

ExecuteReaderAsync<TObj>(DbConnection, string, out DbCommand, ref TObj, CommandBehavior, DbTransaction?, int?, CancellationToken)

Asynchronously runs sql taking the parameter object by reference to avoid a copy, and returns its DbDataReader, with the owning command in cmd.

public static Task<DbDataReader> ExecuteReaderAsync<TObj>(this DbConnection cnn, string sql, out DbCommand cmd, ref TObj parametersObj, CommandBehavior behavior = CommandBehavior.Default, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn DbConnection

sql string

cmd DbCommand

parametersObj TObj

behavior CommandBehavior

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

Task<DbDataReader>

Type Parameters

TObj

ExecuteReaderAsync<TObj>(IDbConnection, string, out IDbCommand, TObj, CommandBehavior, IDbTransaction?, int?, CancellationToken)

Asynchronously runs sql with a statically typed parameter object and returns its DbDataReader, with the owning command in cmd.

public static Task<DbDataReader> ExecuteReaderAsync<TObj>(this IDbConnection cnn, string sql, out IDbCommand cmd, TObj parametersObj, CommandBehavior behavior = CommandBehavior.Default, IDbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn IDbConnection

sql string

cmd IDbCommand

parametersObj TObj

behavior CommandBehavior

transaction IDbTransaction

timeout int?

ct CancellationToken

Returns

Task<DbDataReader>

Type Parameters

TObj

ExecuteReaderAsync<TObj>(IDbConnection, string, out IDbCommand, ref TObj, CommandBehavior, IDbTransaction?, int?, CancellationToken)

Asynchronously runs sql taking the parameter object by reference to avoid a copy, and returns its DbDataReader, with the owning command in cmd.

public static Task<DbDataReader> ExecuteReaderAsync<TObj>(this IDbConnection cnn, string sql, out IDbCommand cmd, ref TObj parametersObj, CommandBehavior behavior = CommandBehavior.Default, IDbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn IDbConnection

sql string

cmd IDbCommand

parametersObj TObj

behavior CommandBehavior

transaction IDbTransaction

timeout int?

ct CancellationToken

Returns

Task<DbDataReader>

Type Parameters

TObj

ExecuteReader<TObj>(DbConnection, string, out DbCommand, TObj, CommandBehavior, DbTransaction?, int?)

Runs sql with a statically typed parameter object and returns its DbDataReader, with the owning command in cmd.

public static DbDataReader ExecuteReader<TObj>(this DbConnection cnn, string sql, out DbCommand cmd, TObj parametersObj, CommandBehavior behavior = CommandBehavior.Default, DbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn DbConnection

sql string

cmd DbCommand

parametersObj TObj

behavior CommandBehavior

transaction DbTransaction

timeout int?

Returns

DbDataReader

Type Parameters

TObj

ExecuteReader<TObj>(DbConnection, string, out DbCommand, ref TObj, CommandBehavior, DbTransaction?, int?)

Runs sql taking the parameter object by reference to avoid a copy, and returns its DbDataReader, with the owning command in cmd.

public static DbDataReader ExecuteReader<TObj>(this DbConnection cnn, string sql, out DbCommand cmd, ref TObj parametersObj, CommandBehavior behavior = CommandBehavior.Default, DbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn DbConnection

sql string

cmd DbCommand

parametersObj TObj

behavior CommandBehavior

transaction DbTransaction

timeout int?

Returns

DbDataReader

Type Parameters

TObj

ExecuteReader<TObj>(IDbConnection, string, out IDbCommand, TObj, CommandBehavior, IDbTransaction?, int?)

Runs sql with a statically typed parameter object and returns its DbDataReader, with the owning command in cmd.

public static DbDataReader ExecuteReader<TObj>(this IDbConnection cnn, string sql, out IDbCommand cmd, TObj parametersObj, CommandBehavior behavior = CommandBehavior.Default, IDbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn IDbConnection

sql string

cmd IDbCommand

parametersObj TObj

behavior CommandBehavior

transaction IDbTransaction

timeout int?

Returns

DbDataReader

Type Parameters

TObj

ExecuteReader<TObj>(IDbConnection, string, out IDbCommand, ref TObj, CommandBehavior, IDbTransaction?, int?)

Runs sql taking the parameter object by reference to avoid a copy, and returns its DbDataReader, with the owning command in cmd.

public static DbDataReader ExecuteReader<TObj>(this IDbConnection cnn, string sql, out IDbCommand cmd, ref TObj parametersObj, CommandBehavior behavior = CommandBehavior.Default, IDbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn IDbConnection

sql string

cmd IDbCommand

parametersObj TObj

behavior CommandBehavior

transaction IDbTransaction

timeout int?

Returns

DbDataReader

Type Parameters

TObj

ExecuteScalarAsync<T>(DbConnection, string, out DbCommand, object?, DbTransaction?, int?, CancellationToken)

Asynchronously runs sql and returns the first column of the first row as T, handing back the command in cmd to read output parameters and dispose.

public static Task<T?> ExecuteScalarAsync<T>(this DbConnection cnn, string sql, out DbCommand cmd, object? parametersObj = null, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default)

Parameters

cnn DbConnection

sql string

cmd DbCommand

parametersObj object

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

Task<T>

Type Parameters

T

ExecuteScalarAsync<T>(DbConnection, string, object?, DbTransaction?, int?, CancellationToken)

Asynchronously runs sql and returns the first column of the first row as T.

public static Task<T?> ExecuteScalarAsync<T>(this DbConnection cnn, string sql, object? parametersObj = null, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default)

Parameters

cnn DbConnection

sql string

parametersObj object

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

Task<T>

Type Parameters

T

ExecuteScalarAsync<T>(IDbConnection, string, out IDbCommand, object?, IDbTransaction?, int?, CancellationToken)

Asynchronously runs sql and returns the first column of the first row as T, handing back the command in cmd to read output parameters and dispose.

public static Task<T?> ExecuteScalarAsync<T>(this IDbConnection cnn, string sql, out IDbCommand cmd, object? parametersObj = null, IDbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default)

Parameters

cnn IDbConnection

sql string

cmd IDbCommand

parametersObj object

transaction IDbTransaction

timeout int?

ct CancellationToken

Returns

Task<T>

Type Parameters

T

ExecuteScalarAsync<T>(IDbConnection, string, object?, IDbTransaction?, int?, CancellationToken)

Asynchronously runs sql and returns the first column of the first row as T.

public static Task<T?> ExecuteScalarAsync<T>(this IDbConnection cnn, string sql, object? parametersObj = null, IDbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default)

Parameters

cnn IDbConnection

sql string

parametersObj object

transaction IDbTransaction

timeout int?

ct CancellationToken

Returns

Task<T>

Type Parameters

T

ExecuteScalarAsync<T, TObj>(DbConnection, string, TObj, DbTransaction?, int?, CancellationToken)

Asynchronously runs sql with a statically typed parameter object and returns the first column of the first row as T.

public static Task<T?> ExecuteScalarAsync<T, TObj>(this DbConnection cnn, string sql, TObj parametersObj, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn DbConnection

sql string

parametersObj TObj

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

Task<T>

Type Parameters

T

TObj

ExecuteScalarAsync<T, TObj>(DbConnection, string, ref TObj, DbTransaction?, int?, CancellationToken)

Asynchronously runs sql taking the parameter object by reference to avoid a copy, and returns the first column of the first row as T.

public static Task<T?> ExecuteScalarAsync<T, TObj>(this DbConnection cnn, string sql, ref TObj parametersObj, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn DbConnection

sql string

parametersObj TObj

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

Task<T>

Type Parameters

T

TObj

ExecuteScalarAsync<T, TObj>(IDbConnection, string, TObj, IDbTransaction?, int?, CancellationToken)

Asynchronously runs sql with a statically typed parameter object and returns the first column of the first row as T.

public static Task<T?> ExecuteScalarAsync<T, TObj>(this IDbConnection cnn, string sql, TObj parametersObj, IDbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn IDbConnection

sql string

parametersObj TObj

transaction IDbTransaction

timeout int?

ct CancellationToken

Returns

Task<T>

Type Parameters

T

TObj

ExecuteScalarAsync<T, TObj>(IDbConnection, string, ref TObj, IDbTransaction?, int?, CancellationToken)

Asynchronously runs sql taking the parameter object by reference to avoid a copy, and returns the first column of the first row as T.

public static Task<T?> ExecuteScalarAsync<T, TObj>(this IDbConnection cnn, string sql, ref TObj parametersObj, IDbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn IDbConnection

sql string

parametersObj TObj

transaction IDbTransaction

timeout int?

ct CancellationToken

Returns

Task<T>

Type Parameters

T

TObj

ExecuteScalar<T>(DbConnection, string, out DbCommand, object?, DbTransaction?, int?)

Runs sql and returns the first column of the first row as T, handing back the command in cmd to read output parameters and dispose.

public static T? ExecuteScalar<T>(this DbConnection cnn, string sql, out DbCommand cmd, object? parametersObj = null, DbTransaction? transaction = null, int? timeout = null)

Parameters

cnn DbConnection

sql string

cmd DbCommand

parametersObj object

transaction DbTransaction

timeout int?

Returns

T

Type Parameters

T

ExecuteScalar<T>(DbConnection, string, object?, DbTransaction?, int?)

Runs sql and returns the first column of the first row as T.

public static T? ExecuteScalar<T>(this DbConnection cnn, string sql, object? parametersObj = null, DbTransaction? transaction = null, int? timeout = null)

Parameters

cnn DbConnection

sql string

parametersObj object

transaction DbTransaction

timeout int?

Returns

T

Type Parameters

T

ExecuteScalar<T>(IDbConnection, string, out IDbCommand, object?, IDbTransaction?, int?)

Runs sql and returns the first column of the first row as T, handing back the command in cmd to read output parameters and dispose.

public static T? ExecuteScalar<T>(this IDbConnection cnn, string sql, out IDbCommand cmd, object? parametersObj = null, IDbTransaction? transaction = null, int? timeout = null)

Parameters

cnn IDbConnection

sql string

cmd IDbCommand

parametersObj object

transaction IDbTransaction

timeout int?

Returns

T

Type Parameters

T

ExecuteScalar<T>(IDbConnection, string, object?, IDbTransaction?, int?)

Runs sql and returns the first column of the first row as T.

public static T? ExecuteScalar<T>(this IDbConnection cnn, string sql, object? parametersObj = null, IDbTransaction? transaction = null, int? timeout = null)

Parameters

cnn IDbConnection

sql string

parametersObj object

transaction IDbTransaction

timeout int?

Returns

T

Type Parameters

T

ExecuteScalar<T, TObj>(DbConnection, string, TObj, DbTransaction?, int?)

Runs sql with a statically typed parameter object and returns the first column of the first row as T.

public static T? ExecuteScalar<T, TObj>(this DbConnection cnn, string sql, TObj parametersObj, DbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn DbConnection

sql string

parametersObj TObj

transaction DbTransaction

timeout int?

Returns

T

Type Parameters

T

TObj

ExecuteScalar<T, TObj>(DbConnection, string, ref TObj, DbTransaction?, int?)

Runs sql taking the parameter object by reference to avoid a copy, and returns the first column of the first row as T.

public static T? ExecuteScalar<T, TObj>(this DbConnection cnn, string sql, ref TObj parametersObj, DbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn DbConnection

sql string

parametersObj TObj

transaction DbTransaction

timeout int?

Returns

T

Type Parameters

T

TObj

ExecuteScalar<T, TObj>(IDbConnection, string, TObj, IDbTransaction?, int?)

Runs sql with a statically typed parameter object and returns the first column of the first row as T.

public static T? ExecuteScalar<T, TObj>(this IDbConnection cnn, string sql, TObj parametersObj, IDbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn IDbConnection

sql string

parametersObj TObj

transaction IDbTransaction

timeout int?

Returns

T

Type Parameters

T

TObj

ExecuteScalar<T, TObj>(IDbConnection, string, ref TObj, IDbTransaction?, int?)

Runs sql taking the parameter object by reference to avoid a copy, and returns the first column of the first row as T.

public static T? ExecuteScalar<T, TObj>(this IDbConnection cnn, string sql, ref TObj parametersObj, IDbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn IDbConnection

sql string

parametersObj TObj

transaction IDbTransaction

timeout int?

Returns

T

Type Parameters

T

TObj

Execute<TObj>(DbConnection, string, TObj, DbTransaction?, int?)

Runs sql with a statically typed parameter object and returns the affected-row count.

public static int Execute<TObj>(this DbConnection cnn, string sql, TObj parametersObj, DbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn DbConnection

sql string

parametersObj TObj

transaction DbTransaction

timeout int?

Returns

int

Type Parameters

TObj

Execute<TObj>(DbConnection, string, ref TObj, DbTransaction?, int?)

Runs sql taking the parameter object by reference to avoid a copy, and returns the affected-row count.

public static int Execute<TObj>(this DbConnection cnn, string sql, ref TObj parametersObj, DbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn DbConnection

sql string

parametersObj TObj

transaction DbTransaction

timeout int?

Returns

int

Type Parameters

TObj

Execute<TObj>(IDbConnection, string, TObj, IDbTransaction?, int?)

Runs sql with a statically typed parameter object and returns the affected-row count.

public static int Execute<TObj>(this IDbConnection cnn, string sql, TObj parametersObj, IDbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn IDbConnection

sql string

parametersObj TObj

transaction IDbTransaction

timeout int?

Returns

int

Type Parameters

TObj

Execute<TObj>(IDbConnection, string, ref TObj, IDbTransaction?, int?)

Runs sql taking the parameter object by reference to avoid a copy, and returns the affected-row count.

public static int Execute<TObj>(this IDbConnection cnn, string sql, ref TObj parametersObj, IDbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn IDbConnection

sql string

parametersObj TObj

transaction IDbTransaction

timeout int?

Returns

int

Type Parameters

TObj

GetOrCreateCommand(string)

Gets the shared QueryCommand for sql. Use the returned command to change parameter settings or cache entries for later SQL string calls.

public static QueryCommand GetOrCreateCommand(string sql)

Parameters

sql string

Returns

QueryCommand

Query(DbConnection, Type, string, out DbCommand, object?, DbTransaction?, int?)

public static object Query(this DbConnection cnn, Type resultType, string sql, out DbCommand cmd, object? parametersObj = null, DbTransaction? transaction = null, int? timeout = null)

Parameters

cnn DbConnection

resultType Type

sql string

cmd DbCommand

parametersObj object

transaction DbTransaction

timeout int?

Returns

object

Query(DbConnection, Type, string, object?, DbTransaction?, int?)

Runs sql and reads the result in the shape selected by resultType.

public static object Query(this DbConnection cnn, Type resultType, string sql, object? parametersObj = null, DbTransaction? transaction = null, int? timeout = null)

Parameters

cnn DbConnection

resultType Type

sql string

parametersObj object

transaction DbTransaction

timeout int?

Returns

object

Query(IDbConnection, Type, string, out IDbCommand, object?, IDbTransaction?, int?)

public static object Query(this IDbConnection cnn, Type resultType, string sql, out IDbCommand cmd, object? parametersObj = null, IDbTransaction? transaction = null, int? timeout = null)

Parameters

cnn IDbConnection

resultType Type

sql string

cmd IDbCommand

parametersObj object

transaction IDbTransaction

timeout int?

Returns

object

Query(IDbConnection, Type, string, object?, IDbTransaction?, int?)

public static object Query(this IDbConnection cnn, Type resultType, string sql, object? parametersObj = null, IDbTransaction? transaction = null, int? timeout = null)

Parameters

cnn IDbConnection

resultType Type

sql string

parametersObj object

transaction IDbTransaction

timeout int?

Returns

object

QueryAsync(DbConnection, Type, string, out DbCommand, object?, DbTransaction?, int?, CancellationToken)

public static Task<object> QueryAsync(this DbConnection cnn, Type resultType, string sql, out DbCommand cmd, object? parametersObj = null, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default)

Parameters

cnn DbConnection

resultType Type

sql string

cmd DbCommand

parametersObj object

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

Task<object>

QueryAsync(DbConnection, Type, string, object?, DbTransaction?, int?, CancellationToken)

public static Task<object> QueryAsync(this DbConnection cnn, Type resultType, string sql, object? parametersObj = null, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default)

Parameters

cnn DbConnection

resultType Type

sql string

parametersObj object

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

Task<object>

QueryAsync(IDbConnection, Type, string, out IDbCommand, object?, IDbTransaction?, int?, CancellationToken)

public static Task<object> QueryAsync(this IDbConnection cnn, Type resultType, string sql, out IDbCommand cmd, object? parametersObj = null, IDbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default)

Parameters

cnn IDbConnection

resultType Type

sql string

cmd IDbCommand

parametersObj object

transaction IDbTransaction

timeout int?

ct CancellationToken

Returns

Task<object>

QueryAsync(IDbConnection, Type, string, object?, IDbTransaction?, int?, CancellationToken)

public static Task<object> QueryAsync(this IDbConnection cnn, Type resultType, string sql, object? parametersObj = null, IDbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default)

Parameters

cnn IDbConnection

resultType Type

sql string

parametersObj object

transaction IDbTransaction

timeout int?

ct CancellationToken

Returns

Task<object>

QueryAsync<T>(DbConnection, string, out DbCommand, object?, DbTransaction?, int?, CancellationToken)

Asynchronously runs sql and reads the result as T, handing back the command in cmd to read output parameters and dispose.

public static Task<T> QueryAsync<T>(this DbConnection cnn, string sql, out DbCommand cmd, object? parametersObj = null, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default)

Parameters

cnn DbConnection

sql string

cmd DbCommand

parametersObj object

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

Task<T>

Type Parameters

T

QueryAsync<T>(DbConnection, string, object?, DbTransaction?, int?, CancellationToken)

Asynchronously runs sql and reads the result as T, in the shape T chooses.

public static Task<T> QueryAsync<T>(this DbConnection cnn, string sql, object? parametersObj = null, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default)

Parameters

cnn DbConnection

sql string

parametersObj object

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

Task<T>

Type Parameters

T

QueryAsync<TObj>(DbConnection, Type, string, TObj, DbTransaction?, int?, CancellationToken)

public static Task<object> QueryAsync<TObj>(this DbConnection cnn, Type resultType, string sql, TObj parametersObj, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn DbConnection

resultType Type

sql string

parametersObj TObj

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

Task<object>

Type Parameters

TObj

QueryAsync<TObj>(DbConnection, Type, string, ref TObj, DbTransaction?, int?, CancellationToken)

public static Task<object> QueryAsync<TObj>(this DbConnection cnn, Type resultType, string sql, ref TObj parametersObj, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn DbConnection

resultType Type

sql string

parametersObj TObj

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

Task<object>

Type Parameters

TObj

QueryAsync<T>(IDbConnection, string, out IDbCommand, object?, IDbTransaction?, int?, CancellationToken)

Asynchronously runs sql and reads the result as T, handing back the command in cmd to read output parameters and dispose.

public static Task<T> QueryAsync<T>(this IDbConnection cnn, string sql, out IDbCommand cmd, object? parametersObj = null, IDbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default)

Parameters

cnn IDbConnection

sql string

cmd IDbCommand

parametersObj object

transaction IDbTransaction

timeout int?

ct CancellationToken

Returns

Task<T>

Type Parameters

T

QueryAsync<T>(IDbConnection, string, object?, IDbTransaction?, int?, CancellationToken)

Asynchronously runs sql and reads the result as T, in the shape T chooses.

public static Task<T> QueryAsync<T>(this IDbConnection cnn, string sql, object? parametersObj = null, IDbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default)

Parameters

cnn IDbConnection

sql string

parametersObj object

transaction IDbTransaction

timeout int?

ct CancellationToken

Returns

Task<T>

Type Parameters

T

QueryAsync<TObj>(IDbConnection, Type, string, TObj, IDbTransaction?, int?, CancellationToken)

public static Task<object> QueryAsync<TObj>(this IDbConnection cnn, Type resultType, string sql, TObj parametersObj, IDbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn IDbConnection

resultType Type

sql string

parametersObj TObj

transaction IDbTransaction

timeout int?

ct CancellationToken

Returns

Task<object>

Type Parameters

TObj

QueryAsync<TObj>(IDbConnection, Type, string, ref TObj, IDbTransaction?, int?, CancellationToken)

public static Task<object> QueryAsync<TObj>(this IDbConnection cnn, Type resultType, string sql, ref TObj parametersObj, IDbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn IDbConnection

resultType Type

sql string

parametersObj TObj

transaction IDbTransaction

timeout int?

ct CancellationToken

Returns

Task<object>

Type Parameters

TObj

QueryAsync<T, TObj>(DbConnection, string, TObj, DbTransaction?, int?, CancellationToken)

Asynchronously runs sql with a statically typed parameter object and reads the result as T, in the shape T chooses.

public static Task<T> QueryAsync<T, TObj>(this DbConnection cnn, string sql, TObj parametersObj, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn DbConnection

sql string

parametersObj TObj

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

Task<T>

Type Parameters

T

TObj

QueryAsync<T, TObj>(DbConnection, string, ref TObj, DbTransaction?, int?, CancellationToken)

Asynchronously runs sql taking the parameter object by reference to avoid a copy, and reads the result as T, in the shape T chooses.

public static Task<T> QueryAsync<T, TObj>(this DbConnection cnn, string sql, ref TObj parametersObj, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn DbConnection

sql string

parametersObj TObj

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

Task<T>

Type Parameters

T

TObj

QueryAsync<T, TObj>(IDbConnection, string, TObj, IDbTransaction?, int?, CancellationToken)

Asynchronously runs sql with a statically typed parameter object and reads the result as T, in the shape T chooses.

public static Task<T> QueryAsync<T, TObj>(this IDbConnection cnn, string sql, TObj parametersObj, IDbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn IDbConnection

sql string

parametersObj TObj

transaction IDbTransaction

timeout int?

ct CancellationToken

Returns

Task<T>

Type Parameters

T

TObj

QueryAsync<T, TObj>(IDbConnection, string, ref TObj, IDbTransaction?, int?, CancellationToken)

Asynchronously runs sql taking the parameter object by reference to avoid a copy, and reads the result as T, in the shape T chooses.

public static Task<T> QueryAsync<T, TObj>(this IDbConnection cnn, string sql, ref TObj parametersObj, IDbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn IDbConnection

sql string

parametersObj TObj

transaction IDbTransaction

timeout int?

ct CancellationToken

Returns

Task<T>

Type Parameters

T

TObj

Query<T>(DbConnection, string, out DbCommand, object?, DbTransaction?, int?)

Runs sql and reads the result as T, handing back the command in cmd to read output parameters and dispose.

public static T Query<T>(this DbConnection cnn, string sql, out DbCommand cmd, object? parametersObj = null, DbTransaction? transaction = null, int? timeout = null)

Parameters

cnn DbConnection

sql string

cmd DbCommand

parametersObj object

transaction DbTransaction

timeout int?

Returns

T

Type Parameters

T

Query<T>(DbConnection, string, object?, DbTransaction?, int?)

Runs sql and reads the result as T, in the shape T chooses.

public static T Query<T>(this DbConnection cnn, string sql, object? parametersObj = null, DbTransaction? transaction = null, int? timeout = null)

Parameters

cnn DbConnection

sql string

parametersObj object

transaction DbTransaction

timeout int?

Returns

T

Type Parameters

T

Query<TObj>(DbConnection, Type, string, TObj, DbTransaction?, int?)

public static object Query<TObj>(this DbConnection cnn, Type resultType, string sql, TObj parametersObj, DbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn DbConnection

resultType Type

sql string

parametersObj TObj

transaction DbTransaction

timeout int?

Returns

object

Type Parameters

TObj

Query<TObj>(DbConnection, Type, string, ref TObj, DbTransaction?, int?)

public static object Query<TObj>(this DbConnection cnn, Type resultType, string sql, ref TObj parametersObj, DbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn DbConnection

resultType Type

sql string

parametersObj TObj

transaction DbTransaction

timeout int?

Returns

object

Type Parameters

TObj

Query<T>(IDbConnection, string, out IDbCommand, object?, IDbTransaction?, int?)

Runs sql and reads the result as T, handing back the command in cmd to read output parameters and dispose.

public static T Query<T>(this IDbConnection cnn, string sql, out IDbCommand cmd, object? parametersObj = null, IDbTransaction? transaction = null, int? timeout = null)

Parameters

cnn IDbConnection

sql string

cmd IDbCommand

parametersObj object

transaction IDbTransaction

timeout int?

Returns

T

Type Parameters

T

Query<T>(IDbConnection, string, object?, IDbTransaction?, int?)

Runs sql and reads the result as T, in the shape T chooses.

public static T Query<T>(this IDbConnection cnn, string sql, object? parametersObj = null, IDbTransaction? transaction = null, int? timeout = null)

Parameters

cnn IDbConnection

sql string

parametersObj object

transaction IDbTransaction

timeout int?

Returns

T

Type Parameters

T

Query<TObj>(IDbConnection, Type, string, TObj, IDbTransaction?, int?)

public static object Query<TObj>(this IDbConnection cnn, Type resultType, string sql, TObj parametersObj, IDbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn IDbConnection

resultType Type

sql string

parametersObj TObj

transaction IDbTransaction

timeout int?

Returns

object

Type Parameters

TObj

Query<TObj>(IDbConnection, Type, string, ref TObj, IDbTransaction?, int?)

public static object Query<TObj>(this IDbConnection cnn, Type resultType, string sql, ref TObj parametersObj, IDbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn IDbConnection

resultType Type

sql string

parametersObj TObj

transaction IDbTransaction

timeout int?

Returns

object

Type Parameters

TObj

Query<T, TObj>(DbConnection, string, TObj, DbTransaction?, int?)

Runs sql with a statically typed parameter object and reads the result as T, in the shape T chooses.

public static T Query<T, TObj>(this DbConnection cnn, string sql, TObj parametersObj, DbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn DbConnection

sql string

parametersObj TObj

transaction DbTransaction

timeout int?

Returns

T

Type Parameters

T

TObj

Query<T, TObj>(DbConnection, string, ref TObj, DbTransaction?, int?)

Runs sql taking the parameter object by reference to avoid a copy, and reads the result as T, in the shape T chooses.

public static T Query<T, TObj>(this DbConnection cnn, string sql, ref TObj parametersObj, DbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn DbConnection

sql string

parametersObj TObj

transaction DbTransaction

timeout int?

Returns

T

Type Parameters

T

TObj

Query<T, TObj>(IDbConnection, string, TObj, IDbTransaction?, int?)

Runs sql with a statically typed parameter object and reads the result as T, in the shape T chooses.

public static T Query<T, TObj>(this IDbConnection cnn, string sql, TObj parametersObj, IDbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn IDbConnection

sql string

parametersObj TObj

transaction IDbTransaction

timeout int?

Returns

T

Type Parameters

T

TObj

Query<T, TObj>(IDbConnection, string, ref TObj, IDbTransaction?, int?)

Runs sql taking the parameter object by reference to avoid a copy, and reads the result as T, in the shape T chooses.

public static T Query<T, TObj>(this IDbConnection cnn, string sql, ref TObj parametersObj, IDbTransaction? transaction = null, int? timeout = null) where TObj : notnull

Parameters

cnn IDbConnection

sql string

parametersObj TObj

transaction IDbTransaction

timeout int?

Returns

T

Type Parameters

T

TObj

StreamQueryAsync<T>(DbConnection, string, out DbCommand, object?, DbTransaction?, int?, CancellationToken)

Runs sql and streams its rows as T, handing back the command in cmd to read output parameters and dispose once enumeration completes.

public static IAsyncEnumerable<T> StreamQueryAsync<T>(this DbConnection cnn, string sql, out DbCommand cmd, object? parametersObj = null, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default)

Parameters

cnn DbConnection

sql string

cmd DbCommand

parametersObj object

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

IAsyncEnumerable<T>

Type Parameters

T

StreamQueryAsync<T>(DbConnection, string, object?, DbTransaction?, int?, CancellationToken)

Runs sql and streams its rows as T, produced one at a time as you enumerate.

public static IAsyncEnumerable<T> StreamQueryAsync<T>(this DbConnection cnn, string sql, object? parametersObj = null, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default)

Parameters

cnn DbConnection

sql string

parametersObj object

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

IAsyncEnumerable<T>

Type Parameters

T

StreamQueryAsync<T, TObj>(DbConnection, string, TObj, DbTransaction?, int?, CancellationToken)

Runs sql with a statically typed parameter object and streams its rows as T, produced one at a time as you enumerate.

public static IAsyncEnumerable<T> StreamQueryAsync<T, TObj>(this DbConnection cnn, string sql, TObj parametersObj, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn DbConnection

sql string

parametersObj TObj

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

IAsyncEnumerable<T>

Type Parameters

T

TObj

StreamQueryAsync<T, TObj>(DbConnection, string, ref TObj, DbTransaction?, int?, CancellationToken)

Runs sql taking the parameter object by reference to avoid a copy, and streams its rows as T, produced one at a time as you enumerate.

public static IAsyncEnumerable<T> StreamQueryAsync<T, TObj>(this DbConnection cnn, string sql, ref TObj parametersObj, DbTransaction? transaction = null, int? timeout = null, CancellationToken ct = default) where TObj : notnull

Parameters

cnn DbConnection

sql string

parametersObj TObj

transaction DbTransaction

timeout int?

ct CancellationToken

Returns

IAsyncEnumerable<T>

Type Parameters

T

TObj