Devart Forums

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

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

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.

ok thanks