Writing a Data Access Layer (DAL) for SQL Server

Posted on SQL Server Central See other posts from SQL Server Central
Published on 2010/06/17 Indexed on 2010/06/17 6:04 UTC
Read the original article Hit count: 248

Filed under:
In this tip, I am going to show you how you can create a Data Access Layer (to store, retrieve and manage data in relational database) in ADO .NET. I will show how you can make it data provider independent, so that you don't have to re-write your data access layer if the data storage source changes and also you can reuse it in other applications that you develop.
SQL Backup Free trial of SQL Backup™
“SQL Backup was able to cut down my backup time
significantly AND achieved a 90% compression at
the same time!” Joe Cheng. Download a free trial now.

© SQL Server Central or respective owner