Dapper AddDynamicParams for IN statement with“dynamic”参数名称 [英] Dapper AddDynamicParams for IN statement with "dynamic" parameter name

问题描述

我有这样简单的SQL字符串：

 SELECT * FROM Office WHERE OfficeId IN @Ids
  

事实是@Ids名称是在编辑器中输入的， ，我的问题是，如果我想传入，说一个整数数组，它只适用于Dapper如果我使用：

  var values = new DynamicParameters（）; 
 values.AddDynamicParams（new {Ids = new [] {100，101}}）; 
  

但这需要我知道参数名称是Ids，而不是在我的

我可以在Dapper中设置一个动态参数，具有动态名称，如下所示：

  var values = new DynamicParameters（）; 
 values.Add（Ids，new [] {100，101}）; 
  

但是Dapper不会使用单独的参数构造IN

有没有一种方法来构造传递给AddDynamicParams的动态对象，但是在不知道名称的情况下设置成员名和值？

我可以修改Dapper源来为我的场景工作，但如果任何人知道一个更简单和优雅的解决方案，我会很大！

最好的问候
Jens

解决方案

我刚刚提交了一个修复，的以下内容正常工作：

 <$> 
 c $ c> values.AddDynamicParams（new {ids = list}）; 
  

或以单一名称：

  values.Add（ids，list）; 
  

或作为字典：

  var args = new Dictionary< string，object>（）; 
 args.Add（ids，list）; 
 values.AddDynamicParams（args）; 
  

我还没有部署到NuGet。让我知道这是否是一个问题。

I have simple SQL string like this:

"SELECT * FROM Office WHERE OfficeId IN @Ids"

The thing is that the @Ids name is entered in an editor so it could be whatever, and my problem is that if I want to pass in, say an array of integers, it only works with Dapper if I use:

var values = new DynamicParameters();
values.AddDynamicParams(new { Ids = new[] { 100, 101 } });

But this requires me to KNOW that the parameter name is "Ids" and that's not the case in my scenario.

I can set a "dynamic parameter" in Dapper with a "dynamic" name like this:

var values = new DynamicParameters();
values.Add("Ids", new[] { 100, 101 });

But then Dapper doesn't construct the "IN (....)" SQL with separate parameters for each value.

Is there a way to construct the dynamic object passed in to "AddDynamicParams" but setting the member name and value without knowing the name beforehand?

I could modify the Dapper source to work for my scenario, but if anyone know of a simpler and elegant solution to this I would be greatful!

Best regards Jens

解决方案

I have just submitted a fix to the repository that allows any of the following to work correctly:

by object (this worked previously):

values.AddDynamicParams(new { ids = list });

or, by single name:

values.Add("ids", list);

or, as a dictionary:

var args = new Dictionary<string, object>();
args.Add("ids", list);
values.AddDynamicParams(args);

I have not yet deployed to NuGet. Let me know if this is a problem.

这篇关于Dapper AddDynamicParams for IN statement with“dynamic”参数名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！