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

0.Abstract

In this article, we will drill down deeper in to the design of a n-tier architecture and our focus will be on the data access tier(DAT) (Figure 0).Our goal is to design and implement an appropriate data access tier(DAT) for scalable, reliable and interoperable web application. I have divided this article in to two major parts. In the first part , we will discuss about architectural goals, typed DataSet, EventLogs and HttpModules , which are helpful to understand the second part of this article . We will build in the second part a small(but fine) n-tier application and our focus will be on 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?

ARTICLE CONTINUED

Download DAPrototype.zip