public static async Task <int> EFExecuteNonQueryAsync(this MySqlConnection connection, string command, params object[] parameters)
{
using (var cmd = EntityCommandBuilder.BuildCommand(connection, command, parameters))
{
return(await cmd.ExecuteNonQueryAsync());
}
}
/// <summary>
/// Checks the servers Information Schema to seee if a database table exists.
/// </summary>
/// <param name="Table">The table name</param>
/// <returns></returns>
public bool TableExists(string Table)
{
if (ReuseSingleConnection)
{
lock (ActiveConnection)
{
using (MySqlCommand Command = EntityCommandBuilder.BuildCommand(ActiveConnection,
"SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = @0 AND TABLE_NAME = @1;", Database, Table))
using (MySqlDataReader Reader = Command.ExecuteReader())
{
return(Reader.HasRows);
}
}
}
else
{
using (MySqlConnection Connection = GetConnection(autoOpen: true, forceNew: true))
{
using (MySqlCommand Command = EntityCommandBuilder.BuildCommand(Connection,
"SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = @0 AND TABLE_NAME = @1;", Database, Table))
using (MySqlDataReader Reader = Command.ExecuteReader())
{
return(Reader.HasRows);
}
}
}
}
public static int EFExecuteNonQuery(this MySqlConnection connection, string command, params object[] parameters)
{
using (var cmd = EntityCommandBuilder.BuildCommand(connection, command, parameters))
{
return(cmd.ExecuteNonQuery());
}
}
public async Task DeleteTableAsync(string Table)
{
using (MySqlConnection Connection = GetConnection(autoOpen: false, forceNew: true))
{
await Connection.OpenAsync();
using (MySqlCommand Command = EntityCommandBuilder.BuildCommand(Connection, "DROP TABLE @0", Table))
{
await Command.ExecuteNonQueryAsync();
}
await Connection.CloseAsync();
}
}
public void DeleteTable(string Table)
{
if (ReuseSingleConnection)
{
lock (ActiveConnection)
{
using (MySqlCommand Command = EntityCommandBuilder.BuildCommand(ActiveConnection, $"DROP TABLE `{Table.Replace("`", "``")}`"))
{
Command.ExecuteNonQuery();
}
}
}
else
{
using (MySqlConnection Connection = GetConnection(autoOpen: true, forceNew: true))
{
using (MySqlCommand Command = EntityCommandBuilder.BuildCommand(Connection, $"DROP TABLE `{Table.Replace("`", "``")}`"))
{
Command.ExecuteNonQuery();
}
}
}
}
