Call Stored Procedure with inout parameters in c# - Mailing list pgsql-general

From İlyas Derse
Subject Call Stored Procedure with inout parameters in c#
Date
Msg-id CALcdmyTni2MGmyt4tVuUjH4bgLvQLKBuxaCoT8+-Th+Vqx_wXA@mail.gmail.com
Whole thread Raw
List pgsql-general
I tried with inout parameters but it did not work correctly.

here is my procedure :

CREATE OR REPLACE PROCEDURE public.testing ( INOUT x int )
LANGUAGE 'plpgsql'
AS $$
BEGIN
   x := x * 3;
END ;
$$;

my C# code:

public void myMethod2()
        {
            CRUD.con.Open();
            int a = 5;
            using (var cmd = new NpgsqlCommand("call public.testing();", CRUD.con))
            {
                var objParam = new NpgsqlParameter("x", NpgsqlDbType.Integer)
              { Direction = ParameterDirection.Output };
                objParam.Value = 5;
                cmd.Parameters.Add(objParam);
                cmd.ExecuteNonQuery();
                Console.WriteLine(objParam.Value);
            }
            CRUD.con.Dispose();
        }

pgsql-general by date:

Previous
From: Michael Korbakov
Date:
Subject: Re: Adding LIMIT changes PostgreSQL plan from good to a bad one
Next
From: Adrian Klaver
Date:
Subject: Re: Pgadmin 4 schema visibility