c# - 循环遍历 MySql reader 中的每个列名称和值？

Question

下面我正在使用 MySqlDataReader，并且想知道如何循环遍历所有列名称和值，并将它们添加到 <string,string> 中。字典中按键和值表示列名和列值？我的代码如下，展示了我如何使用阅读器。

protected bool TryLoadPlayerData(PlayerConnection playerConnection, string sso)
{
    try
    {
        SetPlayer(playerConnection);

        using (var databaseConnection = Hariak.HariakServer.Database.NewDatabaseConnection)
        {
            databaseConnection.SetQuery("SELECT * FROM `users` WHERE `auth_ticket` = @sso LIMIT 1;");
            databaseConnection.AppendParameter("sso", sso);


            using (MySqlDataReader reader = databaseConnection.ExecuteReader())
            {
                while (reader.Read())
                {
                    // loop through columns here...
                }
            }
        }

        Logger.Info("Loaded PlayerData for " + SelectColumn("username"));
        return true;
    }
    catch (Exception exception)
    {
        Logger.Error(exception, "Failed to load PlayerData for player.");
        return false;
    }
}

Answer 1

我要做的只是循环遍历所有 FieldCount，这允许您获取每个返回行的索引，然后使用 GetName 和 GetValue 将它们添加到字典中>

protected bool TryLoadPlayerData(PlayerConnection playerConnection, string sso)
{
    try
    {
        SetPlayer(playerConnection);

        using (var databaseConnection = Hariak.HariakServer.Database.NewDatabaseConnection)
        {
            databaseConnection.SetQuery("SELECT * FROM `users` WHERE `auth_ticket` = @sso LIMIT 1;");
            databaseConnection.AppendParameter("sso", sso);


            using (MySqlDataReader reader = databaseConnection.ExecuteReader())
            {
                Dictionary<string, string> dictionary = new Dictionary<string, string>();
                for (int i = 0; i < reader.FieldCount; i++)
                    {
                        dictionary.Add(reader.GetName(i), reader.GetValue(i));
                    }
            }
        }

        Logger.Info("Loaded PlayerData for " + SelectColumn("username"));
        return true;
    }
    catch (Exception exception)
    {
        Logger.Error(exception, "Failed to load PlayerData for player.");
        return false;
    }
}