ASP.NET/Data Access Layer and Business Logic Layer

DAL (Data Access Layer) & BLL (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' Imports OrderingSystemDSTableAdapters <System.ComponentModel.DataObject()> _ Public Class CustomersBLL Private _customersAdapater As CustomersTableAdapter = Nothing Protected ReadOnly Property CustomersAdapater() As CustomersTableAdapter Get If _customersAdapater Is Nothing Then _customersAdapater = New CustomersTableAdapter() End If Return _customersAdapater End Get End Property <System.ComponentModel.DataObjectMethod(ComponentModel.DataObjectMethodType.Select, True)> _ Public Function getCustomer() As OrderingSystemDS.CustomersDataTable Return CustomersAdapater.GetCustomers() End Function <System.ComponentModel.DataObjectMethod(ComponentModel.DataObjectMethodType.Select, False)> _ Public Function getCustomerByCustomerID(ByVal CustomerID As Integer) As OrderingSystemDS.CustomersDataTable Return CustomersAdapater.GetCustomerByCustomerID(CustomerID) End Function End Class