使用ODBC的Dapper WHERE IN语句 [英] Dapper WHERE IN statement with ODBC

问题描述

我在ODBC提供程序上使用了Dapper，众所周知，该提供程序不支持命名参数.对于大多数查询，我使用伪命名参数:?name?.但是，当我尝试

I am using Dapper on ODBC provider, which as known does not support named parameters. For most of my queries I used pseudo named parameters: ?name?. However, when I try to

 string query = $"select * from \"{TableName}\" where ID in ?Ids?";
 return connection.Query<CdfGroupByCdfUserRecord>(query, new {Ids = ids}).ToArray();

我看到Dapper生成查询

I see that Dapper generates query

select * from "MY_TABLE" where ID in (?Ids1,?Ids2,?Ids3,?Ids4,?Ids5)?

我应该怎么做才能使它工作?

What should I do to get it work?

推荐答案

这似乎是dapper中的错误.我将尝试将其修复为1.50.2.我已记录(出于跟踪目的)此处

This appears to be a bug in dapper. I'll try to fix it for 1.50.2. I've logged it (for tracking purposes) here

这篇关于使用ODBC的Dapper WHERE IN语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！