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