Overview

Entity Developer lets you create methods from stored procedures and functions automatically or manually.

Manual method creation

For manual creation and editing of methods in Entity Developer, the Method Editor dialog is used. It requires specifying only the name of the stored procedure. Entity Developer automatically generates the SQL execution statement of the stored procedure for the named SQL query, depending on its type, parameters, and the DBMS in use.

Automatic method creation (Database-First approach)

Entity Developer enables adding and updating methods corresponding to stored procedures or functions via the Database-First approach:

• Add methods to the model during creation via the Create Model Wizard.
• Drag the corresponding stored procedure or function from the Database Explorer window to the diagram area or Model Explorer window.
• Add new and modify existing methods in the model using the Update From Database Wizard.

See also

For examples of common method use cases, see the following topics.

• Stored procedure without result
• Stored function with scalar result
• Stored procedure and stored function with resultset
• Stored procedure with multiple resultsets
• Table-valued function
• Working with methods