Database Independent Development using ASP.NET 2.0 - Developing a simple data access class to work with the factory: skeleton

(Page 4 of 6 )

The following is the skeleton of the DataAccess class, which works with the DBFactory class (listed in the previous section) and acts as a helper class to the business logic classes:

Imports System.Data
Imports System.Data.Common
Public Class DataAccess
  Inherits DBFactory

  Public Sub New(ByVal ProviderName As String, ByVal ConnectionString As String)
    MyBase.New(ProviderName, ConnectionString)
  End Sub

  Public Function GetDataTable(ByVal sqlSELECT As String) As DataTable
    .
    .
    .
  End Function 

  Public Sub SQLExecute(ByVal sql As String)
    .
    .
    .
  End Sub 

  Public Function GetDataRow(ByVal sqlSELECT As String) As DataRow
    .
    .
    .
  End Function 

  Public Function GetValue(ByVal sqlSELECT As String) As String
    .
    .
    .
  End Function

End Class

For the sake of clarity, I removed the implementations of methods. You can find them in the upcoming sections.

Next: Developing a simple data access class to work with the factory: methods >>
 

More ASP.NET Articles
More By Jagadish Chaterjee

Comments On: Database Independent Development using ASP.NET 2.0

· Hello guys! This is new series on database independent development using ASP.NET...   >>> Post your comment now!