A Wrapper Class for the SQL Server Based Data Access Helper - Getting a single row or single value from the data access helper
(Page 2 of 7 )
The following is the wrapper method used to access the data access helper method. It is used mainly to retrieve a single row:
PublicFunction getDataRow(ByVal sqlSELECT As String) As System.Data.DataRow
Try
ObjLib = getDBHelperObject()
Return ObjLib.getDataRow(sqlSELECT)
ElseReturn dt.Rows(0)
Catch ex As Exception
Throw ex
Finally
Try
System.EnterpriseServices.ServicedComponent.DisposeObject(ObjLib)
Catch ex As Exception
End Try
End Try
End Function
The following is the wrapper method used to retrieve a single value:
Public Function getRowValue(ByVal sqlSELECT As String) As String
Try
ObjLib = getDBHelperObject()
Return ObjLib.getRowValue(sqlSELECT)
Catch ex As Exception
Throw ex
Finally
Try
System.EnterpriseServices.ServicedComponent.DisposeObject(ObjLib)
Catch ex As Exception
End Try
End Try
End Function
You can observe that I am creating an object of the data helper type in “getDBHelperObject.” I also need to dispose of the same when not in use. If you don’t dispose of it, it will not be released and it will never return back to the pool. To make the pool always reusable, you need to dispose of the COM+ object immediately after finishing your work.
You can also increase the size of the pool by modifying the attribute value given in previous articles.
Next: Getting multiple rows using wrapper methods from the data access helper >>
More MS SQL Server Articles
More By Jagadish Chaterjee
