Use Existing Stored Procedures

The Use Existing Stored Procedures option is only visible if you are NOT using Entity Framework.

If you select this option, the Business Layer Generator generates a custom data access class that uses the existing stored procedures that you specify in this step:

Note: Since you are specifying existing stored procedures to use for updating, you can only choose this option if you select a single database object on the previous wizard page

When you select the option to Use Existing Stored Procedures the wizard page displays the following controls:

The combo boxes on the left side of the wizard page allow you to specify existing SELECT, INSERT, UPDATE, DELETE, and SELECT BY PK stored procedures to use in generating the new custom data access class.

When you choose a SELECT Stored Procedure, it displays the data columns of the stored procedures result set in the list box on the right side of the wizard page:

When you select a stored procedure you can click on the View SQL button the SQL Command Text dialog displays the SQL code of the currently selected stored procedure:

When you choose an INSERT Stored Procedure, it displays the parameters of the stored procedure in the list box. The list box also displays the Source Column of the SELECT stored procedure that best fits the parameter name in the Parameter column:

The Business Layer Generator makes its best guess when matching parameters in the INSERT stored procedure to result columns in the SELECT stored procedure. If the Source Column it chooses by default is incorrect, you can manually choose another column from the Source Column combo box:

When you choose an UPDATE Stored Procedure, the Business Layer Generator displays the parameters of the stored procedure in the list box as well as its best guess at matching Source Columns. Again, you can change the default Source Columns as needed:

When you choose a DELETE Stored Procedure, again, the Business Layer Generator displays the parameters of the stored procedure in the list box along with matching Source Columns which can be changed as needed:

When you choose a SELECT BY PK Stored Procedure, the Business Layer Generator displays the data columns of the stored procedure result set in the list box on the right side of the wizard page: