Home > Store

Sams Teach Yourself ADO.NET in 21 Days

Sams Teach Yourself ADO.NET in 21 Days

eBook (Adobe DRM)

  • Sorry, this book is no longer in print.
  • About Adobe DRM eBooks
  • This eBook requires the free Adobe® Digital Editions software.

    Before downloading this DRM-encrypted PDF, be sure to:

    • Install the free Adobe Digital Editions software on your machine. Adobe Digital Editions only works on Macintosh and Windows, and requires the Adobe Flash Player. Please see the official system requirements.
    • Authorize your copy of Adobe Digital Editions using your Adobe ID (select AdobeID as the eBook vendor). If you don't already have an Adobe ID, you can create one here.
Not for Sale

Also available in other formats.

Register your product to gain access to bonus material or receive a coupon.


  • Copyright 2002
  • Dimensions: 7-3/8" x 9-1/8"
  • Edition: 1st
  • eBook (Adobe DRM)
  • ISBN-10: 0-7686-5988-4
  • ISBN-13: 978-0-7686-5988-7

ADO.NET refers to a set of classes that ship with Visual Studio .NET that allow developers to access data typically stored in relational databases. The purpose of this book is to explain the important features of ADO.NET to corporate developers who use VS .NET. Dan Fox also provides architectural guidance and Best Practices for using ADO.NET in corporate applications. Reference Tables sho how members of ADO.NET classes fit into the bigger picture by denoting why or where the method or property is used. This book is filled with code snippets and code listings in both VB .NET and VC# .NET, sidebars, and mini Case Studies that briefly explore peripheral issues, tips, cautions, and additional resources.

Sample Content

Table of Contents



Day 1. ADO.NET in Perspective.

Microsoft Data Access Technologies. ADO.NET Design Goals. ADO.NET in .NET. Summary. Workshop.

Day 2. Getting Started.

ADO.NET in Visual Studio .NET. ADO.NET in Code. Summary. Workshop. Answers for Day 2

Day 3. Working with DataSets.

Understanding the ADO.NET DataSet. Populating a DataSet. Manipulating Multiple DataSets. Using a DataView. Summary. Workshop. Answers for Day 3

Day 4. DataSet Internals.

Data Table Structure. Constraints. Extended Properties. Summary. Workshop. Answers for Day 4

Day 5. Changing Data.

Making Modifications. Handling Changes. Summary. Workshop. Answers for Day 5

Day 6. Building Strongly Typed DataSet Classes.

Strongly Typed DataSet Classes Defined. DataSet Serialization. Summary. Workshop. Answers for Day 6

Day 7. XML and the DataSet.

Writing Data as XML. Creating the XSD Schema. Using a DataSet as XML. Summary. Workshop. Answers for Day 7.

Week 1. In Review.


Day 8. Understanding .NET Data Providers.

Provider Architecture. Provider Functionality. Summary. Workshop. Answers for Day 8.

Day 9. Using Connections and Transactions.

Opening Connections and Handling Events. Specifying Connection Strings. Storing Connection Strings. Pooling Connections. Using Transactions. Summary. Workshop. Answers for Day 9.

Day 10. Using Commands.

Using Command Objects. Handling Parameters. Summary. Workshop. Answers for Day 10.

Day 11. Using Data Readers.

Data Reader Characteristics. Traversing a Data Reader. Advanced Features. Summary. Workshop. Answers for Day 11.

Day 12. Using Data Adapters.

Retrieving Data. Updating a Data Store. Summary. Workshop. Answers for Day 12.

Day 13. Working with SQL Server.

SqlClient Internals. Database Design. Alternative Data Access Techniques. Summary. Workshop.

Day 14. Working with Other Providers.

Accessing ODBC Data Sources. Building a .NET Data Provider. Summary. Workshop. Answers for Day 14.

Week 2. In Review.


Day 15. Using ADO.NET in a Multi-Tier Application.

The Multi-Tiered Architecture. ADO.NET in Context. Summary. Workshop.

Day 16. ADO.NET in the Presentation Services Tier.

Windows Forms Applications. Web Forms Applications. Summary. Workshop. Answers for Day 16.

Day 17. ADO.NET in the Data Services Tier.

Using an Abstract Base Class. Designing Data Access Classes. Summary. Workshop. Answers for Day 17.

Day 18. Building a Data Factory.

Creating a Data Factory. Summary. Workshop. Answers for Day 18.

Day 19. ADO.NET and XML Web Services.

Exposing Data Through a Web Service. Consuming Data in a Web Service. Summary. Workshop. Answers for Day 19.

Day 20. Performance and Interoperation.

Performance and Scalability Optimizations. Interoperating with ADO. Summary. Workshop. Answers for Day 20.

Day 21. Futures and Wrap Up.

Programming SQL Server .NET. Using ObjectSpaces. Summary and Final Thoughts. Workshop.

Week 3. In Review.


Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership