Recently, I posted a 5-part article about developing a 3-tier architecture using ADO.NET. In this post, I am going to mention how to develop such an architecture using Linq to Sql. Since the last article was too long, I am going to make this one short. Therefore, the architecture is not changed and [...]
Posts Tagged ‘3-TIER’
A 3-Tier Architecture with LINQ TO SQL
Posted in Architecture, C#, tagged 3-TIER, Architecture, BUSINESS LAYER, COMMON LAYER, DATA ACCESS LAYER, LAYER, Linq, Linq to sql, N-TIER, SQL on July 28, 2008 | 5 Comments »
Implementing a 3-Tier architecture with C# – Part 5
Posted in ADO.NET, ASP.NET, Architecture, C#, tagged 3-TIER, 3Tier, ADO.NET, APPLY, Architecture, ASP.NET, ATTRIBUTE, BUSINESS, BUSINESS CHECK, COMPLETE, CUSTOM, DATA ACCESS, grid view, IMPLEMENT, LAYER, LAYERED, maximumRowCount, N-TIER, NTier, object data source, ObjectDataSource, presentation, startRowIndex, SYSTEM, TRANSACTION, TRANSACTION SCOPE, UI on July 22, 2008 | 3 Comments »
Hi back,
In this post we will finalize the implementation of our 3-tier asp.net architecture, by developing a Web-based presentation layer.
So far, we have developed the data access and business layers. The implementation of UI, consists of methods and approaches for handling business and crud operations thorough a Web UI. In fact, there are several ways [...]
Implementing a 3-Tier architecture with C# – Part 4
Posted in ADO.NET, ASP.NET, Architecture, C#, tagged 3-TIER, 3Tier, ADO.NET, APPLY, Architecture, ASP.NET, ATTRIBUTE, BUSINESS, BUSINESS CHECK, COMPLETE, CUSTOM, DATA ACCESS, IMPLEMENT, LAYER, LAYERED, N-TIER, NTier, SYSTEM, TRANSACTION, TRANSACTION SCOPE on July 18, 2008 | 2 Comments »
Up to now, we have finished implementing the data access layer. However, we can reduce the dependency between the deriver DAL classes and Web.config file. As you remember, we have specified the DB provider name in Web.config file so that DAL classes must have access to this file to read the provider name. Another method [...]
Implementing a 3-Tier architecture with C# – Part 3
Posted in ADO.NET, ASP.NET, Architecture, C#, SQL SERVER, tagged 3-TIER, 3Tier, ADO.NET, Architecture, ASP.NET, C#, FirstReturnedRecord, IDENTITY, N-TIER, NTier, PAGING, ROW_NUMBER, SCOPE_IDENTITY, SQL SERVER, SQL SERVER 2005, StoredProcedure, TIER, UpdateRowSource on July 15, 2008 | Leave a Comment »
The Fill method we have developed so far, executes the Select command on the underlaying server and picks up RowCount records from startRowIndex position. For example, if Select * from Person returnS 20 rows, and startRowIndex is 0, only the first RowCount records will be fetched. This means that the complete result set will be [...]
Implementing a 3-Tier architecture with C# – Part 2
Posted in ADO.NET, ASP.NET, Architecture, C#, tagged 3-TIER, 3Tier, ADO.NET, Architecture, ASP.NET, C#, DbCommand, DbConnection, DbDataAdapter, dbProvider, DbProviderFactory, N-TIER, NTier, System.Data.Common on July 14, 2008 | 3 Comments »
Hi again,
Let’s keep on going and work on the Data Access Layer. The DAL layer we are going to design can be used with, theoretically, any sort of RDBMS because it will take advantage of ADO.NET generic classes. For this reason, I have written a base class for DAL classes and have placed in [...]
Implementing a 3-Tier architecture with C# – Part 1
Posted in ADO.NET, ASP.NET, Architecture, C#, tagged 3-TIER, ADO.NET, Architecture, ASP.NET, BUSINESS LAYER, COMMON LAYER, DATA ACCESS LAYER, DATASET, DataTable, DECIPLINE, ENTITY, N-TIER, OOD, TYPED on July 12, 2008 | 6 Comments »
Hi again,
Nearly two years a go I probed Internet to find out a good reference architecture for my ASP.NET applications. What I meant GOOD ARCHITECTURE was an architecture that:
IS FAIRLY SIMPLE
IS BASED ON N-TIED ARCHITECTURE
IS PRODUCTIVE
IS EASY TO IMPLEMENT
DOES NOT NEED A NY 3rd PARTY CLASSES (I.E. NHIBERNATE)
CAN BE USED FOR A WIDE RANGE [...]
