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));
}