Sams Teach Yourself ADO.NET in 21 Days

Table of contents

1. Copyright
2. About the Author
3. About the Technical Editors
4. Acknowledgments
5. We Want to Hear from You!
6. Introduction
7. At a Glance
   1. ADO.NET in Perspective
      1. Microsoft Data Access Technologies
      2. ADO.NET Design Goals
      3. ADO.NET in .NET
      4. Summary
      5. Workshop
   2. Getting Started
      1. ADO.NET in Visual Studio .NET
      2. ADO.NET in Code
      3. Summary
      4. Workshop
   3. Working with DataSets
      1. Understanding the ADO.NET DataSet
      2. Populating a DataSet
      3. Manipulating Multiple DataSets
      4. Using a DataView
      5. Summary
      6. Workshop
   4. DataSet Internals
      1. Data Table Structure
      2. Constraints
      3. Extended Properties
      4. Summary
      5. Workshop
   5. Changing Data
      1. Making Modifications
      2. Handling Changes
      3. Summary
      4. Workshop
   6. Building Strongly Typed DataSet Classes
      1. Strongly Typed DataSet Classes Defined
      2. DataSet Serialization
      3. Summary
      4. Workshop
   7. XML and the DataSet
      1. Writing Data as XML
      2. Creating the XSD Schema
      3. Using a DataSet as XML
      4. Summary
      5. Workshop
   8. Week 1 In Review
8. At a Glance
   1. Understanding .NET Data Providers
      1. Provider Architecture
      2. Provider Functionality
      3. Summary
      4. Workshop
   2. Using Connections and Transactions
      1. Opening Connections and Handling Events
      2. Specifying Connection Strings
      3. Storing Connection Strings
      4. Pooling Connections
      5. Using Transactions
      6. Summary
      7. Workshop
   3. Using Commands
      1. Using Command Objects
      2. Handling Parameters
      3. Summary
      4. Workshop
   4. Using Data Readers
      1. Data Reader Characteristics
      2. Traversing a Data Reader
      3. Advanced Features
      4. Summary
      5. Workshop
   5. Using Data Adapters
      1. Retrieving Data
      2. Updating a Data Store
      3. Summary
      4. Workshop
   6. Working with SQL Server
      1. SqlClient Internals
      2. Database Design
      3. Alternative Data Access Techniques
      4. Summary
      5. Workshop
   7. Working with Other Providers
      1. Accessing ODBC Data Sources
      2. Building a .NET Data Provider
      3. Summary
      4. Workshop
   8. Week 2 In Review
9. At a Glance
   1. Using ADO.NET in a Multi-Tier Application
      1. The Multi-Tiered Architecture
      2. ADO.NET in Context
      3. Summary
      4. Workshop
   2. ADO.NET in the Presentation Services Tier
      1. Windows Forms Applications
      2. Web Forms Applications
      3. Summary
      4. Workshop
   3. ADO.NET in the Data Services Tier
      1. Using an Abstract Base Class
      2. Designing Data Access Classes
      3. Summary
      4. Workshop
   4. Building a Data Factory
      1. Creating a Data Factory
      2. Summary
      3. Workshop
   5. ADO.NET and XML Web Services
      1. Exposing Data Through a Web Service
      2. Consuming Data in a Web Service
      3. Summary
      4. Workshop
   6. Performance and Interoperation
      1. Performance and Scalability Optimizations
      2. Interoperating with ADO
      3. Summary
      4. Workshop
   7. Futures and Wrap Up
      1. Programming SQL Server .NET
      2. Using ObjectSpaces
      3. Summary and Final Thoughts
      4. Workshop
   8. Week 3 In Review
10. Index