public List <string> GetTableNames(string db, string connectionString)
{
var sql = string.Format(@"SELECT table_name FROM information_schema.tables WHERE table_schema='{0}'", db);
return(MysqlManager <string> .ExecuteReader(sql, null));
}
public List <dynamic> GetColumnsNames(string dbName, string table, string connectionString)
{
var sql = string.Format(@"SELECT COLUMN_NAME,DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = '{0}' AND TABLE_NAME = '{1}';", dbName, table);
return(MysqlManager <dynamic> .ExecuteDynamic(sql, null));
}
public List <dynamic> GetAllDbName()
{
var sql = "SELECT name from sys.databases";
return(MysqlManager <dynamic> .ExecuteDynamic(sql, null));
}