Overview
Make the most of your development time and efforts with the only complete desktop reference to the entire ADO.NET framework. This comprehensive resource covers all ADO.NET objects and presents examples for each of the .NET Data Providers—with each example provided in both Visual Basic .NET and C#. Written by the Senior Technical Editor of SQL Server Magazine, this is an essential reference for developers.Editorials
From Barnes & Noble
The Barnes & Noble ReviewADO.NET is the first Microsoft data access technology designed from the ground up to support today’s loosely coupled web and distributed systems. Most developers have only scratched its surface. To go deeper, read ADO.NET: The Complete Reference.
Experienced database developers Michael and Denielle Otay first review the data access problems ADO.NET has been designed to solve and explain how ADO.NET fits into the overall .NET Framework. Next, they systematically cover every important ADO.NET object, beginning with the ADO.NET Connection Object: the main link to opening any data source in ADO.NET. The Oteys thoroughly discuss the ADO.NET Command Object, demonstrating dynamic SQL queries, parameterized queries, stored procedures with return values or output parameters, and more. In this section, you’ll also find detailed coverage of using Transaction and Command classes to protect database integrity.
You’ll learn how to use the ADO.NET DataReader Object to retrieve fast, forward-only result sets, multiple results sets, hierarchical results sets, and detailed table schema information. Then, the Oteys turn to the ADO.NET object that’s probably received the most publicity: the DataSet object. In the book’s longest, most detailed section, they systematically cover building datasets; populating them using each major data adapter (from ODBC to Oracle); navigating them, and updating them.
Finally, you’ll find detailed coverage of ADO.NET data integration, including mapping data to XML, importing COM-based ADO objects, and using ADO recordsets from ADO.NET. The book also contains a 350-page reference to every ADO.NET namespace: classes, delegates, enumerations, interfaces, and best of all, C# code examples. Bill Camarda
Bill Camarda is a consultant, writer, and web/multimedia content developer. His 15 books include Special Edition Using Word 2000 and Upgrading & Fixing Networks for Dummies, Second Edition.