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?

Can you share it with me?

"Mark Rae [MVP]" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> "Cirene" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>
>> I am creating a DAL for my web application.
>
> That's good.
>
>> Generally, should the code in the DAL be kept generic so that it can be
>> used in future projects, such as ExecuteStoredProcedure, or ExecuteSQL?
>
> Yes, IMO.
>
>> Or is it better to put in the DAL any code that is "data related", such
>> as GetCustomer, DeleteProduct, ComparePrices, etc...
>
> No, IMO.
>
> My DAL can be dropped unmodified into any new project, whether WebForms or
> WinForms, and currently supports several RDBMS...
>
> --
> Mark Rae
> ASP.NET MVP
> http://www.markrae.net

"Mark Rae [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> "Cirene" <(E-Mail Removed)> wrote in message [please stop top-posting]
>

Sorry

>>> My DAL can be dropped unmodified into any new project, whether WebForms
>>> or WinForms, and currently supports several RDBMS...
>>
>> Can you share it with me?
>
> No.

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

"Mark Rae [MVP]" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> "Cirene" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>
>> I'm wondering if there is a nice community driven, flexible DAL (like the
>> one you have created.) Do you know of such?
>
> http://www.microsoft.com/downloads/d...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.