Module 1: Data-Centric Applications and ADO.NET
Lessons
- Design of Data-Centric Applications
- ADO.NET Architecture
- ADO.NET and XML
Lab: Data-Centric Applications and ADO.NET
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.
Top
Module 2: Connecting to Data Sources
Lessons
- Choosing a .NET Data Provider
- Defining a Connection
- Managing a Connection
- Handling Connection Exceptions
- Connection Pooling
Lab: Connecting to Data Sources
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.
Top
Module 3: Performing Connected Database Operations
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: Performing Connected Database Operations
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.
Top
Module 4: Building DataSets
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: Building, Binding, Opening, and Saving DataSets, Manipulating DataSets
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.
Top
Module 5: Reading and Writing XML with ADO.NET
Lessons
- Creating XSD Schemas
- Loading Schemas and Data into DataSets
- Writing XML from a DataSet
Lab: Working with XML Data in ADO.NET
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.
Top
Module 6: Building DataSets from Existing Data Sources
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: Retrieving Data into a Disconnected Application, Retrieving and Updating Customers and Orders Data
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.
Top
Module 7: Building and Consuming a Web Service That Uses ADO.NET
Lessons
- Building and Consuming a Web Service That Returns Data
Lab: Troubleshooting an ADO.NET Application
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.
Top |
