Forum Stats

  • 3,770,583 Users
  • 2,253,137 Discussions
  • 7,875,499 Comments

Discussions

.Net Driver and Using Oracle DB with Entity Framework

2647934
2647934 Member Posts: 8
edited Oct 13, 2015 7:53AM in .NET Stored Procedures

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....

Tagged:
This discussion has been closed.