Designing Data Access Classes

After your base class has been created, you can move on to creating the actual data access classes that make up your data services tier. Once again, the purpose of the data access classes is to isolate the data access logic from the other tiers and provide a robust interface for manipulating the data in your application.

As you design and implement the classes, however, you'll run across several design issues that you must address. This section is designed to give you a feel for those issues and then show how you can abstract the .NET Data Provider used and implement a purely class-based approach in your data services tier, as mentioned on Day 15, “Using ADO.NET in a Multi-Tier Application.”

Design Issues

There are ...

Get Sams Teach Yourself ADO.NET in 21 Days now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.