如何使用结果映射将dapper结果转换为字典

using Dapper;
using System.Collections.Generic;
using System.Data;
using System.Linq;

public class MyClass
{
    public int Id { get; set; }
    public string Name { get; set; }
    // 其他属性...

    public Dictionary<string, object> ConvertToDictionary()
    {
        var parameters = new DynamicParameters();
        var typeMap = SqlMapper.GetTypeMap(typeof(MyClass));

        foreach (var propertyMap in typeMap.PropertyMaps)
        {
            var value = propertyMap.GetMemberValue(this);
            parameters.Add(propertyMap.PropertyInfo.Name, value);
        }

        return parameters.ParameterNames.ToDictionary(name => name, name => parameters.Get<object>(name));
    }
}

// 使用示例
var query = "SELECT Id, Name FROM MyTable";
IEnumerable<MyClass> results;

using (var connection = new SqlConnection("connectionString"))
{
    connection.Open();
    results = connection.Query<MyClass>(query);
}

foreach (var result in results)
{
    var dictionary = result.ConvertToDictionary();
    // 使用字典对象进行后续操作
}