Designing and Implementing A Versatile Data Access Tier For An ASP.NET Application

0.Abstract

In this article, we will drill down deeper into the design of a n-tier architecture and our focus will be on thedata access tier(DAT) (Figure 0).Our goal is to design and implement anappropriate data access tier(DAT) for scalable, reliable andinteroperable web application. I have divided this article in to twomajor parts. In the first part , we will discuss about architecturalgoals, typed DataSet, EventLogs and HttpModules , which are helpful tounderstand the second part of this article . We will build in thesecond part a small(but fine) n-tier application and our focus will beon design and implementation of data access tier. You need a SqlServer(database: Northwind) and VS.net to follow this article.

Contents:
1. Designing Goals of a data access tier(DAT)
1.1Architectural Goals
1.2Installation of the prototype
1.3Typed DataSets
1.4Event Logs
1.5HttpModules
2.0 Implementing versatile data access tier(DAT)
2.1 Implemeting a super class for data access tier.
2.2 A performance test to evaluate SqlDataReader and DataSet objects in the business tier.
2.3 How can I extend this data access tier (DAT) to access multi-databases.
2.4 How can I apply database transactions with different isolation level?
2.5 How can I insert and retrieve images?