PostgreSql : how can we call stored procedures inout parameters in C#?

Question

I can take data from functions but I can not call stored procedures parameters in C# with Npgsql. Do you have an idea?

Answer 1

Here's a quick example:

using (var cmd = new NpgsqlCommand("SELECT my_func()", conn))
{
    cmd.Parameters.Add(new NpgsqlParameter("p_out", DbType.String) { Direction = ParameterDirection.Output });
    cmd.ExecuteNonQuery();
    Console.WriteLine(cmd.Parameters[0].Value);
}

For more information, take a look at the documentation.