Stored procedues INOUT parameter

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
akash.hegde@gmail.com
Posts: 15
Joined: Sat 26 Nov 2011 00:56

Stored procedues INOUT parameter

Post by akash.hegde@gmail.com » Wed 07 Dec 2011 04:26

Hi
i have a stored procedure that has an INOUT parameter. When i try to associate the class with the stored procedure for insert and updates, it does not display the procedure in the "stored procedure" drop down list using the configure behaivour in visual studio.

It only shows stored procedures that have IN parameters

I'm using the devart entity model for postgresql.

Please advice.

Signature of the stored procedure is

CREATE OR REPLACE FUNCTION cbill.insert_attribute_transactions(INOUT p_id integer, IN p_object_id character varying, IN p_attribute_name character varying, IN p_attribute_type character varying)
RETURNS integer AS

Please advice

akash.hegde@gmail.com
Posts: 15
Joined: Sat 26 Nov 2011 00:56

Post by akash.hegde@gmail.com » Wed 07 Dec 2011 07:31

I tried setting concealed function = true however it gives me the error


The parameter p_id is bound multiple times. This is because p_id is an INOUT parameter and hence had to be mapped in the input parameter as well as the result set bindings

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Wed 07 Dec 2011 16:47

Entity Framework allows to map only IN parameters of stored procedure to class properties. The OUT (INOUT) parameter can be used only for Rows Affected Parameter.

akash.hegde@gmail.com
Posts: 15
Joined: Sat 26 Nov 2011 00:56

Post by akash.hegde@gmail.com » Wed 07 Dec 2011 21:42

ok thanks

Post Reply