Understanding Multilayered Architecture in .NET

Introduction

This article focuses on understanding a basic multilayered architecture in C#.

The article starts with an introduction to one tier, two tier and n-tier architectures, their pros and cons, and later describes how to do a simple basic multilayered architecture in .Net.

My effort in this article will be to focus on next level programming in .Net for developing an enterprise application.

Layered Architecture

When the various components in a system are organized systematically we call it a system architecture. The architecture is the enterprise-scale division of a system into layers or tiers, each having responsibility for a major part of the system and with as little direct influence on other layers.

One, two, three and n-tier applications

There are plenty of ways for a system to be be split into multiple logical tiers.

One-tier applications

Single-tier applications are basically simple standalone programs.

It's not necessary to consider network communication and the risk of network failure

in these cases since they do not require network access.

Since all the data resides within the same application, these programs do not focus on synchronization of data. When separating the tiers physically the application is slower since the communication over the network will result in a loss of performance, therefore one-tier applications certainly have better performance.

Two-tier applications

A two-tier application, in comparison to the one-tier application as described, does not combine all functions into a single process but into separate functions. For example a chat application. This kind of application contains two separated tiers, client and a server.

The client has the responsibility of capturing user input and displaying the actual messages.

The server is responsible of the communication between the people that use the chat client.

Three-tier applications

A three-tier application adds another tier to the previous mentioned chat application, this could be in the form of a database. One could think of a three-tier application as a dynamic web application, which has a user interface, business logic, services and a database each placed in different tiers, as illustrated in Figure 1. As mentioned in the previous section a two-tier architecture separates the user interface from the business logic, in the same way the three tier architecture separates the database from the business logic.


Figure 1 - Three-tier application

N-tier applications

A logical n-tier application is an application where all logical parts are separated into discrete classes. In a typical business application, this generally involves a Presentation Layer, Business Logic Layer and a Data Access Layer. This separation makes the application easier to maintain. The advantages of this architecture are that all business rules are centralized that make them easy to create, use and re-use. The data access is also centralized, that has the same advantage as the centralization of the business rules. Centralizing the data access routines are also good when it comes to maintenance since changes must only be implemented in one location. There are really not that many disadvantages of this kind of architecture, however, it takes a bit longer to get up and running since several separate components need to be developed, that also might make the code a bit more complicated to grasp for less experienced developers.

A Practical Approach

Let's start developing a simple multilayered architecture in .Net. I use C# as my programming language, however the programming language is not a barrier at all, one can choose whatever the developer prefers. The architecture that we implement has the following design as mentioned in Figure 2. We will start creating the architecture for a web application, later it could be converted into a Windows application too.

We will make use of class libraries to physically separate our layers. Therefore one Web Application/Project, one Business Logic Layer class library, one Data Access Layer class library and one Common Layer class library can be included in the solution.

Let's follow the implementation step-by-step.



Figure 2.

Step 1: Add a Web Project (Presentation Layer).

Open your Visual Studio and add a simple website to the solution, name it Presentation Layer.



Your Development Environment may look like:



Our Presentation Layer is the Web application, that will be exposed to the end user.

The Web application includes Web Forms, in other words aspx pages and User Controls, in other words Ascx pages.

Scripts (client side JavaScripts), Styles (CSS and custom styles for styling the page), Master Page (.master extension, for providing common functionality to a group of desired pages, Configuration Files like web.config and app.config and so on).

Let's set up our next projects and define them in separate layers. Add three folders to your solution named BusinessLogicLayer, DataAccessLayer and CommonLayer. Your solution will look as in the following:



Step 2: Add a Business Logic Layer, Data Access Layer and Common Layer :

Right-click the Business Logic Layer folder and add a C# class library project to it, call it BLL.csproj.



Doing this will add a C# class library project to our solution in the Business Logic Layer Folder.

Likewise add two more projects to the Common Layer and DataAccessLayer folder respectively and call them Common.csproj and DAL.csproj projects.

The Data Access Layer Project Contains the entities classes and objects to communicate with the database, whereas our common project contains properties and helper classes to communicate with all the three layers commonly. It contains the objects to be ed to and from the Presentation Layer to the Data Access Layer commonly, and also acts as a mode of communication among the layers.

Now our solution looks as in the following:



Step 3: Create a database with a sample table and put some default values in it, for example I have created a database named "EkuBase" and created a simple Student table with the following fields, StudentId, Name, Email, Address, Age, Country. The Create script of the table is as follows:

USE [EkuBase]
GO

/****** Object: Table [dbo].[Student] Script Date: 12/24/2011 14:53:14 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Student](
[StudentID] [int] NOT NULL,
[Name] [nvarchar](50) NULL,
[Email] [nvarchar](50) NULL,
[Address] [nvarchar](50) NULL,
[Age] [int] NULL,
[Country] [nvarchar](50) NULL,
CONSTRAINT [PK_Student] PRIMARY KEY CLUSTERED
(
[StudentID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

Therefore making studentid as the primary key.

Step 4: Let's add classes to our projetcs, Add StudentBLL.cs, StudentDAL.cs, StudentEntity.cs to BLL, DAL and Common Layer respectively. Ensure you qualify them with logical namespaces, so that it's easy to recognize and use them.

BLL:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace BLL
{
public class StudentBLL
{
}
}

DAL:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace DAL
{
public class StudentDAL
{
}
}

Common:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Common
{
public class StudentEntity
{
}
}

Step 5: Add a Connection String to web.config and a Helper class to the DAL to interact with the database. In my case I am using SQL helper for ease.

Web.Config:
"
<connectionStrings>

<add name="Connections" connectionString="Data Source=69B5ZR1\SQLEXPRESS;Initial Catalog=EkuBase;Persist Security Info=True;User ID=akhil;word=akhil" providerName="System.Data.SqlClient"/>

</connectionStrings>

And define the Connection String in your SQL Helper so that you don't need to again and again create a connection and it to your method when you interact with the database.

public static readonly string CONN_STRING = ConfigurationManager.ConnectionStrings["Connections"].ConnectionString;

Add a reference to System.Configuration to the DAL project before reading the preceding connection string.

Step 6: Configure the solution and add DLLs to dependent layers

Since we need to separate the business logic, presentation and data access, and we want the Presentation Layer to neither directly interact with the database nor the business logic, we add a reference of the Business Logic Layer to our Presentation Layer and Data Access Layer to the Business Logic Layer and Common Layer to all the three layers. To do that, add a common DLL folder to the physical location of the solution and give the build path of all the three class projects to that DLL folder, doing this we can directly get access to the DLLs of all the layers to the layers needed for that DLL. We'll get the DLLs in that folder once we complete our project.







Figure 8

Do this for the DAL and the Common Layer as shown in Figure 8. After compiling all the projects we get the DLLs in the DLL folder created.



Now add a reference of Common.dll and BLL.dll to the Presentation Layer, Common.dll and DAL.dll to the BLL Layer and

Common.dll to the DAL layer and compile your solution.

Now the code of the BLL is accessible to the Presentation Layer and the DAL is accessible to the BLL and Common is accessible to all three layers.

Step 7: Write methods to get the flow.

Now we need to write some code to our layers to get the feel of the flow among all the layers. Let's create a scenario. Suppose we need to get the details of all the students whose student id is less than 5. For that add some sample data to your Student table, about 7 rows would work (Figure 11) and add a GridView to Default.aspx in the Presentation Layer to show the data.



Figure 11

Default.aspx:

<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
CodeFile="Default.aspx.cs" Inherits="_Default" %>

<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
<h2>
Welcome to ASP.NET!
</h2>
<p>
To learn more about ASP.NET visit <a href="http://www.asp.net" title="ASP.NET Website">www.asp.net</a>.
</p>
<p>
You can also find <a href="http://go.microsoft.com/fwlink/?LinkID=152368&clcid=0x409"
title="MSDN ASP.NET Docs">documentation on ASP.NET at MSDN</a>.
</p>
<div>
<asp:GridView runat ="server" ID="grdStudent"></asp:GridView>
</div>
<div>
<asp:Label runat="server" ID="lblError" Font-Bold=true ForeColor=red ></asp:Label>
</div>

</asp:Content>