Thread: BUG #16244: Ref cursor from PostgreSQL and entity Framework

BUG #16244: Ref cursor from PostgreSQL and entity Framework

From

PG Bug reporting form

Date:

05 February 2020, 11:45:36

The following bug has been logged on the website:

Bug reference:      16244
Logged by:          Ravi Sah
Email address:      rblucky3@gmail.com
PostgreSQL version: 11.6
Operating system:   Windows 10
Description:

I have a Function in PostgreSQL that has return type 'refcursor'. i'm using
this Function in Entity Framework by using Add Function Import.ThenI am
getting error in Entity Framework 6.0 that

"System.NotSupportedExcepction"

i have used Npgsql,dbconnect provider for connection to postgresql.

.Kindly provide solution for this problem..

Re: BUG #16244: Ref cursor from PostgreSQL and entity Framework

From

"David G. Johnston"

Date:

05 February 2020, 17:35:25

On Wednesday, February 5, 2020, PG Bug reporting form <noreply@postgresql.org> wrote:

The following bug has been logged on the website:

Bug reference: 16244
Logged by: Ravi Sah
Email address: rblucky3@gmail.com
PostgreSQL version: 11.6
Operating system: Windows 10
Description:

I have a Function in PostgreSQL that has return type 'refcursor'. i'm using
this Function in Entity Framework by using Add Function Import.ThenI am
getting error in Entity Framework 6.0 that

"System.NotSupportedExcepction"

i have used Npgsql,dbconnect provider for connection to postgresql.

.Kindly provide solution for this problem..

Rewrite the function to not use a refcursor which doesn’t seem to be a supported element in your framework. Or, don’t use the framework. Either way this doesn’t seem to meet the criteria for a bug report. Posts like this should be direct to the -general list.

David J.