stored procedures - mapping issue

stored procedures - mapping issue

Postby bhimavarapumurali » Mon 07 May 2012 06:42

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?
bhimavarapumurali
 
Posts: 1
Joined: Mon 07 May 2012 06:25

Re: stored procedures - mapping issue

Postby Shalex » Wed 09 May 2012 11:42

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/index.php/working-with-stored-procedures-and-ref-cursors.html .
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for PostgreSQL