stored procedures - mapping issue

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
bhimavarapumurali
Posts: 1
Joined: Mon 07 May 2012 06:25

stored procedures - mapping issue

Post by 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?

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

Re: stored procedures - mapping issue

Post by 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/inde ... rsors.html .

Post Reply