ExecuteAsync throws Exception when value in insert query contains " : "

[timurash]

This code:

await connection.ExecuteAsync("insert into testtable (building_address_house) values ('13 sum : A')", transaction)

Or this code:

await connection.ExecuteAsync("insert into testtable (building_address_house) values (' : ')", transaction)

Throws this exception:

System.NotSupportedException: The member Connection of type Npgsql.NpgsqlConnection cannot be used as a parameter value

How can I fix this problem?

[mgravell]

You're passing "transaction" as the parameters - it is presumably the DbTransaction? If so: Change "transaction" to "transaction: transaction" (to use named parameters rather than ordinal)

…

On Sun, 10 Jan 2021, 12:33 Timur Akhmetov, ***@***.***> wrote: This code: await connection.ExecuteAsync("insert into testtable (building_address_house) values ('13 sum : A')", transaction) Or this code: await connection.ExecuteAsync("insert into testtable (building_address_house) values (' : ')", transaction) Throws this exception: System.NotSupportedException: The member Connection of type Npgsql.NpgsqlConnection cannot be used as a parameter value [image: image] <https://user-images.githubusercontent.com/63206211/104122926-dbd87680-5369-11eb-8e70-30c81f41cdc0.png> How can I fix this problem? — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#1605>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAAEHMCFPH23MJYVB3LKKQDSZGNB5ANCNFSM4V4MPH5Q> .

[mgravell]

Btw: the values to be inserted probably *should* be parameters.

…

On Sun, 10 Jan 2021, 12:33 Timur Akhmetov, ***@***.***> wrote: This code: await connection.ExecuteAsync("insert into testtable (building_address_house) values ('13 sum : A')", transaction) Or this code: await connection.ExecuteAsync("insert into testtable (building_address_house) values (' : ')", transaction) Throws this exception: System.NotSupportedException: The member Connection of type Npgsql.NpgsqlConnection cannot be used as a parameter value [image: image] <https://user-images.githubusercontent.com/63206211/104122926-dbd87680-5369-11eb-8e70-30c81f41cdc0.png> How can I fix this problem? — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#1605>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAAEHMCFPH23MJYVB3LKKQDSZGNB5ANCNFSM4V4MPH5Q> .

[timurash]

Thank you so much, your advice completely solved my problem