Interface IManualMySqlProvider

Namespace

Uncreated.Warfare.Database.Manual

Assembly

Uncreated.Warfare.dll

Simplified replacement for the old manual SQL provider. Uses connection pooling. Supports moderation API since EFCore 3.1 doesn't support complicated type hierarchies.

public interface IManualMySqlProvider

Methods

NonQueryAsync(string, IReadOnlyList<object?>?, int, int, CancellationToken)

Execute a command against a MySql database.

Task<int> NonQueryAsync(string query, IReadOnlyList<object?>? parameters, int index, int length, CancellationToken token = default)

Parameters

query string

parameters IReadOnlyList<object>

index int

length int

token CancellationToken

Returns

Task<int>

Exceptions

DbException

ArgumentNullException

NonQueryAsync(string, IReadOnlyList<object?>?, CancellationToken)

Execute a command against a MySql database.

Task<int> NonQueryAsync(string query, IReadOnlyList<object?>? parameters, CancellationToken token = default)

Parameters

query string

parameters IReadOnlyList<object>

token CancellationToken

Returns

Task<int>

Exceptions

DbException

ArgumentNullException

QueryAsync(string, IReadOnlyList<object?>?, int, int, CancellationToken, ReadLoopAction)

Query a MySql database and run callback for each returned row.

Task<int> QueryAsync(string query, IReadOnlyList<object?>? parameters, int index, int length, CancellationToken token, ReadLoopAction callback)

Parameters

query string

parameters IReadOnlyList<object>

index int

length int

token CancellationToken

callback ReadLoopAction

Returns

Task<int>

Exceptions

DbException

ArgumentNullException

QueryAsync(string, IReadOnlyList<object?>?, int, int, CancellationToken, ReadLoopWhileAction)

Query a MySql database and run callback for each returned row while it returns true.

Task<int> QueryAsync(string query, IReadOnlyList<object?>? parameters, int index, int length, CancellationToken token, ReadLoopWhileAction callback)

Parameters

query string

parameters IReadOnlyList<object>

index int

length int

token CancellationToken

callback ReadLoopWhileAction

Returns

Task<int>

Exceptions

DbException

ArgumentNullException

QueryAsync(string, IReadOnlyList<object?>?, int, int, ReadLoopAction)

Query a MySql database and run callback for each returned row.

Task<int> QueryAsync(string query, IReadOnlyList<object?>? parameters, int index, int length, ReadLoopAction callback)

Parameters

query string

parameters IReadOnlyList<object>

index int

length int

callback ReadLoopAction

Returns

Task<int>

Exceptions

DbException

ArgumentNullException

QueryAsync(string, IReadOnlyList<object?>?, int, int, ReadLoopWhileAction)

Query a MySql database and run callback for each returned row while it returns true.

Task<int> QueryAsync(string query, IReadOnlyList<object?>? parameters, int index, int length, ReadLoopWhileAction callback)

Parameters

query string

parameters IReadOnlyList<object>

index int

length int

callback ReadLoopWhileAction

Returns

Task<int>

Exceptions

DbException

ArgumentNullException

QueryAsync(string, IReadOnlyList<object?>?, CancellationToken, ReadLoopAction)

Query a MySql database and run callback for each returned row.

Task<int> QueryAsync(string query, IReadOnlyList<object?>? parameters, CancellationToken token, ReadLoopAction callback)

Parameters

query string

parameters IReadOnlyList<object>

token CancellationToken

callback ReadLoopAction

Returns

Task<int>

Exceptions

DbException

ArgumentNullException

QueryAsync(string, IReadOnlyList<object?>?, CancellationToken, ReadLoopWhileAction)

Query a MySql database and run callback for each returned row while it returns true.

Task<int> QueryAsync(string query, IReadOnlyList<object?>? parameters, CancellationToken token, ReadLoopWhileAction callback)

Parameters

query string

parameters IReadOnlyList<object>

token CancellationToken

callback ReadLoopWhileAction

Returns

Task<int>

Exceptions

DbException

ArgumentNullException

QueryAsync(string, IReadOnlyList<object?>?, ReadLoopAction)

Query a MySql database and run callback for each returned row.

Task<int> QueryAsync(string query, IReadOnlyList<object?>? parameters, ReadLoopAction callback)

Parameters

query string

parameters IReadOnlyList<object>

callback ReadLoopAction

Returns

Task<int>

Exceptions

DbException

ArgumentNullException

QueryAsync(string, IReadOnlyList<object?>?, ReadLoopWhileAction)

Query a MySql database and run callback for each returned row while it returns true.

Task<int> QueryAsync(string query, IReadOnlyList<object?>? parameters, ReadLoopWhileAction callback)

Parameters

query string

parameters IReadOnlyList<object>

callback ReadLoopWhileAction

Returns

Task<int>

Exceptions

DbException

ArgumentNullException