September 5th, 2008, 05:45 AM
| | |  Data Access Layer Question
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?
|
September 5th, 2008, 09:15 AM
| | | Re: Data Access Layer Question
"Cirene" <cirene@nowhere.comwrote in message
news:ONylhGxDJHA.1180@TK2MSFTNGP04.phx.gbl... Quote: |
I am creating a DAL for my web application.
| That's good. Quote:
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. Quote:
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 |
September 6th, 2008, 02:45 AM
| | | Re: Data Access Layer Question
Can you share it with me? :)
"Mark Rae [MVP]" <mark@markNOSPAMrae.netwrote in message
news:%23v0Lf5yDJHA.3484@TK2MSFTNGP05.phx.gbl... Quote:
"Cirene" <cirene@nowhere.comwrote in message
news:ONylhGxDJHA.1180@TK2MSFTNGP04.phx.gbl...
> Quote: |
>I am creating a DAL for my web application.
| >
That's good.
> Quote:
>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.
> Quote:
>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 | |
September 6th, 2008, 03:35 AM
| | | Re: Data Access Layer Question
"Cirene" <cirene@nowhere.comwrote in message
news:OoBdNE8DJHA.4492@TK2MSFTNGP05.phx.gbl...
[please stop top-posting] Quote: Quote:
>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.
--
Mark Rae
ASP.NET MVP http://www.markrae.net |
September 6th, 2008, 03:35 PM
| | | Re: Data Access Layer Question
"Mark Rae [MVP]" <mark@markNOSPAMrae.netwrote in message
news:OrB03e8DJHA.4492@TK2MSFTNGP05.phx.gbl... Quote:
"Cirene" <cirene@nowhere.comwrote in message [please stop top-posting]
>
| Sorry Quote: Quote: Quote:
>>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? |
September 6th, 2008, 04:55 PM
| | | Re: Data Access Layer Question
"Cirene" <cirene@nowhere.comwrote in message
news:uiUJqzCEJHA.2072@TK2MSFTNGP04.phx.gbl... Quote:
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
--
Mark Rae
ASP.NET MVP http://www.markrae.net |
September 6th, 2008, 06:05 PM
| | | Re: Data Access Layer Question
"Mark Rae [MVP]" <mark@markNOSPAMrae.netwrote in message
news:%230z5xeDEJHA.612@TK2MSFTNGP06.phx.gbl... Quote:
"Cirene" <cirene@nowhere.comwrote in message
news:uiUJqzCEJHA.2072@TK2MSFTNGP04.phx.gbl...
> Quote:
>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. |
September 7th, 2008, 12:45 AM
| | | Re: Data Access Layer Question
"Cirene" <cirene@nowhere.comwrote in message
news:e6y%23AIEEJHA.3844@TK2MSFTNGP05.phx.gbl... Quote: >
Do you know if this works with VS 2008 and .NET FW 3.5?
| Yes it does.
--
Mark Rae
ASP.NET MVP http://www.markrae.net |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is Off | | |
| | | What is Bytes?
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over network members.
|
