Links for .NET Data Abstraction
As a follow-up to my recent post about a simple .NET data abstraction class, here are some useful links I located while reading up on the subject. They are targeted to .NET, but the overall concepts would be the same for any other language, such as PHP or Java.
- Universal Data Access - MSDN shows how to construct a complete (or near-complete) data access layer, including a general factory class to generate appropriate objects for use.
- Implement a Data Access Layer for Your App with ADO.NET - An article on MSDN provides some good suggestions on abstracting data access.
- Implementing a Provider Independent Data Access Layer in .NET - Suggests using a factory class to generate the appropriate objects for the current database.
- Designing a Data Access Layer in .NET - Explains what a data access layer is, and describes a few features that should be present.
- Strategy for Building a Pluggable Data Access Layer in .NET - suggests how to create a data layer in such a way that you can seamlessly switch data providers.
- Creating a Data Access Layer in .NET - Part 1 - Part one of a tutorial that shows how to build a general DAL using Visual Studio. This part demonstrates setting up a database, and starting a web application using a DAL.
- Creating a Data Access Layer in .NET - Part 2 - The second part of the tutorial gets into code, and adds several bits of functionality. It is left as an exercise for the reader to take this project further!