无论如何，要通过Dapper DynamicParameters对象进行迭代吗？ [英] Is there anyway to iterate through a Dapper DynamicParameters object?

问题描述

我需要制作一个通用记录器来记录某些插入/更新语句，以便测试人员可以验证所插入的数据是否正确。

I need to make a generic logger to record certain insert/update statements so that my testers can verify the data being inserted is correct.

我的第一个想法是我只使用一个接受DynamicParameters的函数，然后遍历DynamicParameters来生成一个字符串，以列出参数的名称和值，并使测试人员更容易阅读它们。

My first thought was that I would just use a function that accepted DynamicParameters and I would foreach through the DynamicParameters to generate a string to list the parameter's name and value and make them easier to read for the testers.

不幸的是，Dapper.DynamicParameters不包含 GetEnumerator的公共定义

Unfortunately, Dapper.DynamicParameters does not contain a public definition for "GetEnumerator"

以下是我希望执行的基本示例：

Here is basic example of what I was hoping to do:

string myFormattedListofParameters = "";
foreach (var p in myDynamicParameters)
{
myFormattedListofParameters += p.Name + "=" + p.Value.ToString();
}

推荐答案

尝试：

            var sb = new StringBuilder();
            foreach (var name in p.ParameterNames)
            {
                var pValue = p.Get<dynamic>(name);
                sb.AppendFormat("{0}={1}\n", name, pValue.ToString());
            }

这篇关于无论如何，要通过Dapper DynamicParameters对象进行迭代吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！