Solved

architecture style question

Posted on 2007-12-05
4
228 Views
Last Modified: 2013-11-07
Hi Guys,

A three tier archetecture involves a seperation of the presentation layer, the business logic and the database server.  

Currently, I on my web sites, I have only simple code on the web forms to accept and verify input data from the users.  I then seperate all of the business logic into classes that that execute like minded algorithims, and store like minded private data variables.  However, instead of using stored procedures, I just embed the sql in the classes to hit the database server.

Would this be considered a two tier type of architecture?

Any input is appreciated.

Thanks,

Ryan
0
Comment
Question by:dchau12
  • 2
  • 2
4 Comments
 
LVL 25

Expert Comment

by:imitchie
Comment Utility
To me, that is still one tier - in that everything sits in your one application! But everyone has a different view on it.
Internally, since you embed SQL into your app, it's inherently married to the database server - there goes 1 tier.
At a stretch you can call it 2-tier
0
 

Author Comment

by:dchau12
Comment Utility
So, if I used stored procedures, you would consider it two tier?  How could I then make it into a three tier app?
0
 
LVL 25

Accepted Solution

by:
imitchie earned 500 total points
Comment Utility
Using stored procedures means that the Business layer is moved (mostly) to the DB server. That is very clearly a different tier whether internally or externally.  The handover point is the Stored procedure parameters.
As for separation between presentation and model, you've already done that - as long as the input forms do nothing more than capture, and forward on to "model" classes.  i.e. you don't have all sorts of non-view/input capture related code in the forms.
0
 

Author Closing Comment

by:dchau12
Comment Utility
Thanks.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

This article describes relatively difficult and non-obvious issues that are likely to arise when creating COM class in Visual Studio and deploying it by professional MSI-authoring tools. It is assumed that the reader is already familiar with the cla…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now