public TResult Execute(string query = null, IDictionary <string, object> parameters = null, bool debug = false)
{
if (string.IsNullOrEmpty(query))
{
this.query = query;
this.parameters = parameters;
this.debug = debug;
}
TResult result = default(TResult);
Stopwatch stopwatch = new Stopwatch();
try
{
stopwatch.Start();
using (var connection = new MySqlConnection(ConnectionString))
{
connection.Open();
var ConnectionTime = stopwatch.ElapsedMilliseconds;
stopwatch.Restart();
using (var command = CreateCommand(query, parameters, connection))
{
var QueryTime = stopwatch.ElapsedMilliseconds;
stopwatch.Restart();
result = Reader(command);
stopwatch.Stop();
if (debug)
{
Debug.WriteLine(string.Format("[{0}] [C: {1}ms, Q: {2}ms, R: {3}ms] {4}", "MySQL", ConnectionTime, QueryTime, stopwatch.ElapsedMilliseconds, QueryToString(query, parameters)));
}
}
}
}
catch (AggregateException aggregateException)
{
var firstException = aggregateException.InnerExceptions.First();
if (!(firstException is MySqlException))
{
throw;
}
Debug.Write(string.Format("[ERROR] [{0}] An error happens on MySQL for query \"{1}\": {2}\n", "MySQL", QueryToString(query, parameters), firstException.Message));
}
catch (MySqlException mysqlException)
{
Debug.Write(string.Format("[ERROR] [{0}] An error happens on MySQL for query \"{1}\": {2}\n", "MySQL", QueryToString(query, parameters), mysqlException.Message));
}
catch (Exception exception)
{
Debug.Write(string.Format("[ERROR] [{0}] An critical error happens on MySQL for query \"{1}\": {2} {3}\n", "MySQL", QueryToString(query, parameters), exception.Message, exception.StackTrace));
}
return(result);
}
public async void ExecuteAsync(string query, IDictionary <string, object> parameters, CallbackDelegate callback, bool debug = false)
{
TResult result = default(TResult);
Stopwatch stopwatch = new Stopwatch();
try
{
stopwatch.Start();
using (var connection = new MySqlConnection(ConnectionString))
{
await connection.OpenAsync();
var ConnectionTime = stopwatch.ElapsedMilliseconds;
stopwatch.Restart();
using (var command = CreateCommand(query, parameters, connection))
{
var QueryTime = stopwatch.ElapsedMilliseconds;
stopwatch.Restart();
result = await ReaderAsync(command);
stopwatch.Stop();
if (debug)
{
Debug.WriteLine(string.Format("[{0}] [C: {1}ms, Q: {2}ms, R: {3}ms] {4}", "MySQL", ConnectionTime, QueryTime, stopwatch.ElapsedMilliseconds, QueryToString(query, parameters)));
}
callback.Invoke(result);
}
}
}
catch (AggregateException aggregateException)
{
var firstException = aggregateException.InnerExceptions.First();
if (!(firstException is MySqlException))
{
throw aggregateException;
}
Debug.Write(string.Format("[ERROR] [{0}] An error happens on MySQL for query \"{1}\": {2}\n", "MySQL", QueryToString(query, parameters), firstException.Message));
}
catch (MySqlException mysqlException)
{
Debug.Write(string.Format("[ERROR] [{0}] An error happens on MySQL for query \"{1}\": {2}\n", "MySQL", QueryToString(query, parameters), mysqlException.Message));
}
catch (ArgumentNullException)
{
Debug.Write(string.Format("[ERROR] [{0}] Check the error above, an error happens when executing the callback from the query : \"{1}\"\n", "MySQL", QueryToString(query, parameters)));
}
catch (Exception exception)
{
Debug.Write(string.Format("[ERROR] [{0}] An critical error happens on MySQL for query \"{1}\": {2} {3}\n", "MySQL", QueryToString(query, parameters), exception.Message, exception.StackTrace));
}
}
public static void Log(string message) => Debug.Write($"{DateTime.Now:s} [CLIENT]: {message}");
public static void Log(string message) => Debug.Write($"{DateTime.Now:s} [SERVER]: {message}{Environment.NewLine}");