Where in String[] only one param ?? about dbextensions HOT 5 CLOSED

This works:
.WHERE("i.UUID IN ({0})", (Array)uuids.ToArray());

from dbextensions.

C# will cast an array of any reference type to object[], but it won't cast an array of a value type.

So,

WHERE("i.UUID IN ({0})", new string[] {"test1","test2","test3"});

is equivalent to

WHERE("i.UUID IN ({0})", "test1","test2","test3");

To work around it you have to explicitly create the params array:

WHERE("i.UUID IN ({0})", new object[] { new string[] { "test1","test2","test3" } });

or cast the array to object:

WHERE("i.UUID IN ({0})", (object)new string[] { "test1","test2","test3" });

This is not an issue with value type arrays, e.g.

WHERE("i.UUID IN ({0})", new int[]{ 1, 2, 3 });

is equivalent to

WHERE("i.UUID IN ({0})", new object[] { new int[]{ 1, 2, 3 } });

from dbextensions.

I see it confuses the array values for the function parameters.
It is a bit easy to make a mistake here, i spent hours on this mistake.

At first i tried to give it a list but it says it doesn't support the type.
I think this would be more clear if it accepted list also.

Then you could do a simple .ToList() and you would know that those will be values and they cant be interpreted as function parameters.

It would also be easier to explain this situation in docs IMO.

I will use it like this from now on:
(Array)uuids.ToArray());

I just have to be vigilant not to forget to typecast it.

from dbextensions.

Yes, this needs to be explained in the documentation. I'll leave this issue open as a reminder.

from dbextensions.

Updated documentation.

from dbextensions.