public static List <string> GetTableNames(this global::Rebus.MySql.MySqlConnection connection)
{
var tableNames = new List <string>();
using (var command = connection.CreateCommand())
{
command.CommandText = "show tables";
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
tableNames.Add(reader[0].ToString());
}
}
}
return(tableNames);
}
public static List <string> GetTableNames(this global::Rebus.MySql.MySqlConnection connection)
{
var tableNames = new List <string>();
using (var command = connection.CreateCommand())
{
command.CommandText = "select * from information_schema.tables where table_schema not in ('pg_catalog', 'information_schema')";
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
tableNames.Add(reader["table_name"].ToString());
}
}
}
return(tableNames);
}
