I am trying to filter using "WHERE IN" with dapper but I'm receiving error. I have tried:
WHERE Channel = ANY(SELECT @Channels) = Npgsql.PostgresException (0x80004005): 42883: operator does not exist: character varying = text[]
WHERE Channel = ANY(@Channels): Npgsql.PostgresException (0x80004005): 22P03: invalid array flags
WHERE Channel IN @Channels: Npgsql.PostgresException (0x80004005): 42601: syntax error at or near "$1"
WHERE Channel IN (@Channels): Npgsql.PostgresException (0x80004005): 42883: operator does not exist: character varying = text[]
Channels is a List<string>
how can I do that?
User contributions licensed under CC BY-SA 3.0