Accessing Data with ADO.NET
    The ADO.NET Object Model
          ODBC
          DAO
          RDO and ODBCDirect
          ADO
          ADO.NET
          Connected and Disconnected Objects
          Connecting to Data
          Connection Strings
          The Using Block
          SQL Server Connections
          Microsoft Access Connections
    Understanding Connection Pooling
          Closing Connections
          Turning Off Connection Pooling
          Managing the Pool with SqlClient
          Using SQL Profiler to Monitor the Pool
          Using the Performance Monitor
    Using Provider Statistics

Retrieving Data
    Introducing Command Classes
          Creating Command Objects
          Command Object Methods
    Working with Data Readers
          Retrieving Results Faster
          Retrieving Multiple Result Sets
          Retrieving Information about DataReader Schema
          Using a Reader that Retrieves Data from a DataTable
    Digging Deeper into Commands and DataReaders
          Calling a Stored Procedure or Saved Query
          Passing Parameters
          Managing Multiple Namespaces with One Procedure
          Calling a Stored Procedure with an Output Parameter
          Binding DataReaders in ASP.NET
          Filling the GridView Control
          Hooking Up the Data

Caching Data in Datasets
    DataSets and DataTables
          DataSets Are Disconnected
          DataTables
    Populating a DataTable
          Defining DataTable Columns
          Adding Rows with the NewRow Method
          Binding a DataGrid to a DataTable
    Filling DataSets Using a DataAdapter
          DataAdapter Command Objects
          Filling a DataTable
          Using the Load Method
          Handling Multiple Result Sets
    Retrieving Schema Information
          DataColumns and Schema
    DataSets and XML
          Reading and Writing XML Data

Applying Constraints
    Primary Keys and Unique Constraints
          Merging DataSets
    Foreign Key Constraints
          Referential Integrity
    Column-Based Constraints
          AllowDBNull
          MaxLength
          Default Values

Data Relations
    Creating DataRelations
          Creating Relationships in SQL Server
          Relations in ADO.NET
          The DataRelation Object
    Navigation Pathways
          GetChildRows
GetParentRow
    Expressions and Relations
          Aggregate Calculated Expressions
          Lookup Expressions
    Specifying XML Nesting

Updating Data
    Creating Commands with CommandBuilders
          Generating Commands
          Updating Data Using a Command Builder
    Creating Commands
          Specifying Parameters
          Updating with the DataAdapter
          Understanding DataRowVersion and RowState
    Using Stored Procedures
          Advantages of Stored Procedures
          Using Stored Procedures
          The Insert Stored Procedure
          The Delete Stored Procedure
          Adding New Customers with Stored Procedures
          Deleting Customers with Stored Procedures
    Performing Batch Updates
          Setting UpdateBatchSize

Using Strongly Typed DataSet Classes
    Using a Loosely Typed DataSet
    Creating a Strongly Typed DataSet
          Investigating the Class
          Use the Class View Window
          Writing Some Simple Code
    Using a Strongly Typed DataSet
          Working with an Untyped DataSet
          Working with a Typed DataSet
          Using a TableAdapter
          Finding a Row in a Typed DataSet
          Editing a Row in a Typed DataSet
          Adding a New Row to a Typed DataSet
          Working with Null Values in a Typed DataSet
          Navigating Relations in a Typed DataSet
          Creating New TableAdapter Queries
    Issues with Using a Strongly Typed DataSet
          Strongly Typed DataSet and Data Binding
          Comparing Typed and Untyped DataSet Efficiency
          Converting Between Typed and Untyped DataSet Instances
          Using Annotations to Control the Generation of a DataSet Class
          Should You Use a Typed DataSet?

Handling Exceptions and Data Errors
    Using Structured Exception Handling
          The Exception Base Class
          The Try/Catch Block
          Unhandled Exceptions
          Using the Exception Object
    Handling Provider Errors
          Using SqlException
          Using InfoMessage
          Dealing with Errors and InfoMessages
    Using Transactions
          Implicit Transactions
          Explicit Transactions
          Transaction Isolation Levels
          The SqlTransaction Object
    Handling Concurrency Conflicts
          Optimistic Concurrency Issues
          Update Criteria
          Handling Data Updates with ADO.NET

Searching, Sorting, and Filtering
    The Sample Project
          Data in the Sample Project
          Displaying Results
    Working with DataTables
          Searching Primary Key Values
          Searching for Multiple Columns
          Simple Dynamic Searches
          Searching with Wildcards
          Managing Delimiters
          More Filtering Issues
    Working with DataViews
          Sorting Data Using a DataView
          Filtering Data
          Filtering on Row State
          Iterating through Rows
          Finding a Row
          Finding Multiple Rows
          Modifying Data in a DataView
          Creating a DataTable from a DataView

Handling AutoIncrement Columns
    The AutoIncrement Property
          AutoIncrement in a Typed DataSet
    Retrieving New Database Values
          Using Batched SQL Statements
          Using the RowUpdated Event
          Resetting the SQL Server Identity Seed
    Avoiding Multiuser Conflicts
          Understanding the Problem
          Setting AutoIncrementSeed and AutoIncrementStep
    Merging Inserted Rows
          Understanding the Problem
          Inspecting the Code
          Solving the Merge Problem
    Other Considerations
          Handling Parent/Child Inserts
          The Easy Way: Using GUIDs

XML Techniques
    ADO.NET and XML
          Getting Started Reading and Writing XML
          Working with XML Programmatically
    Saving DataSet Data as XML
          Using the GetXml Method
          Controlling DataSet XML Output Options
          Using the WriteXml Method
          Writing XML Output as a DiffGram
    Loading XML Data into a DataSet
          The Ground Rules
          Inferring a Schema
          Using Internal Schema
          Using External Schema
          Reading a DiffGram
          Loading a DataSet or DataTable from an XML String
    Working with DataSets and XML Together
          Using an XmlDataDocument
          Format XML Data with XSLT
          Query DataSet Data with XPath
    Working with XML Data in SQL Server
          Using XQuery to Query and Modify XML Data in SQL Server 2005

Supporting SQL Server 2005 Features
    Optimizing Performance
          Performing Asynchronous Processing
          Using Bulk Copy to Load Data Quickly
          Enhancing Concurrency with Snapshot Isolation
    Easing Application Development
          Listing Available SQL Servers
          Retrieving Multiple Active Result Sets (MARS)
          Working with max Data Types
          Using Query Notifications with ASP.NET Caching