Click here to Skip to main content
11,480,031 members (65,185 online)
Click here to Skip to main content

Tagged as

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

, 25 Dec 2011 CPOL 51.2K 31
Rate this:
Please Sign up or sign in to vote.
N-Tier
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)
   {
      try
      {
         SQLConnection sqlcon = new SQLConnection(ConfigurationManager
                                                      .ConnectionStrings["myDB"]
                                                      .ConnectionString);
         SQLCommand sqlcmd = new SQLCommand("SELECT age FROM Person_tb WHERE
                               firstname=@firstname AND lastname=@lastname",
                               sqlconn);
         sqlcmd.CommandType = CommandType.CommandText;
         sqlcmd.Parameters.AddWithValue("@firstname", firstname);
         sqlcmd.Parameters.AddWithValue("@lastname", lastname);
         sqlcon.Open();
         int retval = (int)sqlcmd.ExecuteScalar();
      }
      catch(Exception ex)
      {
         //Log ex
      }
      finally
      { 
         sqlcmd.Dispose();
         sqlcon.Close();
         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. Smile | :)

License

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

Share

About the Author


Comments and Discussions

 
GeneralReason for my vote of 5 A practical example I needed to unde... Pin
Marius Coetzee5-Dec-11 18:40
memberMarius Coetzee5-Dec-11 18:40 
GeneralRe: thanks! Pin
Eduard Lu5-Dec-11 21:31
memberEduard Lu5-Dec-11 21:31 
GeneralReason for my vote of 5 exactly what i am looking for! thank... Pin
Aja wakim1-Dec-11 17:38
memberAja wakim1-Dec-11 17:38 
GeneralRe: thanks aja Pin
Eduard Lu1-Dec-11 17:44
memberEduard Lu1-Dec-11 17:44 
GeneralOne question, what's the reason to implementing a BLL? You c... Pin
monolicciolo30-Nov-11 22:38
membermonolicciolo30-Nov-11 22:38 
GeneralRe: you can put your validation inside the BLL before returning ... Pin
Eduard Lu30-Nov-11 22:47
memberEduard Lu30-Nov-11 22:47 
GeneralReason for my vote of 3 ok Pin
GanesanSenthilvel30-Nov-11 16:20
memberGanesanSenthilvel30-Nov-11 16:20 
GeneralReason for my vote of 5 Very nice... incredibly rudimentary,... Pin
BrianBissell30-Nov-11 7:54
memberBrianBissell30-Nov-11 7:54 
GeneralRe: Thanks brian Pin
Eduard Lu30-Nov-11 15:16
memberEduard Lu30-Nov-11 15:16 
GeneralReason for my vote of 1 :) Pin
Horváth Aladár30-Nov-11 0:05
memberHorváth Aladár30-Nov-11 0:05 
GeneralRe: FYI. 1 is bad, 5 is good. Considering that your comment is a... Pin
Marcus Kramer30-Nov-11 4:45
memberMarcus Kramer30-Nov-11 4:45 
GeneralRe: :) Pin
Eduard Lu30-Nov-11 15:15
memberEduard Lu30-Nov-11 15:15 
GeneralThat is really a a nice to understand example.could you plea... Pin
Yashar_Khan29-Nov-11 20:39
memberYashar_Khan29-Nov-11 20:39 
GeneralReason for my vote of 5 5 from me as well. Pin
Marcus Kramer29-Nov-11 11:03
memberMarcus Kramer29-Nov-11 11:03 
GeneralRe: thanks Marcus Pin
Eduard Lu29-Nov-11 20:57
memberEduard Lu29-Nov-11 20:57 
GeneralReason for my vote of 5 Straight to the point. Just the way... Pin
Sainey29-Nov-11 10:30
memberSainey29-Nov-11 10:30 
GeneralRe: thanks Sainey Pin
Eduard Lu29-Nov-11 20:57
memberEduard Lu29-Nov-11 20:57 
GeneralI second what Reiss has noted. This is a very good tip, but ... Pin
Marcus Kramer28-Nov-11 7:24
memberMarcus Kramer28-Nov-11 7:24 
GeneralRe: renamed. Thanks for the comments. Pin
Eduard Lu28-Nov-11 14:52
memberEduard Lu28-Nov-11 14:52 
General<b>Eduard Lu wrote:The best way to design your own applicati... Pin
Reiss28-Nov-11 0:37
memberReiss28-Nov-11 0:37 
QuestionBeginner article Pin
Sean Botha27-Dec-11 10:36
memberSean Botha27-Dec-11 10:36 
QuestionSimple and superb Pin
Suchi Banerjee, Pune29-Nov-11 15:34
memberSuchi Banerjee, Pune29-Nov-11 15:34 
AnswerRe: Simple and superb Pin
Eduard Lu30-Nov-11 15:20
memberEduard Lu30-Nov-11 15:20 

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

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

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