public async Task ExecuteAsync(string connection, string sql, object parameters)
{
using (var c = new MySqlData.MySqlConnection(connection))
{
_log.LogTrace <MySqlQuery>($"EXECUTE: {sql}. Parameters: {JsonConvert.SerializeObject(parameters)}");
await c.OpenAsync();
await c.ExecuteAsync(sql, parameters);
await c.CloseAsync();
}
}
public void Execute(Definition definition)
{
var connection = definition.Connection;
if (string.IsNullOrEmpty(connection))
{
connection = _connection;
}
using (var mysql = new MySqlData.MySqlConnection(connection))
{
_log.LogTrace <MySqlQuery>($"EXECUTE: {definition.Sql}. Parameters: {JsonConvert.SerializeObject(definition.Parameters)}");
mysql.Open();
mysql.ExecuteAsync(new CommandDefinition(definition.Sql, definition.Parameters, cancellationToken: definition.Token, commandTimeout: definition.CommandTimeout)).GetAwaiter().GetResult();
mysql.Close();
}
}
