Cannot use IEnumberable<T> parameters

[danzel]

We're looking at upgrading from a custom built 2.0.11 version of Npgsql to the latest and greatest and we ran in to this issue:

var comm = conn.CreateCommand();
comm.CommandText = "SELECT :something";
comm.Parameters.AddWithValue("something", new[] { 1, 2, 3 }.Select(x => x)); //Parameter is an IEnumerable<int>
var res = comm.ExecuteScalar();

Previously this would work, now it generates invalid SQL for the parameter.

Bad (IEnumerable):
SELECT (('[1,2,3]')::int4[])

Good (Using an Array):
SELECT (('{1,2,3}')::int4[])

I might take a quick look through to see if I can fix this, no promises however :)

[franciscojunior]

We had a lot of changes about array handling. I think we may have break something... :( Sorry for that.

I'll have a look at this.

Thanks for your feedback!