| |
| |
| Module 1: |
Data-Centric Applications and ADO.NET
The following topics are covered in this module: |
| |
|
~
~
~ |
Design of Data-Centric Applications
ADO.NET Architecture
ADO.NET and XML |
| |
| Module 2: |
Connecting to Data Sources
The following topics are covered in this module: |
| |
~
~
~
~
~ |
Choosing a .NET Data Provider
Defining a Connection
Managing a Connection
Handling Connection Exceptions
Connection Pooling |
| |
| Module 3: |
Performing Connected Database Operations
The following topics are covered in this module: |
| |
~
~
~
~
~
~ |
Working in a Connected Environment
Building Command Objects
Executing Commands That Return a Single Value
Executing Commands That Return Rows
Executing Commands That Do Not Return Rows
Using Transactions |
| |
| Module 4: |
Building DataSets
The following topics are covered in this module: |
| |
~
~
~
~
~
~ |
Working in a Disconnected Environment
Building DataSets and DataTables
Binding and Saving a DataSet
Defining Data Relationships
Modifying Data in a DataTable
Sorting and Filtering |
| |
| Module 5: |
Reading and Writing XML with ADO.NET
The following topics are covered in this module: |
| |
~
~
~ |
Creating XSD Schemas
Loading Schemas and Data into DataSets
Writing XML from a DataSet |
| |
| Module 6: |
Building DataSets from Existing Data Sources
The following topics are covered in this module: |
| |
~
~
~
~
~ |
Configuring a DataAdapter to Retrieve Information
Populating a DataSet Using a DataAdapter
Configuring a DataAdapter to Update the Underlying Data Source
Persisting Changes to a Data Source
How to Handle Conflicts |
| |
| Module 7: |
Building and Consuming a Web Service That Uses ADO.NET
The following topic is covered in this module: |
| |
| ~ |
Building and Consuming a Web Service That Returns Data |
| |
| |