Npgsql pass parameters by name to a stored function

Question

I'm working with code I'm converting to Pgsql working with .NET. I want to call a stored function that has several parameters, but I'd like to bind the parameters by name, like so:

NpgsqlCommand command = new NpgsqlCommand("\"StoredFunction\"", _Connection)
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("param2", value2);
command.PArameters.Add("param1", value1);

Attempts to do this so far look for a function with parameter types matching in the order in which I added the parameters to the collection, not by name.

Is it possible for Npgsql to bind parameters to stored functions by name?

Answer 1

Hi!

Currently Npgsql doesn't support pass parameters by name. Although it supports receiving out parameter values by name.

Would you mind to fill a bug report about that? So we can track and implement it.

Thanks in advance.

Answer 2

Yes it does, you can use :paramname, plus I think in the latest version you can use parameters.addwithvalue(":paramname", param).

Plus I think you can use @paramname just as you can in sql server with the latest version too.

Read secion "Using parameters in a query " of this manual for an answer to your original question - but remember what I said above to make your life easier.