Pragmatic ADO.NET: Data Access for the Internet World, 1st edition

  • Shawn Wildermuth

Unfortunately, this item is not available in your country.


"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 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.


Table of contents

(NOTE: Each chapter concludes with a Conclusion.)





1. Why ADO.NET.

A Short History of Universal Data Access.

Why ADO.NET Is a Better Data Access Layer.

A Short Course in ADO.NET.

2. Getting Connected with ADO.NET.

First Impressions.


Getting OLE DB Database Schema Information.

Error Handling in .NET.

3. Commanding the Database.


Executing Commands.

Database Transactions in ADO.NET.

Batch Queries.

4. Reading Data.

Reading Data.

The DataReader.

Putting It All Together.


5. Constructing DataSets.

What is a Dataset.

Filling Datasets.

Defining DataSet Schema.

6. Typed DataSets.

What Are Typed DataSets?

Generating Typed DataSets.

Using Typed DataSets.

Simplification of Business Object Layers.

7. Working with DataSets.

Changing the Data.

Navigating the DataSet.

Searching the DataSet.

Merging DataSets.

8. Updating the Database.

The Trouble with Disconnected Data.

Concurrency in ADO.NET.

Common Updating Issues.


9. ADO.NET and XML.

.NET and XML.

The DataSet and XML.

The XmlDataDocument Class.

10. Data Binding with ADO.NET.

What is Data Binding in .NET?

Data Binding in Windows Forms.

Data Binding in ASP.NET.

11. Scalability and Performance.

Should You Worry?

Before ADO.NET.

How ADO.NET Can Help.

Are DataReaders Scalable.

ADO.NET Performance.

Best Practices.

Appendix: ADO Migration Strategies

Planning for Migration to ADO.NET.

ADO.NET Equivalents for ADO Objects.


Index. 0201745682T10112002

Published by Addison-Wesley Professional (November 5th 2002) - Copyright © 2003