3 tire Architechture

Pranjal Mishra

13y4.3kLearn iOS Programming

can anyone explain 3 Tire architechture with exampl(Insert Data in sql database)

where 1)Presentation Layer

2)Bussiness lagic layer

3)Data access layer

Helper class to declare properties.

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rohatash Kumar13y ago
Pranjal,

Presentation Layer (UI)

Presentation layer contains pages like .aspx or windows form where data is presented to the user or input is taken from the user.

Business Access Layer (BAL) or Business Logic Layer

BAL(Business Access Layer) contains business logic, validations or calculations related with the data, if needed. I will call it Business Access Layer in my demo.

Data Access Layer (DAL)

DAL(Data Access Layer) contains methods that helps business layer to connect the data and perform required action, might be returning data or manipulating data (insert, update, delete etc). For this demo application, I have taken a very simple example. I am assuming that I have to play with record of persons (First Name, Last Name, and Age) and I will refer only these data throughout this article.
0
Shankar M13y ago
Hi Mishra,

Please view this link, this explains you clearly with each of these layers.

http://www.codeproject.com/Articles/36847/Three-Layer-Architecture-in-C-NET

Happy Learning..
0
Vishnujeet Kumar13y ago
you can try this article .
http://www.dotnetfunda.com/articles/article71.aspx
0
Pranjal Mishra13y ago
still the same .

Do u think that,this might be because of reference problem?
0
Pradip Pandey13y ago
Use this

ConnectionString connectionstring = ConfigurationManager.ConnectionStrings["connection"];
SqlConnection conn = new SqlConnection(connectionString);
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = conn;
sqlCmd.Connection.Open();

Hope it will help.
0
Pranjal Mishra13y ago
when im writing code i dal i m getting error.That configurationManager does not exist in current contest
below is my code,can u tell me whats the prob.
I have included usng system.Configuration.

just because ofthisim getting stuck up.

using System;
using System.Collections.Generic;
//using System.Configuration.Assemblies;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Text;
using Helperclass;

namespace DataAccessLayer
{
public class DAL
{
string str = configurationmanager.CollectionStrings[""].Tostrings();
SqlConnection con = new SqlConnection(str);
con.Open();

}
}
0
Satyapriya Nayak13y ago
http://www.c-sharpcorner.com/uploadfile/hgvyas123/3-tier-architecture/default.aspx
0