dotConnect for Oracle Documentation
Working with Oracle Cursors and Stored Procedures in Entity Framework

This article describes how to create Entity Framework model with stored procedures in Entity Developer and EDM Designer. It tells how to create methods, based on Oracle stored procedures and functions, returning REF CURSOR parameters, and how to use the stored procedures for mapping insert, delete, and update operations.


In order to complete this walkthrough, you will need access to the Oracle database server or higher. You also need dotConnect for Oracle Professional Edition 5.25 or higher. Microsoft Visual Studio 2008 SP1 or higher is also required. You need to create EntityClass Dept based on Dept table in the Northwind database. You can read more about this activity in the Entity Framework tutorial.

The topics in this section are applicable to Entity Framework v1 - v6. They are not applicable to Entity Framework Core, which does not support stored routines.


See Also

Entity Framework Tutorial  | Using Entity Data Model Wizard