Setup - 5 easy steps and you're done!

Please return to 'Start' to paste in your query output.

Enter the settings requested below. These will be used when generating your object classes, SQL Server stored procedures, and Web Form elements.
 

STEP #1. Enter Namespaces

Domain Namespace:

Tip: Use a high-level singular name such as Sales.Domain, Inventory.Domain, etc. The assembly for your Business Layer should exist in a separate project in Visual Studio.NET from your Presentation Layer. The Business Layer assembly can be included as a Reference in the project for the Presentation Layer.
 (e.g. Sales.Domain)

Data Namespace:

Enter the name of your data access layer namespace (e.g. Sales.Data)

STEP #2. Enter a Table Name

This will be used to build the Data Access Layer components.

 (e.g. Customers)

STEP #3. Enter a Class Name

Use singular name to represent a single object in your table - e.g. use "Customer" for the "Customers" table

 (e.g. Customer)

STEP #4. Enter a Connection String Name

This will be used in the Business Layer to allow connection to the Data Access Layer This should be added to your Web.Config or Machine.Config file in the <connectionStrings> section. Below is an example.

<configuration>
<connectionStrings>
     <add name="Sales"
     connectionString="server=localhost;database=Sales;user id=web_user;password=web_user;"/>
</connectionStrings>

Connection String Name (e.g. Sales)

STEP #5. Stored Procedure Naming Convention

For the Data Access Layer, please indicate the names for your Stored Procedures. This a huge subject of debate that differs in almost every IT environment. To pre-pend the Stored Procedures with "usp_", "p_" or "sproc_", enter it below. Remember, it's not recommended to pre-pend a procedure name with "sp_" as this prefix is used by the SQL Server "master" database.

Enter Stored Procedure Names Below:

Insert:
Delete:
Select:
Update:
Grant Access To:

Click the button below to generate the layers.