Entity Developer allows creating methods from stored procedures and functions both automatically and manually.
For manual creating and editing methods in Entity Developer the Method Editor dialog is used, it requires specifying only the name of the stored procedure. Entity Developer will form itself the SQL executions of this stored procedure for the named SQL query, depending on its type, parameters and the DBMS in use.
Entity Developer also enables adding and updating methods corresponding to stored procedures or functions via the Database First approach to working with the model. Methods can be added to the model at the stage of its creation via Create Model Wizard. Furthermore, it is possible to create a method in the model by dragging the corresponding stored procedure or function from the Database Explorer window to the diagram area or in the Model Explorer window. Moreover, with the help of Update From Database Wizard it is possible to add new and modify the existing methods in the model.
Refer to the corresponding sections for the examples showing how to work in Entity Developer with the most frequent cases of using methods based on stored procedures or functions. They are: stored procedure without result, stored function with scalar result, stored procedure with entity result and table-valued function.
See Also
Stored Procedure without Result Stored Function with Scalar Result Stored Procedure and Stored Function With Resultset Stored Procedure with Multiple Resultsets
|