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.

Requirements

In order to complete this walkthrough, you will need access to the Oracle database server 9.2.0.4 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.

Contents

• Stored Routines in Entity Framework Model
• Creating Database and Model
• Stored Procedure Returning Result Set using REF CURSOR Out Parameter
• Stored Function Returning REF CURSOR
• Mapping CUD Operations to Stored Routines
• Mapping CUD Operations to Command Texts
• Working with Oracle Pipelined Functions

See Also

Entity Framework Tutorial  | Using Entity Data Model Wizard