ADO.NET and ADO Examples and Best Practices for VB Programmers, 2/e
暫譯: VB 程式設計師的 ADO.NET 與 ADO 範例及最佳實踐（第二版）

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.

Contents

Part One: ADO Classic

• 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

Part Two: ADO.NET and the .NET Framework

• 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

• Appendix A: Working with the Biblio Sample Database
• Appendix B: CompareCursorLocation Chart
• Appendix C: ADOc Dynamic Properties