What is the architecture

Question

0.00/5 (No votes)

See more:

.NET3.5

Hi,

I am new to web development. Read about n tier architecture and have a very basic doubt. My project uses SQL Server with stored procedures and sql functions to access the data. The code for accessing these stored procedures and functions and the business logic are combined into a single dll. The aspx code behind calls the dll. Is this a 3 tier or 2 tier architecture? Since we are using stored procedures , what would be the advantages of having a separate DB access layer. Will having a separate DB access layer improve the performance?

Kavya

Posted 22-Jan-12 19:58pm

Member 8588833

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 1 · 2012-01-22T21:00:00

The senario you explained is of 2-tier architecture.

If the business logic is separated then it is 3-tier one.

"what would be the advantages of having a separate DB access layer"

It will surely make your application reusable and very much simple for others who will work on your project.

Sometimes you require the same procedure to call at different pages, for that you can directly go to that layer and search for that procedure and reuse that.

Suppose you need to do certain changes to the coding in the procedure or you added new parameter to the procedure, then you will just have to add some codings to the existing function calling the procedure in that layer;

But suppose if you don't have the layer, it will be difficult for you to search everywhere in the project whereever the procedure is used and need to do the changes in coding at many places.

So, it simply lessens your future modifications and adds value to maintainance...

MingyiWang · Answer 2 · 2012-01-22T20:29:00

Solution 1

Design pattern can't improve the performance.But it's stronger.

Posted 22-Jan-12 20:29pm

MingyiWang

Comments

Sergey Alexandrovich Kryukov 23-Jan-12 3:16am

Huh?
--SA