Visual Basic developers are faced with a dizzying cornucopia of choices when it comes to data access paradigms. 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: Working with ADO
Chapter 2: Introduction to ADO
Chapter 3: Creating ADO Objects
Chapter 4: Getting Connected
Chapter 5: ADO Command Strategies
Chapter 6: Recordset Strategies
Chapter 7: Manipulating Your Recordset
Chapter 8: Understanding Record and Stream Objects
Chapter 9: Passing Resultsets Between Layers
Chapter 10: Getting Your Data Into Shape
Chapter 11: Data Access Tips and Techniques
Chapter 12: ADO and the Visual Database Tools
Chapter 13: Introducing ADO.NET
Chapter 14: ADO.NET -- Getting Connected
Chapter 15: ADO.NET Command Strategies
Chapter 16: ADO.NET DataReader Strategies
Chapter 17: Using the DataTable and DataSet
Chapter 18: Filtering, Sorting, and Finding
Chapter 19: ADO.NET Update Strategies
Chapter 20: ADO.NET Constraint Strategies
Chapter 21: ADO.NET Error Management Strategies
Chapter 22: ADO.NET and XML
Appendixes |
