Pragmatic ADO.NET: Data Access for the Internet World
Shawn Wildermuth, Chris SellsBooks.org participates in affiliate programs including Bookshop.org and the Amazon Services LLC Associates Program. We may earn a commission from qualifying purchases made through links on this page, at no additional cost to you.
Overview
"This is my favorite book on ADO.NET. The author clearly has an extensive understanding of the subject matter. It is useful not only for expert data access programmers but also for weekend code warriors."
—Glenn Thimmes, Senior Software Engineer, New Dawn Technologies.Formerly Develop Support Engineer (WebData), Microsoft Corporation
Pragmatic ADO.NET is a practical guide to using the first data access services designed specifically for Web-based applications. This tutorial provides developers with a clear introduction to ADO.NET, and gives practical solutions for using it effectively.
The book begins with a concise history of Microsoft's Universal Data Access strategy and the evolution of technology that has led us to ADO.NET. The core of the book demonstrates how to use ADO.NET to interact with databases and the rest of the .NET framework. In addition, readers learn by example the best practices for using ADO.NET to build scalable, high-performance systems. Pragmatic ADO.NET includes numerous code examples in C#, and a companion Web site located at www.adoguy.com/book features implementations in Visual Basic .NET and C#, along with updates on the technology. The book concludes with an appendix detailing strategies for migrating from ADO to ADO.NET.
Readers will learn how to:
- Work with data in a disconnected way
- Connect to databases through ADO.NET
- Use Command objects
- Use the DataReader
- Construct DataSets
- Create and use Typed DataSets
- Manipulate data with DataSets
- Update databases from DataSets
- Integrate with XML
- Use data binding
- Optimize performance and scalability
The combination of concise coverage, helpful explanations, and detailed examples makes Pragmatic ADO.NET an important guide for all developers looking to gain a working knowledge of ADO.NET.
Books in the Microsoft .NET Development Series are written and reviewed by the principal authorities and pioneering developers of the Microsoft .NET technologies, including the Microsoft .NET development team and DevelopMentor. Books in the Microsoft .NET Development Series focus on the design, architecture, and implementation of the Microsoft .NET initiative to empower developers and students everywhere with the knowledge they need to thrive in the Microsoft .NET revolution.
0201745682B10042002
Synopsis
Pragmatic ADO.NET is a practical guide to using the first data access services designed specifically for Web-based applications. This tutorial provides developers with a clear introduction to and practical solutions for the effective use of ADO.NET as well as the motivation for its use.
The book begins with a concise history of Microsoft's Universal Data Access strategy and the evolution of data access that has led us to ADO.NET. The core of the book demonstrates how and why to work with ADO.NET to interact with databases and the rest of the .NET framework. In addition, readers learn by example the best practices for using ADO.NET in building scalable, high-performance systems. The book includes numerous reusable code samples in C#. Pragmatic ADO.NET ends with an appendix detailing strategies for migrating from ADO to ADO.NET.
Readers discover how to:
- Work with data in a disconnected way
- Connect to databases through ADO.NET
- Use Command objects
- Use the DataReader
- Construct DataSets
- Create and use Typed DataSets
- Manipulate data with DataSets
- Update databases from DataSets
- Integrate with XML
- Use data binding
- Optimize performance and scalability
The combination of concise coverage, helpful explanations, and detailed examples makes Pragmatic ADO.NET an important guide for all developers looking to gain a working knowledge of ADO.NET.
Editorials
From Barnes & Noble
The Barnes & Noble ReviewADO.NET isn’t just the newest in Microsoft’s endless line of database access technologies: It’s a whole new way of thinking about data access in distributed and Internet-based applications. ADO.NET’s true power lies in its support for disconnected database programming, which dramatically reduces database connection loads and enhances scalability and performance. That’s the type of ADO.NET programming Shawn Wildermuth wants to teach you.
Wildermuth begins by illuminating ADO.NET’s approach to connections. ADO.NET is designed to open and close connections repeatedly, rather than leaving them open: A Connection class represents a single connection to a data source that can handle multiple open/close cycles. Wildermuth shows how to use ADO.NET’s sophisticated connection pooling, and how to create a ConnectionFactory class for doling out new connections at will, without redundant code.
Wildermuth next introduces ADO.NET’s commands for working with databases -- covering techniques ranging from wrapping stored procedures to writing parameterized queries. There’s a full chapter on using ADO.NET DataReaders to efficiently read data returned by SQL queries, followed by comprehensive coverage of DataSets -- the real heart of ADO.NET.
Here, Wildermuth covers everything from the basics (creating DataSets from databases or from XML) to Typed DataSets (which radically simplify the creation of business object layers). There’s also a full chapter on concurrency and some other sticky database update problems.
From data binding to improving scalability, Wildermuth offers practical examples and real clarity. You won’t just “get by” with ADO.NET: you’ll learn to think about data access the way ADO.NET does -- and leverage all the power ADO.NET promises. 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.