Method ScalarAsync

Namespace

Qavren.Edge.Sqlite

Assembly

Qavren.Edge.Sqlite.dll

ScalarAsync<T>(SqliteConnection, string, IEnumerable<SqliteParameter>?, CancellationToken)

Runs sql and returns the first column of the first row, converted to T.

public static Task<T?> ScalarAsync<T>(this SqliteConnection connection, string sql, IEnumerable<SqliteParameter>? parameters = null, CancellationToken cancellationToken = default)

Parameters

connection SqliteConnection

The open connection to run the command on.

sql string

The SQL text to execute.

parameters IEnumerable<SqliteParameter>

Parameters to bind, or null for none.

cancellationToken CancellationToken

Cancels the command.

Returns

Task<T>

The converted scalar value, or default when the result is null or DBNull.

Type Parameters

T

Exceptions

ArgumentNullException

connection is null.

ArgumentException

sql is null, empty, or whitespace.