Module 1: Data-Centric Applications and ADO.NET

Take a closer look: Download Sample Module 1 (Portable Document Format, 1.12 MB).

Lessons

• Design of Data-Centric Applications
• ADO.NET Architecture
• ADO.NET and XML

Lab: Lab 1.1: Data-Centric Applications and ADO.NET

After completing this module, students will be able to:

Module 2: Connecting to Data Sources

Take a closer look: Download Sample Module 2 (Portable Document Format, 1.02 MB).

Lessons

• Choosing a .NET Data Provider
• Defining a Connection
• Managing a Connection
• Handling Connection Exceptions
• Connection Pooling

Lab: Lab 2.1: Connecting to Data Sources

After completing this module, students will be able to:

Module 3: Performing Connected Database Operations

The following topics are covered in this module:

Lessons

• 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

Lab: Lab 3.1: Performing Connected Database Operations

After completing this module, students will be able to:

Module 4: Building DataSets

The following topics are covered in this module:

Lessons

• 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

Lab: Lab 4.1: Building, Binding, Opening, and Saving DataSets

Lab: Lab 4.2: Manipulating DataSets

After completing this module, students will be able to:

Module 5: Reading and Writing XML with ADO.NET

The following topics are covered in this module:

Lessons

• Creating XSD Schemas
• Loading Schemas and Data into DataSets
• Writing XML from a DataSet

Lab: Lab 5.1: Working with XML Data in ADO.NET

After completing this module, students will be able to:

Module 6: Building DataSets from Existing Data Sources

The following topics are covered in this module:

Lessons

• 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

Lab: Lab 6.1: Retrieving Data into a Disconnected Application

Lab: Lab 6.2: Retrieving and Updating Customers and Orders Data

After completing this module, students will be able to:

Module 7: Building and Consuming a Web Service That Uses ADO.NET

The following topic is covered in this module:

Lab: Lab 7.1: Troubleshooting an ADO.NET Application

After completing this module, students will be able to: