Book Description

ADO.NET and ADO Examples and Best Practices for VB Programmers, Second Edition brings the popular first edition up to date with fresh insights and tips on COM-based ADO--and adds a voluminous section on the new ADO.NET technology. Written specifically for COM-based ADO developers retooling for ADO.NET, this is a developer's book, packed with practical advice on how to make code run faster, yet be easier to write and understand.

Veteran author William Vaughn guides you through the data access maze with working exapmles and numerous discussions of what works and what doesn't. Derived from years of experience working with data access developers, Vaughn's Best Practices are a set of techniques proven to drastically reduce overhead, problems, and confusion--for the devleoper, the system, and the entire team. While some are quite simple to implement, others require considerable knowledge and forethought to enable.
Download Description

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.

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