public bool DirectExecute(PreparedStatement stmt)
{
try
{
using (var Connection = _connectionInfo.GetConnection())
{
Connection.Open();
using (MySqlCommand cmd = Connection.CreateCommand())
{
cmd.CommandText = stmt.CommandText;
foreach (var parameter in stmt.Parameters)
{
cmd.Parameters.AddWithValue("@" + parameter.Key, parameter.Value);
}
cmd.ExecuteNonQuery();
return(true);
}
}
}
catch (MySqlException ex)
{
HandleMySQLException(ex, stmt.CommandText);
return(false);
}
}
public MySqlErrorCode Initialize(MySqlConnectionInfo connectionInfo)
{
_connectionInfo = connectionInfo;
_updater = new DatabaseUpdater <T>(this);
try
{
using (var connection = _connectionInfo.GetConnection())
{
connection.Open();
Log.outInfo(LogFilter.SqlDriver, $"Connected to MySQL(ver: {connection.ServerVersion}) Database: {_connectionInfo.Database}");
return(MySqlErrorCode.None);
}
}
catch (MySqlException ex)
{
return(HandleMySQLException(ex));
}
}