2389B Programming with Microsoft ADO.NET
Course Outline
Module 1: Data-Centric Applications and ADO.NET
Take a closer look: Download Sample Module 1 (Portable Document Format, 1.12 MB).
The following topics are covered in this module:
• Design of Data-Centric Applications
• ADO.NET Architecture
• ADO.NET and XML
After completing this module, students will be able to:
• Give examples of storage options.
• Diagram the architecture of data-centric applications.
• Choose a connected, disconnected, or mixed environment based on application requirements.
• Use the System.Data namespaces in applications.
• Diagram the ADO.NET object model.
• Analyze typical business scenarios.
• Explain how to use ADO.NET with XML.
Lab 1.1: Data-Centric Applications and ADO.NET
Module 2: Connecting to Data Sources
Take a closer look: Download Sample Module 2 (Portable Document Format, 1.02 MB).
The following topics are covered in this module:
• Choosing a .NET Data Provider
• Defining a Connection
• Managing a Connection
• Handling Connection Exceptions
• Connection Pooling
After completing this module, students will be able to:
• Choose a .NET data provider.
• Connect to SQL Server.
• Connect to OLE DB data sources.
• Manage a connection.
• Handle common connection exceptions.
• Implement and control connection pooling.
Lab 2.1: Connecting to Data Sources
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
After completing this module, students will be able to:
• Build a command object.
• Execute a command that returns a single value.
• Execute a command that returns a set of rows, and process the result.
• Execute a command that defines database structure and permissions by using the data definition language (DDL) and data control language (DCL).
• Execute a command that modifies data.
• Use transactions.
Lab 3.1: Performing Connected Database Operations
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
After completing this module, students will be able to:
• Describe the disconnected environment.
• Build a DataSet and a DataTable.
• Bind a DataSet to a DataGrid.
• Open and save a DataSet.
• Define a data relationship.
• Modify data in a DataTable.
• Find and select rows in a DataTable.
• Sort and filter a DataTable by using a DataView.
Lab 4.1: Building, Binding, Opening, and Saving DataSets
Lab 4.2: Manipulating DataSets
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
After completing this module, students will be able to:
• Generate an XSD schema from a DataSet by using graphical tools.
• Save a DataSet structure to an XSD schema file.
• Create and populate a DataSet from an XSD schema and XML data.
• Save DataSet data as XML.
• Write and load changes by using a DiffGram.
Lab 5.1: Working with XML Data in ADO.NET
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
After completing this module, students will be able to:
• Configure a DataAdapter to retrieve information.
• Populate a DataSet by using a DataAdapter.
• Configure a DataAdapter to modify information.
• Persist data changes to a data source.
• Manage data conflicts.
Lab 6.1: Retrieving Data into a Disconnected Application
Lab 6.2: Retrieving and Updating Customers and Orders Data
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
After completing this module, students will be able to:
• Build a Web service.
• Consume a Web service in a client application.
• Troubleshoot errors in an ADO.NET application.
Lab 7.1: Troubleshooting an ADO.NET Application