473,320 Members | 2,012 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

DataBase Centric Applications - Best Approach

I've just spent some considerable time putting together an application which
works pretty much OK. The issue I have around design is mainly concerned
with the Data Access layer.

Yes, we can pull data modify it etc, but the code required to do so is not
inconsequential, and the many functions one finds onself writing do mount
up.

All this is OK until you find you need to change a type or add or remove a
field, everything has to change and its a nightmare to have to retrofit your
code to remedy that.

So Im sitting here thinking that there must be a scalable flexible way to
approach the design to minimise this rework. Does anyone have any ideas,
URLS's etc that may be of help, or even a few words of advice.
Thanks Mr N
Nov 23 '05 #1
2 1188

"Mr Newbie" <he**@now.com> wrote in message
news:u8**************@TK2MSFTNGP11.phx.gbl...
I've just spent some considerable time putting together an application
which works pretty much OK. The issue I have around design is mainly
concerned with the Data Access layer.

Yes, we can pull data modify it etc, but the code required to do so is not
inconsequential, and the many functions one finds onself writing do mount
up.

All this is OK until you find you need to change a type or add or remove a
field, everything has to change and its a nightmare to have to retrofit
your code to remedy that.

So Im sitting here thinking that there must be a scalable flexible way to
approach the design to minimise this rework. Does anyone have any ideas,
URLS's etc that may be of help, or even a few words of advice.


Here are a few good options:

DataSets and the Visual Studio Designers, especially in VS2005, where
TableAdapters manage your CRUD commands as well as your Typed Datasets.

Custom DAL, with Command Wrappers and Entity Types, using codegen (eg
http://www.codesmithtools.com/) to generate allthe boilerplate code for you.
This is essentially what you're doing, just with the addition of a codegen
tool to automate it.

ORM solutions (http://search.msn.com/results.aspx?q=.net+orm&FORM=QBHP,
http://www.nhibernate.org). These move the action into the client tier and
handle the database plumbing behind the scenes.


David
Nov 23 '05 #2
I'll take a look at these options and see how they might be of help.

Thanks for your help.

--
Best Regards

The Inimitable Mr Newbie º¿º

"David Browne" <davidbaxterbrowne no potted me**@hotmail.com> wrote in
message news:%2******************@TK2MSFTNGP10.phx.gbl...

"Mr Newbie" <he**@now.com> wrote in message
news:u8**************@TK2MSFTNGP11.phx.gbl...
I've just spent some considerable time putting together an application
which works pretty much OK. The issue I have around design is mainly
concerned with the Data Access layer.

Yes, we can pull data modify it etc, but the code required to do so is
not inconsequential, and the many functions one finds onself writing do
mount up.

All this is OK until you find you need to change a type or add or remove
a field, everything has to change and its a nightmare to have to retrofit
your code to remedy that.

So Im sitting here thinking that there must be a scalable flexible way to
approach the design to minimise this rework. Does anyone have any ideas,
URLS's etc that may be of help, or even a few words of advice.


Here are a few good options:

DataSets and the Visual Studio Designers, especially in VS2005, where
TableAdapters manage your CRUD commands as well as your Typed Datasets.

Custom DAL, with Command Wrappers and Entity Types, using codegen (eg
http://www.codesmithtools.com/) to generate allthe boilerplate code for
you. This is essentially what you're doing, just with the addition of a
codegen tool to automate it.

ORM solutions (http://search.msn.com/results.aspx?q=.net+orm&FORM=QBHP,
http://www.nhibernate.org). These move the action into the client tier
and handle the database plumbing behind the scenes.


David

Nov 23 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

23
by: ajikoe | last post by:
Hello I need to build table which need searching data which needs more power then dictionary or list in python, can anyone help me what kind of database suitable for python light and easy to learn....
2
by: Josh McFarlane | last post by:
If this is not the right place to post this, I apologize. I've taken over work for a few utility programs for a collection of database / raw files. All the programs but one read from the files,...
346
by: rkusenet | last post by:
http://biz.yahoo.com/rc/040526/tech_database_marketshare_1.html Interesting to see that database sales for windows is more than Unix.
3
by: Alan | last post by:
I am coming from other programming tools field, and new to VB .NET. Just wondering what is the common approaching in database programming in VB .NET? 1) Are you guru always using the data aware...
29
by: MP | last post by:
Greets, context: vb6/ado/.mdb/jet 4.0 (no access)/sql beginning learner, first database, planning stages (I think the underlying question here is whether to normalize or not to normalize this...
6
by: bbcrock | last post by:
Unfortunately my users are demanding this functionality: They are on a form. Click on an "add" button. An html window pops up. They add a new item that is saved to the database. The window...
1
by: | last post by:
Hi. This is a a semi-newbie question about how to store arbitrary information about my apps such that I can code quickly, mimizing complexity and the number of things I have to hold in my brain. I...
11
by: Josetta | last post by:
I searched around a little bit, but didn't come up with the answer to this question, but somewhere in the back of my mind, I think this can be done... Let's say we have two different company...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.