Visual Basic database 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.

• Author is widely regarded as the leading guru for Visual Basic database developers because of the success of the six editions of his book on Visual Basic and SQL Server.
  
• Author is one of the most popular speakers at key Visual Basic and SQL Server conferences worldwide.
  
• Author is widely published in industry trade journals.
  
• Author brings unique experience obtained at Microsoft and three decades in the computer industry.
  
• No-nonsense, clear and precise writing is Vaughn's hallmark

William R. Vaughn retired from Microsoft in August of 2000. He is currently the president of Beta V Corporation, devoted to providing comprehensive training and technical content to the Visual Basic data access developer community. He has taught, written, lectured, sold, supported, designed, coded, managed, and cried over mainframe and microcomputer systems and software for 30 years. He worked at Microsoft for 14 years where he held positions ranging from writing, teaching, and managing trainers at the Microsoft University (MSU) to being Visual Basic Enterprise Product Manager. During his last two years at Microsoft he worked with the Internal Technical Education group teaching Microsoft employees. While there he developed and taught courses on Visual Basic, data architectures, and ActiveX Data Objects (ADO).

Contents

Part One - ADO Classic

• 1. Working with ADO
• 2. Introduction to ADO
• 3. Creating ADO Objects
• 4. Getting Connected
• 5. ADO Command Strategies
• 6. Recordset Strategies
• 7. Manipulating Your Recordset
• 8. Understanding Record and Stream Objects
• 9. Passing Resultsets Between Layers
• 10. Getting Your Data into Shape
• 11. Data Access Tips and Techniques
• 12. ADO and The Visual Database Tools

Part Two - ADO.NET and the .NET Frameworks

• 13. Introducing ADO.NET
• 14. ADO.NET-Getting Connected
• 15. ADO.NET Command Strategies
• 16. ADO.NET DataReader Strategies
• 17. Using the DataTable and DataSet
• 18. Filtering, Sorting, and Finding
• 19. ADO.NET Update Strategies
• 20. ADO.NET Constraint Strategies
• 21. ADO.NET Error Management Strategies
• 22. ADO.NET and XML
• 23. ADO.NET Performance Benchmarks
• Appendixes