我正在寻找在查询中参数化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)}')";

提前致谢 .