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)); } }