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?

Brian Webster · Accepted Answer · 2011-09-07 04:10:06Z

3

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.

edited Sep 7, 2011 at 4:10

Brian Webster

31k51 gold badges158 silver badges227 bronze badges

answered Mar 5, 2010 at 18:14

Francisco Junior

2,01619 silver badges25 bronze badges

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

2 Comments

Jeff Over a year ago

Having trouble reporting this. I've registered on the site but reporting the bug isn't working.

Francisco Junior Over a year ago

Would you mind to try filling the bug report again. Thanks in advance.

Ian Griffiths · Accepted Answer · 2017-09-08 14:35:45Z

3

Unfortunately it does not work with store procedure (CommandType.StoredProcedure).

It does with SQL-text command (CommandType.Text). You can use :paramname, plus I think in the latest version you can use parameters.addwithvalue(":paramname", param).

You can also use @paramname with the latest version (like MS Sql Server).

Read section "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.

edited Sep 8, 2017 at 14:35

Ian Griffiths

14.6k3 gold badges68 silver badges88 bronze badges

answered Apr 23, 2010 at 14:39

Mr Shoubs

15.6k18 gold badges72 silver badges109 bronze badges

3 Comments

Tim Over a year ago

testing with the version of Npgsql available in Q1 2013, I find that the provider seems to support only positional mode parameter passing to functions on the server when client-side the command is in CommandType.StoredProcedure mode. The order in which the parameters are added to the Command's Parameters collection is the order in which they're provided.

Mr Shoubs Over a year ago

I didn't test with StoredProcedure, it does work with Text though.

Fritz Over a year ago

The link to the manual does not work anymore, do you know where it has moved to?

Collectives™ on Stack Overflow

Npgsql pass parameters by name to a stored function

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related