public bool Execute(string sql, params object[] args)
{
IDatabaseBackend db = Database.Backend;
try {
using (IDbCommand cmd = db.CreateCommand(sql, conn)) {
cmd.Transaction = transaction;
db.FillParams(cmd, args);
cmd.ExecuteNonQuery();
return(true);
}
} catch (Exception ex) {
Logger.LogError("Error executing SQL transaction: " + sql, ex);
return(false);
}
}
public bool Execute(string sql, params object[] args)
{
IDatabaseBackend db = Database.Backend;
try {
using (IDbCommand cmd = db.CreateCommand(sql, conn)) {
cmd.Transaction = transaction;
SqlQuery.FillParams(cmd, args);
cmd.ExecuteNonQuery();
return(true);
}
} catch (Exception e) {
System.IO.File.AppendAllText("MySQL_error.log", DateTime.Now + " " + sql + "\r\n");
Logger.LogError(e);
return(false);
}
}
/// <summary> Executes an SQL command that does not return any results. </summary>
public static void Execute(string sql, object[] parameters, bool createDB)
{
IDatabaseBackend db = Database.Backend;
using (IDbConnection conn = db.CreateConnection()) {
conn.Open();
if (!createDB && db.MultipleSchema)
{
conn.ChangeDatabase(Server.Config.MySQLDatabaseName);
}
using (IDbCommand cmd = db.CreateCommand(sql, conn)) {
FillParams(cmd, parameters);
cmd.ExecuteNonQuery();
}
conn.Close();
}
}
/// <summary> Excecutes an SQL query, invoking a callback on the returned rows one by one. </summary>
public static object Iterate(string sql, object[] parameters, object arg, ReaderCallback callback)
{
IDatabaseBackend db = Database.Backend;
using (IDbConnection conn = db.CreateConnection()) {
conn.Open();
if (db.MultipleSchema)
{
conn.ChangeDatabase(Server.Config.MySQLDatabaseName);
}
using (IDbCommand cmd = db.CreateCommand(sql, conn)) {
FillParams(cmd, parameters);
using (IDataReader reader = cmd.ExecuteReader()) {
while (reader.Read())
{
arg = callback(reader, arg);
}
}
}
conn.Close();
}
return(arg);
}