我正在寻找在查询中参数化IN子句的任何工作方式 . 我尝试过类似的东西,但没有工作 .
{
query: "Select r.id, r.Shipper.Name AS Shipper FROM root r WHERE r.Shipper.Name IN (@Shipper0,
Shipper1)",
parameters: [
{ name: "@Shipper0", value: "ABC" },
{ name: "@Shipper1", value: "XYZ" }
]
}
为了创建这个 "(@Shipper0, @Shipper1)"
,做了一些c#编码 . 没有params相同的查询工作正常 .
List<string> list = new List<string>();
工作查询:==>
$"Select r.id, r.Shipper.Name AS Shipper FROM root r Where r.Shipper.Name IN ( '{string.Join("', '", list)}')";
提前致谢 .