Level 1: Understanding ADO.NET

You will learn how to retrieve and manipulate data using Microsoft’s new ADO.NET library. Understand how to work with the new ADO.NET object model, including the DataReader, DataAdapter, and DataSet. See how to apply constraints and relationships to disconnected data. Learn how to update data, including how to handle stored procedures, parameters, and return values. Understand how to search, sort, and filter data using Select, Find, and DataViews. Become familiar with strongly typed DataSets and learn their advantages.

Introduction to ADO.NET

ADO.NET Code Created by Visual Studio
The ADO.NET Object Model

Connecting to Data Sources

Connection Objects
Opening Connections
Connection Pooling
Retrieving Schema Information
Saving Connection Strings

Retrieving Data

Introducing Command Classes
Working with DataReaders
Digging Deeper into Commands and DataReaders

Caching Data in DataSets

Introduction to DataSets
Populating a DataTable
Filling DataSets Using a DataAdapter
Retrieving Schema Information
DataSets and XML

Applying Constraints

Using Constraints
Foreign Key Constraints
Other Constraints

DataRelations

Creating DataRelations
Navigation Pathways
Expressions and Relations
Specifying XML Nesting
Revisiting the DataForm Wizard

Updating Data

Creating Commands with CommandBuilders
Creating Commands
Using Stored Procedures
Revisiting the Wizard Code

Using Strongly Typed DataSets

Using Loosely Typed DataSets
Creating a Strongly Typed DataSet
Using Strongly Typed DataSets
Issues with Strongly Typed DataSets
Revisiting the Data Form Wizard

Handling Exceptions and Data Errors

Using Structured Exception Handling
Handling Provider Errors
Handling Concurrency Conflicts
Using Transactions

Searching, Sorting, and Filtering

The Sample Project
Working with DataTables
Working with DataViews