如何在C#中使用IDictionary和mysql创建关联数组？

IDictionary<string, string> myArray = new Dictionary<string, string>();

string connectionString = "server=your_server;user=your_username;password=your_password;database=your_database;";
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
    connection.Open();
    string query = "SELECT key_column, value_column FROM your_table;";
    MySqlCommand command = new MySqlCommand(query, connection);
    using (MySqlDataReader reader = command.ExecuteReader())
    {
        while (reader.Read())
        {
            string key = reader.GetString("key_column");
            string value = reader.GetString("value_column");
            myArray.Add(key, value);
        }
    }
}

string value = myArray["key"];