Create New Stored Procedures

If you select this option, the Business Layer Generator generates stored procedures based on the selected database object(s) on the previous wizard page.

Note: The Business Layer Generator does NOT generate a custom data access class if you are using the Entity Framework. It only generates the stored procedures which can be accessed from an EDMX file as described in the topic Adding Stored Procedures for Insert, Update, Delete.

If you are using classic MM .NET entities, a custom data access class is generated that makes use of the generated stored procedures:

When you select the option to Create New Stored Procedures the wizard page displays the following controls (if you are generating for Entity Framework, you will not see the Data Access Object controls on the right):

In the section What do you want to name the stored procedures?, there are Select, Insert, Update, Delete, and Select ByPK text boxes that display a template for stored procedure names. By default, the text boxes contain a <DbcObjectName> placeholder that is replaced with the selected database object name at run time. For example, if you select the Orders table on the previous wizard page, the Business Layer Generator will create the following stored procedures:

OrdersSelect
OrdersInsert
OrdersUpdate
OrdersDelete
OrdersSelectByPK

You can change the default stored procedure to anything you want, and the next time you run the Business Layer Generator, it will remember your settings.

The Run Database Script option specifies if the generated database script should be run automatically when the business and data layer classes are created.

On the right side of the wizard page under the Data Access Object label are the following settings that apply to the custon data access class created by the Business Layer Generator:

Base class specifies the base class of the generated data access class.

Class Name Prefix specifies the prefix to be given to the generated data access class name. The Business Layer Generator prepends this prefix to the selected database object name on the previous wizard page to derive the name of the generated data access class.

Class Name Suffix specifies the suffix to be given to the generated data access class name. The Business Layer Generator appends this suffix to the selected database object name on the previous wizard page to derive the name of the generated data access class.

Parameter Prefix (in, out, in/out) specifies the prefix character(s) to be used when generating stored procedures and custom data access objects. You can specify a single character for input, output and input/output parameters, or you can specify different parameter prefix character(s) for each of these by separating them with a comma. For example:

i_,o_,io_

If you click the View SQL Script... button you can see the SQL Script code the Business Layer Generator will use to create new stored procedures. For example: