Click here to Skip to main content
13,458,837 members
Click here to Skip to main content
Add your own
alternative version

Tagged as


31 bookmarked
Posted 27 Nov 2011

N-Tier: Begginer's guide in designing their application

, 25 Dec 2011
Rate this:
Please Sign up or sign in to vote.
A great way to design your own application is to use the N-tier architecture.

This is just a simple tip that I will share and it is for you to check out.

Note: The following layers are exposed as different projects under one solution.

Object Layer: Create a class with properties:
public class Person
   public string Firstname {get;set;}
   public string Lastname {get;set;}
   public int Age {get;set;}

Data Access Layer: The layer that interacts with database:

public sealed class PersonDAL
   Person person = new Person();
   public static int GetAge(string firstname, string lastname)
         SQLConnection sqlcon = new SQLConnection(ConfigurationManager
         SQLCommand sqlcmd = new SQLCommand("SELECT age FROM Person_tb WHERE
                               firstname=@firstname AND lastname=@lastname",
         sqlcmd.CommandType = CommandType.CommandText;
         sqlcmd.Parameters.AddWithValue("@firstname", firstname);
         sqlcmd.Parameters.AddWithValue("@lastname", lastname);
         int retval = (int)sqlcmd.ExecuteScalar();
      catch(Exception ex)
         //Log ex
         sqlcon = null;

Business Logic Layer: The layer that serves as bridge for DAL and Application Layer:

public sealed class PersonBLL
   public static int GetAge(string firstname, string lastname)
      return PersonDAL.GetAge(firstname, lastname);

Application/Presentation Layer: The layer where users input data:

Person person = new Person();
person.Firstname = "Eduard";
person.Lastname = "Lu";

string firstname = person.Firstname;
string lastname = person.Lastname;

txtAge.Text = PersonBLL.GetAge(firstname, lastname).ToString();

There are still a lot of ways to optimize this one. You can add more layers which your application might be needing. For example, add a Utilities Layer wherein you can place your configuration/settings and your error/transaction logger. In my example, you can create a function that will return the connection string for your application to communicate with your database server.

Also, creating stored procedure is better than using command text. In my example, I used command text just to show you my query.

Message me if you have concerns. :)


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


About the Author

You may also be interested in...


Comments and Discussions

General[My vote of 1] [My vote of 1] Pin
CelPlusPlus12-Sep-14 7:06
memberCelPlusPlus12-Sep-14 7:06 
QuestionThose aren't tiers Pin
PIEBALDconsult5-Apr-12 5:33
memberPIEBALDconsult5-Apr-12 5:33 
GeneralRe: thanks Reiss Pin
Eduard Lu28-Nov-11 22:00
memberEduard Lu28-Nov-11 22:00 
GeneralRe: Good article btw, now voted Pin
Reiss28-Nov-11 21:54
memberReiss28-Nov-11 21:54 
GeneralWe use this model exclusively, as highly detailed on Spaanja... Pin
EngleA20-Dec-11 5:06
memberEngleA20-Dec-11 5:06 
GeneralMVP! MVP! MVP! I just got going on my next customer's projec... Pin
chuckamus_prime20-Dec-11 3:22
memberchuckamus_prime20-Dec-11 3:22 
GeneralReason for my vote of 1 Short summary of the N-tier approach... Pin
DavidOwen19-Dec-11 18:59
memberDavidOwen19-Dec-11 18:59 
GeneralI wonder why the presentation layer should know about the bu... Pin
bradut8-Dec-11 7:46
memberbradut8-Dec-11 7:46 
GeneralReason for my vote of 5: Its precise and concise, should rea... Pin
Uday P.Singh5-Dec-11 20:43
memberUday P.Singh5-Dec-11 20:43 
GeneralRe: thanks! :) Pin
Eduard Lu5-Dec-11 20:45
memberEduard Lu5-Dec-11 20:45 
GeneralReason for my vote of 5 A practical example I needed to unde... Pin
Marius Coetzee5-Dec-11 17:40
memberMarius Coetzee5-Dec-11 17:40 
GeneralRe: thanks! Pin
Eduard Lu5-Dec-11 20:31
memberEduard Lu5-Dec-11 20:31 
GeneralReason for my vote of 5 exactly what i am looking for! thank... Pin
Aja wakim1-Dec-11 16:38
memberAja wakim1-Dec-11 16:38 
GeneralRe: thanks aja Pin
Eduard Lu1-Dec-11 16:44
memberEduard Lu1-Dec-11 16:44 
GeneralOne question, what's the reason to implementing a BLL? You c... Pin
monolicciolo30-Nov-11 21:38
membermonolicciolo30-Nov-11 21:38 
GeneralRe: you can put your validation inside the BLL before returning ... Pin
Eduard Lu30-Nov-11 21:47
memberEduard Lu30-Nov-11 21:47 
GeneralReason for my vote of 3 ok Pin
GanesanSenthilvel30-Nov-11 15:20
memberGanesanSenthilvel30-Nov-11 15:20 
GeneralReason for my vote of 5 Very nice... incredibly rudimentary,... Pin
BrianBissell30-Nov-11 6:54
memberBrianBissell30-Nov-11 6:54 
GeneralRe: Thanks brian Pin
Eduard Lu30-Nov-11 14:16
memberEduard Lu30-Nov-11 14:16 
GeneralReason for my vote of 1 :) Pin
Horváth Aladár29-Nov-11 23:05
memberHorváth Aladár29-Nov-11 23:05 
GeneralRe: FYI. 1 is bad, 5 is good. Considering that your comment is a... Pin
Marcus Kramer30-Nov-11 3:45
memberMarcus Kramer30-Nov-11 3:45 
GeneralRe: :) Pin
Eduard Lu30-Nov-11 14:15
memberEduard Lu30-Nov-11 14:15 
GeneralThat is really a a nice to understand example.could you plea... Pin
Yashar_Khan29-Nov-11 19:39
memberYashar_Khan29-Nov-11 19:39 
GeneralReason for my vote of 5 5 from me as well. Pin
Marcus Kramer29-Nov-11 10:03
memberMarcus Kramer29-Nov-11 10:03 
GeneralRe: thanks Marcus Pin
Eduard Lu29-Nov-11 19:57
memberEduard Lu29-Nov-11 19:57 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.180323.1 | Last Updated 25 Dec 2011
Article Copyright 2011 by Eduard Lu
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid