Npgsql pass parameters by name to a stored function

c# npgsql stored-functions postgresql
Jeff picture Jeff · Mar 4, 2010 · Viewed 7.2k times · Source

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

Francisco Junior picture Francisco Junior · Mar 5, 2010

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.

Related questions

Execute stored procedure with parameters postgresql

My Npgsql version 3.2.5 - Postgresql 9.6 I get this error with CommandType.StoredProcedure (but CommandType.Text works): Npgsql.PostgresException: '42883: function customer_select(pEmail => text, Password => text) does not exist' string sql3 = @"customer_select"; NpgsqlConnection pgcon = new NpgsqlConnection(pgconnectionstring); …

Read More
INSERT data from Textbox to Postgres SQL

I just learn how to connect C# and PostgresSQL. I want to INSERT data from tb1(Textbox) and tb2 to database. But I don't know how to code My previous code is SELECT from database. this is my code private …

Read More
PostgreSQL: 42883 Operator does not exist: timestamp without time zone = text

I am using Npgsql 3.0.3.0 and PetaPoco latest version. When I run this command: var dateCreated = DateTime.Now; // just an example var sql = new Sql("WHERE date_created = @0", dateCreated.ToString("yyyy-MM-dd HH:00:00")); var category = db.SingleOrDefault<Category>(sql); I …

Read More