Class ManualMySqlProvider

Namespace

Uncreated.Warfare.Database.Manual

Assembly

Uncreated.Warfare.dll

Simplified replacement for the old manual SQL provider. Uses connection pooling.

public class ManualMySqlProvider : IManualMySqlProvider

Inheritance

object

ManualMySqlProvider

Implements

IManualMySqlProvider

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Constructors

ManualMySqlProvider(string, ILogger<ManualMySqlProvider>)

public ManualMySqlProvider(string connectionString, ILogger<ManualMySqlProvider> logger)

Parameters

connectionString string

logger ILogger<ManualMySqlProvider>

Methods

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

Execute a command against a MySql database.

public 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.

public 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.

public 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.

public 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.

public 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.

public 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.

public 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.

public 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.

public 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.

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

Parameters

query string

parameters IReadOnlyList<object>

callback ReadLoopWhileAction

Returns

Task<int>

Exceptions

DbException

ArgumentNullException