public T ExecuteScalar <T>(string connection, string sql, object parameters)
{
T result = default;
using (var c = new MySqlData.MySqlConnection(connection))
{
_log.LogTrace <MySqlQuery>($"EXECUTE: {sql}. Parameters: {JsonConvert.SerializeObject(parameters)}");
c.Open();
result = c.ExecuteScalar <T>(sql, parameters);
c.Close();
}
return(result);
}
