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