Npgsql statement 'in' pass an array of strings

Question

I know that a question like this already exists in: How to pass parameter to sql 'in' statement?

but the answers didn't help me, so I am asking for your guidance.

How do you pass a string array as parameter to a Npgsql statement? Let's say the statement goes something like this:

string[] names = new string[] { "one", "two" };

Adapter.SelectCommand.CommandText("Select something.name from something (a lot of inner joins) where something_else.name in (:names) group by something.name having count(*)=2; ");

CloudyMarble · Accepted Answer · 2013-05-21 04:38:51Z

2

Try:

where something_else.name = any(:names)

edited May 21, 2013 at 4:38

CloudyMarble

37.7k70 gold badges103 silver badges133 bronze badges

answered May 21, 2013 at 4:19

frost

645 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gordon Linoff · Accepted Answer · 2013-05-19 17:13:54Z

0

I am not familiar with the exact syntax of npgsql, but I can tell you how to proceed.

From your string array names create a string that looks like "'one', 'two'". Be sure you have the single quotes delimited them.

Then, when you create the command string, don't use variable substitution. Instead, just concatenate the string you just created between the ( and ) after the in statement. That is, directly insert them into the string.

answered May 19, 2013 at 17:13

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

1 Comment

boo_boo_bear Over a year ago

That was a solution I wanted to follow, but I kinda didn't want to bother myself with concatenating strings and such. Thanks for reply!

Collectives™ on Stack Overflow

Npgsql statement 'in' pass an array of strings

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related