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?
7  876 
"Cirene" <ci****@nowhere.comwrote in message
news:ON**************@TK2MSFTNGP04.phx.gbl...
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
Can you share it with me? :)
"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:%2****************@TK2MSFTNGP05.phx.gbl...
"Cirene" <ci****@nowhere.comwrote in message
news:ON**************@TK2MSFTNGP04.phx.gbl...
>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
"Cirene" <ci****@nowhere.comwrote in message
news:Oo**************@TK2MSFTNGP05.phx.gbl...
[please stop top-posting]
>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
"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:Or**************@TK2MSFTNGP05.phx.gbl...
"Cirene" <ci****@nowhere.comwrote 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]" <ma**@markNOSPAMrae.netwrote in message
news:%2***************@TK2MSFTNGP06.phx.gbl...
"Cirene" <ci****@nowhere.comwrote in message
news:ui**************@TK2MSFTNGP04.phx.gbl...
>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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Hamed |
last post by:
Hello
I have employed as a developer in a software company that its team uses
FoxPro / VB 6.0 / VC++ 6.0 as the developing tools and newly is going to
migrate to VS.NET. There is a project...
|
by: sedefo |
last post by:
I ran into this Microsoft Patterns & Practices Enterprise Library while i
was researching how i can write a database independent data access layer. In
my company we already use Data Access...
|
by: Oyvind |
last post by:
I'm working on a Windows forms/C# database application. My background is
6-7 years of VB 4 - 6, MS Access, VC++, mixed in with a lot of T-SQL and MS
SQL Server in general and some OOA/OOD.
...
|
by: newbie |
last post by:
Hello,
If I have posted the question in the wrong group, I apologize.
I am building a windows application (in c#) that will be interacting
with an existing Access database. This database will...
|
by: Johann Blake |
last post by:
I am looking for a good solution on how to implement data access in an
application so that there is a clean separation between the data access
layer, the business layer and the GUI layer. I am...
|
by: headware |
last post by:
I'm relatively new to ASP.NET and ADO.NET, but I have a basic design
question regarding the use of web services and APS.NET applications.
Right now we have an application that uses web services to...
|
by: Demetri |
last post by:
I have a question / concern regarding the new suggested way of creating a
data access layer in an n-tier application. Typically, a web application
specifically, using the SOA (Service Oriented...
|
by: Tina |
last post by:
I'm reading about the "3-tier" design afforded by using Object Data Sources
in the App_Data folder in 2.0 asp.net projects.
To me, putting an object data source in a separate folder on the web...
|
by: pratham |
last post by:
Hi!
I'm making a database application and i heard from a friend that it is
more
proffecional and easy to do this with bussines objects. Can anyone tell
me
where i can find more info on bussines...
|
by: kbutterly |
last post by:
Good morning,
I have seen two different types of data access layers and I am
wondering which, if either, is considered best practice, or if one is
better suited to certain situations than the...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
