Page 1 of 1

stored procedures - mapping issue

Posted: Mon 07 May 2012 06:42
by bhimavarapumurali
Hi sir,
I have a stored procedure with the following signature

CREATE OR REPLACE FUNCTION searchpatient(refcursor, searchfilter character varying)
RETURNS SETOF refcursor AS
begin
end

I have 2 classes (or tables)
all_attributes
attribute_type
I want to map the all_attributes class to the above stored procedure.

In functionimports of .edmx model our functions doesn't show in drop down list....
How to map our functions into .edmx model drop down ,and How can i get the description of procedure to appear?

Re: stored procedures - mapping issue

Posted: Wed 09 May 2012 11:42
by Shalex
Stored procedures with refcursor IN parameters are not supported. An example of working with refcursor OUT parameters is available at http://blogs.devart.com/dotconnect/inde ... rsors.html .