[Mono-list] Application Architecture
Timothy Parez
tpsoftware@users.sourceforge.net
Sat, 29 Nov 2003 23:50:07 +0100
This is a multi-part message in MIME format.
------=_NextPart_000_0005_01C3B6D3.84DC4A50
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello,
I have a question about application architecture and I figured this is =
as good a place as any to ask my question.
Currently I have a small database (29 Tables, 149 Columns in total) and =
now I want to write code to use the database.
The idea is to write a class library to access the code, so that I'm not =
bound to a specific user interface,
I guess this is a normal DAL component then. Now I've read some books on =
ADO.NET, and though all of them
give a very good insight on the inner workings and usage of ADO.NET they =
do not offer much information
about best practices or real life application design. They just throw =
some building blocks at the reader,
show off some small applications and that's it. So I'm asking your =
advice on how I should develop my DAL.
Where do I start, what are the things I need to keep in mind, etc...
I would also like to know about personal experience you may have had on =
the subject, problems you encountered and so on.
One thing I don't need is a link to another webpage explaining to me how =
to create a provider independant dal component,
I need advice on real life application development, not an ADO.NET =
tutorial :-)
I know this is a very 'global' question, and that there is no strait =
answer to my problem,
but that's why I would like to start this discussion, perhaps I can =
learn from your own experiences
Thank you.
Note: This message has been posted on the gotmono.com forum aswell.
=
(http://www.gotmono.com/cgi-bin/yabb/YaBB.pl?board=3DPROJECT;action=3Ddis=
play;num=3D1070146165;start=3D0)
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.545 / Virus Database: 339 - Release Date: 27/11/2003
------=_NextPart_000_0005_01C3B6D3.84DC4A50
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1276" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DCourier size=3D2>Hello,</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2></FONT> </DIV>
<DIV><FONT face=3DCourier size=3D2>I have a question about application =
architecture=20
and I figured this is as good a place as any to ask my =
question.</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>Currently I have a small database (29 =
Tables, 149=20
Columns in total) and now I want to write code to use the =
database.</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2></FONT> </DIV>
<DIV><FONT face=3DCourier size=3D2>The idea is to write a class library =
to access=20
the code, so that I'm not bound to a specific user =
interface,</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>I guess this is a normal DAL =
component then. Now=20
I've read some books on ADO.NET, and though all of them</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>give a very good insight on the inner =
workings=20
and usage of ADO.NET they do not offer much information</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>about best practices or real life =
application=20
design. They just throw some building blocks at the reader,</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>show off some small applications and =
that's it.=20
So I'm asking your advice on how I should develop my DAL.</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2></FONT> </DIV>
<DIV><FONT face=3DCourier size=3D2>Where do I start, what are the things =
I need to=20
keep in mind, etc...</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2></FONT> </DIV>
<DIV><FONT face=3DCourier size=3D2>I would also like to know about =
personal=20
experience you may have had on the subject, problems you encountered and =
so=20
on.</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>One thing I don't need is a link to =
another=20
webpage explaining to me how to create a provider independant dal=20
component,</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>I need advice on real life =
application=20
development, not an ADO.NET tutorial :-)</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2></FONT> </DIV>
<DIV><FONT face=3DCourier size=3D2></FONT> </DIV>
<DIV><FONT face=3DCourier size=3D2>I know this is a very 'global' =
question, and that=20
there is no strait answer to my problem,</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>but that's why I would like to start =
this=20
discussion, perhaps I can learn from your own experiences</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2></FONT> </DIV>
<DIV><FONT face=3DCourier size=3D2></FONT> </DIV>
<DIV><FONT face=3DCourier size=3D2></FONT> </DIV>
<DIV><FONT face=3DCourier size=3D2>Thank you.</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2></FONT> </DIV>
<DIV><FONT face=3DCourier size=3D2></FONT> </DIV>
<DIV><FONT face=3DCourier size=3D2>Note: This message has been posted on =
the=20
gotmono.com forum aswell.</FONT></DIV>
<DIV><FONT face=3DCourier =
size=3D2> (<A=20
href=3D"http://www.gotmono.com/cgi-bin/yabb/YaBB.pl?board=3DPROJECT;actio=
n=3Ddisplay;num=3D1070146165;start=3D0">http://www.gotmono.com/cgi-bin/ya=
bb/YaBB.pl?board=3DPROJECT;action=3Ddisplay;num=3D1070146165;start=3D0</A=
>)</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2></FONT> </DIV>
<DIV><FONT face=3DCourier size=3D2></FONT> </DIV>
<DIV><FONT face=3DCourier size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2><BR>---<BR>Outgoing mail is certified =
Virus=20
Free.<BR>Checked by AVG anti-virus system (<A=20
href=3D"http://www.grisoft.com">http://www.grisoft.com</A>).<BR>Version: =
6.0.545 /=20
Virus Database: 339 - Release Date: =
27/11/2003</FONT></DIV></BODY></HTML>
------=_NextPart_000_0005_01C3B6D3.84DC4A50--