Pragmatic ADO.NET: Data Access for the Internet World
by Shawn Wildermuth
"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
… See more details belowOverview
"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
Product Details
- ISBN-13:
- 9780201745689
- Publisher:
- Addison-Wesley
- Publication date:
- 11/28/2002
- Series:
- Microsoft.Net Development Series
- Pages:
- 357
- Product dimensions:
- 7.30(w) x 9.00(h) x 1.00(d)
Table of Contents
(NOTE: Each chapter concludes with a Conclusion.)Foreword.
Preface.
Acknowledgments.
I. THE BASICS OF ADO.NET.
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.
Connections.
Getting OLE DB Database Schema Information.
Error Handling in .NET.
3. Commanding the Database.
Commands.
Executing Commands.
Database Transactions in ADO.NET.
Batch Queries.
4. Reading Data.
Reading Data.
The DataReader.
Putting It All Together.
II. ALL ABOUT DATASETS.
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.
III. ADO.NET IN ACTION.
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.
Conclusion.
Index. 0201745682T10112002
Customer Reviews
Average Review: