NEED SOME HELP: Need to call stored procedure using entity Framework 5 code first

NEED SOME HELP: Need to call stored procedure using entity Framework 5 code first

Postby phowe » Mon 06 Jan 2014 20:25

We are hip-deep in a project that accesses an existing database (albeit not that well designed) with C# and Entity Framework 5 using a code-first approach (was recommended since we did not want to "get married" to the poor database design.)

All has gone about as well as can be expected, until now when we need to call a stored procedure. The procedure has a number of IN parameters and a single OUT parameter (string result, either empty string or error message.)

Any help in the form of good documentation or sample code would be MOST helpful. :!:

Versions: Oracle 11g server, dotConnect 7.9.333, VS2012 C#

Thanks,
Peter
phowe
 
Posts: 20
Joined: Fri 12 Jul 2013 16:51
Location: Maine

Re: NEED SOME HELP: Need to call stored procedure using entity Framework 5 code first

Postby Shalex » Wed 08 Jan 2014 10:20

Shalex
Devart Team
 
Posts: 7606
Joined: Thu 14 Aug 2008 12:44

Re: NEED SOME HELP: Need to call stored procedure using entity Framework 5 code first

Postby phowe » Wed 08 Jan 2014 15:22

We are past this issue, but ended up dropping out of the Entity Framework space in order to make the calls, using good old OracleConnection and OracleCommand objects. We realize the EF world is oblivious to whatever happens in the stored procs, and that we must deliberately attach or include any entities in a context if we want what happens in the stored proc to be reflected in the contexts.

Thanks,
Peter
phowe
 
Posts: 20
Joined: Fri 12 Jul 2013 16:51
Location: Maine


Return to dotConnect for Oracle