public List <string> AllTableNames() { MySqlConnectionStringBuilder sb = new MySqlConnectionStringBuilder(); sb.Server = ServerIP; sb.SslMode = MySqlSslMode.None; sb.UserID = "root"; sb.Password = GetPassword.Get(); //sb.Database = dbName; List <string> ret = new List <string>(); string query = string.Format("SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' AND TABLE_SCHEMA = '{0}'", RAMDBName); using (MySqlConnection connection = new MySqlConnection(sb.ToString())) { connection.Open(); using (MySqlCommand cmd = new MySqlCommand(query, connection)) { using (MySqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { string id = reader.GetString(0); ret.Add(id); } } } connection.Close(); } return(ret); }
public void Persistence() { MySqlConnectionStringBuilder sb = new MySqlConnectionStringBuilder(); sb.Server = ServerIP; sb.SslMode = MySqlSslMode.None; sb.UserID = "root"; sb.Password = GetPassword.Get(); //sb.Database = dbName; var names = AllTableNames(); using (MySqlConnection connection = new MySqlConnection(sb.ToString())) { connection.Open(); foreach (string name in names) { Persistence(connection, name); Console.WriteLine(name + " Persistence"); } connection.Close(); } }