Shared functions in DAL

[milop]

Hello.

I'm using a three tiered architecture (UI, BLL, DAL) in an ASP.Net
application.

The functions in the DAL are shared functions, while the BLL's are not.

What are the ramifications, if any, of using Shared functions in the DAL?

Is there an exposure of "data sharing" from the DAL to the BLL?

Thanks in advance,

Mike

 

[Mr. Arnold]

Hello.

I'm using a three tiered architecture (UI, BLL, DAL) in an ASP.Net
application.

The functions in the DAL are shared functions, while the BLL's are not.

What are the ramifications, if any, of using Shared functions in the DAL?

Is there an exposure of "data sharing" from the DAL to the BLL?

Thanks in advance,

Can you give an example of this shared function you are talking about?

 

[sloan]

I would LOOK AT the source code for the older DAAB block.


http://www.microsoft.com/downloads/...0a-9877-4a7b-88ec-0426b48df275&displaylang=en


IIRC, it used static (shared in vb.net) methods. But I'm going by memory.


Note, EnterpriseLibrary.Data is the "successor" for the DAAB 2.0.


Find the LoadDataSet method for example. What I'm getting at is that if
that code is static, you're probably ok.

HOWEVER, you should post some code...............

 

[milop]

Public Shared Function GetSomeData(ByVal InputField As Int32) As
DataTable
Try
Using cn As New
iDB2Connection(ConfigurationManager.ConnectionStrings("iSeries").ConnectionString)
Using cm As New iDB2Command
cm.CommandText = "GetSomeData"
cm.CommandType = CommandType.StoredProcedure
cn.Open()
cm.Connection = cn
cm.DeriveParameters()
cm.Parameters("@InputField").Value = InputField
Dim dt as New DataTable()
Using da as New IDB2DataAdapter(cm)
da.Fill(dt)
End Using
ThrowException(cm, Nothing) ' Custom method that
examines returned error info.
Return dt
End Using
End Using

Catch Critical As CriticalException
Throw

Catch Severe As SevereException
Throw

Catch Warning As WarningException
Throw

Catch ex As Exception
SupportEmail.SendEmail("Exception caught in blah, blah,
blah", ex.ToString())
Throw New CriticalException()

End Try
End Function

 

[milop]

You're right, and I have the Enterprise Library installed. I'll have a look.

I posted some code in response to Mr. Arnold's response.

Thanks, Sloan.