Single Tier 2-Tier and 3-Tier Architecture in C#

Question

Sir I became tired of searching the .net architecture examples in web. I need your help in giving the link to see the .net architecture with examples. See the code below:- protected SqlConnection sqlCon; public frmRejectionIn() { InitializeComponent(); sqlCon = new SqlConnection(constring); } public void CashpartyComboFill() { try { if(sqlCon.State==ConnectionState.Closed) { sqlCon.Open(); } DataTable d = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(select * from tbl_AccountGroup sqlCon); da.Fill(d); cmbcashorParty.DataSource = d; cmbcashorParty.DisplayMember = ledgerName; cmbcashorParty.ValueMember = ledgerId; } catch (FileIoException) { throw; } } please tell me which architecture this code represent? could you give me the link to learn the difference between all types of architecture in .net with examples?

Sanjeeb Lenka · Answer

I think its in single tier if both the Database Nd application in same system. Difference between 1-tier/2-tier & 3-tier architecture are as follows: 1-Tier Architecture is the simplest single tier on single user and is the equivalent of running an application on a personal computer. All the required component to run the application are located within it. User interface business logic and data storage are all located on the same machine. They are the easiest to design but the least scalable. Because they are not part of a network they are useless for designing web applications. 2-Tier Architectures supply a basic network between a client and a server. For example the basic web model is a 2-Tier Architecture. A web browser makes a request from a web server which then processes the request and returns the desired response in this case web pages. This approach improves scalability and divides the user interface from the data layers. However it does not divide application layers so they can be utilized separately. This makes them difficult to update and not specialized. The entire application must be updated because layers aren't separated. 3-Tier Architecture is most commonly used to build web applications. In this model the browser acts like a client middleware or an application server contains the business logic and database servers handle data functions. This approach separates business logic from display and data.So the 3 layers commonly known as:Presentation Layer(PL/UI)Business Logic Layer(BLL) & Data Access Layer(DAL).

Pankaj Kumar · Answer

plz try this link... http://dotnetgeneralinfo.blogspot.in/2007/12/1tier-2-tier-3-tier-architecture.html

Muralidharan Deenathayalan · Answer

I don't think this code following any architecture may be you can say single layer / two tier architecture.(if db is in different server). In a layman approach Single Tier: The client application (windows form asp.net or mobile apps) business logic (web services) and database applications are present in the same system / server. Two Tier: The client application (windows form asp.net or mobile apps) and business logic (web services) are present in the same system / server and the database server in a different server. Three Tier: The client application (windows form asp.net or mobile apps) in a separate server and business logic (web services) is present in the different system / server and the database server in a different server. I hope you understand well.