Postgres parameters at SQL requests, C#

Question

I run these commands in a Windows Forms app written in C#:

NpgsqlCommand command = new NpgsqlCommand("DO $$ BEGIN IF EXISTS(select id from clients where id=@cnumberclient) THEN INSERT INTO reservations(roomnumber,clientnumber,datein, dateout) values(@rnumber, @cnumber, @din, @dout); ELSE raise notice 'HYI'; END IF; END $$;", conn.getConnection());
command.Parameters.Add("@cnumber", NpgsqlDbType.Integer).Value = ClientId;
command.Parameters.Add("@cnumberclient", NpgsqlDbType.Integer).Value = ClientId;
command.Parameters.Add("@rnumber", NpgsqlDbType.Integer).Value = RoomId;
command.Parameters.Add("@din", NpgsqlDbType.Date).Value = dateIn;
command.Parameters.Add("@dout", NpgsqlDbType.Date).Value = dateOut;

then I open the connection and execute the command:

conn.openConnection();

if (command.ExecuteNonQuery() == 1)

But I get an error.

column "cnumberclient" doesn't exist

Postgres doesn't seem to see the parameters Can you help me?

Possibly relevant npgsql.org/doc/… Maybe put spaces around it, as npgsql has to parse and replace named parameters with positional parameters before sending the query — Charlieface
– Charlieface, Commented Jun 8, 2022 at 19:46

Blindy · Accepted Answer · 2022-06-08 19:47:56Z

5

Remove the @ symbol from your parameters, that's not part of the parameter name, it's the symbol to identify them in the Sql query.

answered Jun 8, 2022 at 19:47

Blindy

68k10 gold badges96 silver badges141 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres parameters at SQL requests, C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related