ADO.NET Examples and Best Practices for C# Programmers

The onset of the new .NET technology forces developers to completely rethink their data access strategies. All at once there is an entirely new language and a new set of data access interfaces to learn and incorporate into their designs. The purpose of this book is to make the choice and implementation of the best of those technologies far easier. It does this through working examples and numerous discussions of what works and what doesn’t. Vaughn's Best Practices are the techniques that developers need to know because they cause the least amount of overhead, problems and confusion–for the developer, the system and the team. While some are quite simple to implement, other Best Practices require considerable thought and forethought to enable. This is a developer’s book—full of hints, tips and notes passed on from those who show the medals and scars of battles won and lost.

Table of Contents

• Chapter 1: Introducing ADO.NET
• Chapter 2: ADO.NET — Getting Connected
• Chapter 3: ADO.NET Command Strategies
• Chapter 4: ADO.NET DataReader Strategies
• Chapter 5: Using the DataTable and DataSet
• Chapter 6: Filtering, Sorting, and Finding
• Chapter 7: ADO.NET Update Strategies
• Chapter 8: ADO.NET Constraint Strategies
• Chapter 9: ADO.NET Error Management Strategies
• Chapter 10: ADO.NET and XML