ASP.NET/Data Access Layer and Business Logic Layer

DataSet
Add New Item: DataSet Open the database viewer, drag and drop database tables into the DataSet viewer.

From the DataSet viewer, you can right click on the table, add new queries and configure them as per standard SQL using the wizard.

BLL (Business Logic Layer)
Add New Item: Class Naming Convention is to suffix the class name with BLL for example 'CustomersBLL'