Re: Another N-Tier Question

From: Richard Myers (fake_at_address.com)
Date: 10/14/04 

Date: Thu, 14 Oct 2004 17:39:30 +1300

I wouldn't use Access for any kind of ASP.Net application. Its an absolute
dog of an engine in multiuser environments.
You're setting yourself up for some major performance headaches down the
road. You want to be looking forwards not backwards.
Check out SQL Server 2005 Express edition. Its free and replaces good old
MSDE. XCopy deploy/GUI tools the whole 9 yards.

Of course you may have to ask your ISP, assuming you use an ISP, when they
plan to support it etc but if your only in the design phase now
then stop and reassess that decision to use A2K for ASP.Net. If its an
intranet app, i'd be in boots and all on 2005.

As for nTier partitioning: simply put if you cant switch from A2K to SQL
Server without breaking your app you have too much/too little in your
DAL/middle tier.
DALs only purpose is too put the data in and pull the data out. Its middle
tiers job to shake it all about. If you've never done it before then just do
what you think, maybe you'll *** it up a little but thats generally the
best way to learn. Textbooks will teach you the how, experience will teach
you the why?

Just make sure you implement a good messaging system to communicate error
handling/logging etc.
Its really quite straight forward.

Richard