Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

.Net Driver and Using Oracle DB with Entity Framework

2647934Oct 13 2015 — edited Oct 13 2015

There seems to be a blatant issue when using Entity Framework and Oracle DBs in that any stored procedure that uses a ref_cursor as an output you have to manually define the properties of that ref_cursor in the app.config file. This just seems ridiculous, the following webpage:

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/dotnet/EntityFrameworkOBE_2/EntityFrameworkOBE.html

Describes a fairly easy process of going into server explorer and running the stored proc and then attaching the output ref cursor's parameters to config but when I try and do this I can only run procedures that don't output ref_cursors as any proc with an output as a ref_cursor I click on run and it does nothing.

Regardless if I even get this working I:

A) Don't want to manually type out the mapping for each ref_cursor I use

B) Don't want to put them all in app.config as that would be a ridiculous mess for even a sensible number of procedures

It just seems like this tool isn't really a "tool" at all....

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 10 2015
Added on Oct 13 2015
0 comments
711 views