Cenk Civici

The data access layer is a very important building block of data-centric applications. Any of today's well-designed architectures mandates having an abstraction layer over the data access library. In this article I will develop a class library that works like Microsoft Data Application Blocks to provide an easy-to-use and performant way to access MS SQL Server data sources. This class library implements interesting features such as caching of parameters, retrieving parameter information from SQL Server metadata tables, and making batch database calls. Building a Data Access Helper Component While developing a data-centric application you may find yourself replicating the data access code in your business logic components, which could lead to problems in terms of maintainability, code size, and variations in ADO.NET usage, not to mention the risk of introducing bugs. ... (more)