Written specifically for COM-based ADO developers retooling for ADO.NET using the C# language, this book brings fresh insights and tips on the ADO.NET technology. Veteran authors William Vaughn and Peter Blackburn have packed this formative guide with practical advice on how to write code that is both faster running and easier to understand.The onset of the new .NET technology is forcing developers to completely rethink their data access strategies. This book helps you to do this through working examples and numerous discussions of what works and what doesnt. Derived from years of experience working with data access developers, ADO.NET Examples and Best Practices for C# Programmers includes a set of techniques proven to drastically reduce overhead, problems, and confusionfor the devleoper, the system, and the entire team. While some are quite simple to implement, others require considerable forethought to enable. This is a developers bookfull of hints, tips and notes passed on from those whove spent significant time in the .NET and C# trenches.

Best-selling author Bill Vaughn gives practical advice that VB developers can use immediately to make their data access code faster and easier to write and understand. Completely updated and expanded from the first edition to include ADO.NET technology.

Working with ADO.- Introduction to ADO.- Creating ADO Objects.- Getting Connected.- ADO Command Strategies.- Recordset Strategies.- Manipulating Your Recordset.- Understanding Record and Stream Objects.- Passing Resultsets Between Layers.- Getting Your Data Into Shape.- Data Access Tips and Techniques.- ADO and The Visual Database Tools.- Introducing ADO .NET.- ADO .NET - Getting Connected.- ADO .NET Command Strategies.- ADO .NET DataReader Strategies.- Using the DataTable and DataSet.- Filtering, Sorting, and Finding.- ADO .NET Update Strategies.- ADO .NET Constraint Strategies.- ADO .NET Error Management Strategies.- ADO .NET and XML.- ADO .NET Performance Benchmarks.- Appendixes.