Database Independent Development using ASP.NET 2.0 - Developing a common class which works with Factories: source code
(Page 2 of 6 )
The following is the entire source code for a class (DBFactory), which mainly works with the factory classes available in ADO.NET 2.0:
Imports System.Data
Imports System.Data.Common
Public Class DBFactory
#Region "Private members"
Private _DBProviderName As String
Private _ConnectionString As String
Private _dpf As DbProviderFactory
Private Function GetDBProviderFactory() As DbProviderFactory
Return _dpf
End Function
#End Region
Public Sub New(ByVal ProviderName As String, ByVal ConnectionString As String)
_DBProviderName = ProviderName
_ConnectionString = ConnectionString
If DbProviderFactories.GetFactoryClasses.Select _
("InvariantName='" & _DBProviderName & "'").Length = 0 Then
Throw New Exception("Invalid .NET Data Provider specification: " & _DBProviderName)
Exit Sub
End If
_dpf = DbProviderFactories.GetFactory(_DBProviderName)
End Sub
Public Function GetDBConnection() As DbConnection
Dim dbConn As DbConnection = GetDBProviderFactory.CreateConnection
dbConn.ConnectionString = _ConnectionString
Return dbConn
End Function
Public Function GetDBCommand() As DbCommand
Dim dbCmd As DbCommand = GetDBProviderFactory.CreateCommand
dbCmd.Connection = GetDBConnection()
Return dbCmd
End Function
Public Function GetDBDataAdapter() As DbDataAdapter
Dim dbAdap As DbDataAdapter = GetDBProviderFactory.CreateDataAdapter
Return dbAdap
End Function
End Class
The next section gives you a complete explanation for the above code.
Next: Developing a common class which works with Factories: explanation >>
More ASP.NET Articles
More By Jagadish Chaterjee
