code snippet:
Code: Select all
var databaseParameter = new Devart.Data.PostgreSql.PgSqlParameter(
":p0_0",
new Devart.Data.PostgreSql.PgSqlArray(new string[]{"\"avec quotes\"", "titi"}, Devart.Data.PostgreSql.PgSqlType.VarChar, 1, 2));
var parameters = new List<PgSqlParameter>(){databaseParameter };
var commandText = "SELECT x, y from Mytable WHERE (metadata ->> 'FME_EPRPROJ07_Str_Code') ilike ANY(:p0_0 ::varchar[]) ) ";
this.context.Database.SqlQuery<myObject>(commandText , parameters );
but fails when UnpreparedExecute = True with the following error: {"malformed array:" {\ "\\\\\" avec quotes\\\\\ "\", titi} ""}
NB: databaseParameter.pgSqlValue is
Code: Select all
{{"\"avec quotes\"",titi}}
Thanks for your helps.