Data Access Layer Question

[Cirene]

I am creating a DAL for my web application. Generally, should the code in
the DAL be kept generic so that it can be used in future projects, such as
ExecuteStoredProcedure, or ExecuteSQL?

Or is it better to put in the DAL any code that is "data related", such as
GetCustomer, DeleteProduct, ComparePrices, etc...

What is your opinion?

 

[Cirene]

Can you share it with me?

That's good.


Yes, IMO.


No, IMO.

My DAL can be dropped unmodified into any new project, whether WebForms or
WinForms, and currently supports several RDBMS...

 

[Cirene]

Sorry


No.

I'm wondering if there is a nice community driven, flexible DAL (like the
one you have created.) Do you know of such?

 

[Cirene]

http://www.microsoft.com/downloads/...63-708F-4280-8F0C-637481C31718&displaylang=en

Thanks Mark! Do you know if this works with VS 2008 and .NET FW 3.5? It
doesn't list it in the System Requirements.