如何将参数传递给 sql 'in' 语句? [英] How to pass parameter to sql 'in' statement?

问题描述

我想创建这个查询:

select * from products where number in ('123', '234', '456');

但我找不到任何使用 Npgsql 和 NpgsqlParameter 实现此目标的示例.我试过这样:

but I can't find any example of achiving this with Npgsql and NpgsqlParameter. I tried like this:

string[] numbers = new string[] { "123", "234" };

NpgsqlCommands cmd = new NpgsqlCommands("select * from products where number in (:numbers)");
NpgsqlParameter p = new NpgsqlParameter("numbers", numbers);
command.Parameters.Add(p);

但它没有工作;)

推荐答案

将其作为数组传递:

string[] numbers = new string[] { "123", "234" };

NpgsqlCommands cmd = new NpgsqlCommands("select * from products where number = ANY(:numbers)");
NpgsqlParameter p = new NpgsqlParameter("numbers", NpgsqlDbType.Array | NpgsqlDbType.Text);
p.value = numbers;
command.Parameters.Add(p);

这篇关于如何将参数传递给 sql 'in' 语句?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！