Entity Developer allows creating methods from stored procedures and functions both automatically and manually. It also allows creating methods from raw SQL queries manually.
For manual creating and editing methods in Entity Developer, the Method Editor dialog box is used. It requires specifying only the name of the stored procedure. Entity Developer will form the SQL code, running this stored procedure, depending on its type, parameters and the DBMS in use.
Entity Developer also can generate and update methods corresponding to stored procedures or functions via the Database First approach. 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.
As for methods, created from raw SQL queries, Entity Developer allows creating them in the same way, via the Method Editor dialog box. You just need to specify the corresponding SQL code instead of the stored procedure or function name.
