public static DataSet ExecuteDataset(string connectionString, string commandText, params MySqlParameter[] commandParameters)
{
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
connection.Open();
return ExecuteDataset(connection, commandText, commandParameters);
}
}
public static int ExecuteNonQuery(string connectionString, string commandText, params MySqlParameter[] parms)
{
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
connection.Open();
return ExecuteNonQuery(connection, commandText, parms);
}
}
public static void UpdateDataSet(string connectionString, string commandText, DataSet ds, string tablename)
{
MySqlConnection connection = new MySqlConnection(connectionString);
connection.Open();
MySqlDataAdapter adapter = new MySqlDataAdapter(commandText, connection);
new MySqlCommandBuilder(adapter).ToString();
adapter.Update(ds, tablename);
connection.Close();
}
public static object ExecuteScalar(string connectionString, string commandText, params MySqlParameter[] commandParameters)
{
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
connection.Open();
return ExecuteScalar(connection, commandText, commandParameters);
}
}
public static MySqlDataReader ExecuteReader(string connectionString, string commandText, params MySqlParameter[] commandParameters)
{
MySqlDataReader reader;
MySqlConnection connection = new MySqlConnection(connectionString);
connection.Open();
try
{
reader = ExecuteReader(connection, null, commandText, commandParameters, false);
}
catch
{
connection.Close();
throw;
}
return reader;
}
public override void Cancel() {
if( !this.connection.driver.Version.isAtLeast( 5, 0, 0 ) ) {
throw new NotSupportedException( Resources.CancelNotSupported );
}
MySqlConnectionStringBuilder builder = new MySqlConnectionStringBuilder( this.connection.Settings.GetConnectionString( true ) );
builder.Pooling = false;
using( MySqlConnection connection = new MySqlConnection( builder.ConnectionString ) ) {
connection.Open();
new MySqlCommand( string.Format( "KILL QUERY {0}", this.connection.ServerThread ), connection ).ExecuteNonQuery();
}
}