SqlConnection Array of ints parameter

Asked Oct 01 '14 at 19:09

Active Oct 01 '14 at 19:09

Viewed 24 times

This is a part of my query:

WHERE GroupId IN (@groupIds)

With @groupIds being a List of integers of IDs. How can I pass that list as a parameter in a SqlConnection? I'm trying:

return conn.Query<>(query, new { @groupIds }).ToList();

But that's not working.

asked Oct 01 '14 at 19:09

Matheus Lima

Instead of accepted answer in the linked question see: http://stackoverflow.com/a/337792/961113 – Habib Oct 01 '14 at 19:10
you cannot do that unless and otherwise you make the entire stored proc dynamic which is not recommended – Dan Hunex Oct 01 '14 at 19:10
@Habib that's for strings, I need integer. – Matheus Lima Oct 01 '14 at 19:14
@MatheusLima, there shouldn't be any difference. You can use the same code, instead of `string[] tags` you will have `List` – Habib Oct 01 '14 at 19:16

0 Answers0