You are previewing Sams Teach Yourself ADO.NET in 21 Days.
O'Reilly logo
Sams Teach Yourself ADO.NET in 21 Days

Book Description

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.

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