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

[phowe]

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

[Shalex]

Please refer to http://forums.devart.com/viewtopic.php?f=1&t=23217. Does this help?

[phowe]

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