Npgsql pass parameters by name to a stored function

Posted by Jeff on Stack Overflow See other posts from Stack Overflow or by Jeff
Published on 2010-03-04T20:28:49Z Indexed on 2010/04/23 14:43 UTC
Read the original article Hit count: 919

Filed under:

pgsql

|

npgsql

|

c#

|

stored-functions

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?

© Stack Overflow or respective owner

Related posts about pgsql

Zendframework / PgSQL fetchAll orderby

as seen on Stack Overflow - Search for 'Stack Overflow'
i have a pgsql table with fields id, identifier, name. id serial NOT NULL, identifier character varying(16), name character varying(128) I want to fetchAll values from the table orderby identifier. but identifier is having values 12, 100, 200, 50 and after $table->fetchAll(null, 'identifier'); is… >>> More
Excel and pgSQL

as seen on Stack Overflow - Search for 'Stack Overflow'
How do I import data from a excel sheet onto a PGSQL database on linux? >>> More
Postgres: Using function variable names in pgsql function

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I have written a pgsql function along the lines of what's shown below. How can I get rid of the $1, $2, etc. and replace them with the real argument names to make the function code more readable? Regards Peter CREATE OR REPLACE FUNCTION InsertUser ( UserID UUID, FirstName CHAR(10), … >>> More
Regular expression replace in PL/pgSQL

as seen on Stack Overflow - Search for 'Stack Overflow'
If I have the following input (excluding quotes): "The ancestral territorial imperatives of the trumpeter swan" How can I collapse all multiple spaces to a single space so that the input is transformed to: "The ancestral territorial imperatives of the trumpeter swan" This is going to… >>> More
want to change pgsql port

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, currently install pgsql is running on port 1486 now I want to change this port to 5433, So how I've proceed for this....????? Thanx in advance.. >>> More

Related posts about npgsql

What happens when Npgsql connection pool reaches Max

as seen on Stack Overflow - Search for 'Stack Overflow'
Both the name of the connection string parameter and this blog post - http://fxjr.blogspot.co.uk/2010/04/npgsql-connection-pool-explained.html - lead me to believe that Npgsql wont exceed the MaxPoolSize value set in the connection string. However the docs (http://npgsql.projects.postgresql.org/docs/manual/UserManual… >>> More
Using npgsql with SSIS

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am using npgsql as the ADO.NET provider in SSIS to connect to Postgres and create some workflows. I am able to connect to postgres but am unable to use the "Table or view" data access mode to list the tables and views. I have to resort to using "SQL command" data access mode. For the "table… >>> More
Npgsql pass parameters by name to a stored function

as seen on Stack Overflow - Search for 'Stack Overflow'
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… >>> More
NpgSQL insert file path containing backslashes "\\"

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to create a record containing the path to a file. The insertion is done into a Postgres database where UTF8 is enabled, using the NpqSQL driver. My table definition: CREATE TABLE images ( id serial, file_location character varying NOT NULL ) My SQL statement (boiled down to… >>> More
NPGSQL seems to have a rather large bug?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, this is a weird one, when I run the following code all rows are returned from the db. Imagaine what would happen if this was an update or delete. Dim cmd As New NpgsqlCommand cmd.Connection = conn cmd.CommandText = "select * FROM ac_profiles WHERE profileid = @profileId" cmd… >>> More