Oracle Hello World and EF6

Posts   
 
    
ianvink
User
Posts: 393
Joined: 15-Dec-2006
# Posted on: 20-Oct-2020 23:28:36   

We are investigating LLBL and Oracle 11.2 We have ODP.Net installed and can add stored procedures to an EF 6 project in the designer.

When we Reverse-Engineer a Stored procedure, one of the Out Parameters, "XSlowMoveInv", is a "REF CURSOR" and as such when we try and generate the project, we get an error:

**The Stored Procedure Call 'Apps.XxWebXXXX' contains parameter 'XSlowMoveInv' which type is set to 'object (System.Object)' **

Given I can not change the Oracle database in any way, what is the best option to generate the c# EF 6 code so that we can call the stored procedure and get back a value to show to our team as a "Hello World" demo.

I am open to other frameworks like EF Core if that is better to use.

Attachments
Filename File size Added on Approval
2020-10-20_14-26-45.jpg 279,701 20-Oct-2020 23:29.05 Approved
daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 21-Oct-2020 07:10:40   

ianvink wrote:

I am open to other frameworks like EF Core if that is better to use.

Hi Ian, Are you open to LLBLGen Framework or NHibernate?

David Elizondo | LLBLGen Support Team
ianvink
User
Posts: 393
Joined: 15-Dec-2006
# Posted on: 21-Oct-2020 17:14:42   

Yep, those are fine. LLBL framework is fine.