ADO.NET Examples and Best Practices for C# Programmers

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# Programmersincludes 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.

Table of Contents

1. Introducing ADO.NET
2. ADO.NET—Getting Connected
3. ADO.NET Command Strategies
4. ADO.NET DataReader Strategies
5. Using the DataTable and DataSet
6. Filtering, Sorting, and Finding
7. ADO.NET Update Strategies
8. ADO.NET Constraint Strategies
9. ADO.NET Exception Management Strategies
10. ADO.NET and XML

Peter D. Blackburn is chief executive officer of Boost Data Ltd., andchief technology officerof International Network Technologies Organization Ltd. Peter studied computer science at Cambridge University in England and has worked for the last 12 years as lead consultant developer on corporate and local government distributed database systems. He has led and trained teams working with nearly all the Microsoft data access technologies, in addition to having designed and implemented heavy-duty custom-built distributed client/server databases using open source D-ISAM on UNIX platforms.

William (Bill) Vaughn is an industry-recognized author, mentor and subject-matter expert. He's been in the computer industry for over 30 years—he's worked with mainframe, minicomputer, and personal computer systems as a developer, manager, trainer, marketer, support person, and writer. After 14 years at Microsoft, Bill stepped away to work on his books and training seminars. His area of specialization is focused on data access and especially Visual Basic and SQL Server. He's written six editions of The Hitchhiker's Guide to Visual Basic and SQL Server (Microsoft Press) and two editions of ADO.NET and ADO Examples and Best Practices for Visual Basic Programmers (Apress). There's even a C# version: ADO.NET Examples and Best Practices for C# Programmers (Apress). Bill is a top-rated speaker and frequents conferences all over the world, including VSLive, Developer Connections, and PASS (Professional Association for SQL Server). He's also written a wealth of articles for magazines such as SQL Server Magazine, Visual Basic Programmer's Journal, .NET Magazine, and many others. Bill is working on content focusing on the .NET Compact Framework and SQL Server CE, as well as the next version of SQL Server. He's available for consulting or custom training.