This course will teach developers to build data-centric applications and Web services with Microsoft ADO.NET, Microsoft SQL Server 2000, and the Microsoft .NET Framework.
Course Completion Skills:
- Describe data-centric applications, ADO.NET architecture, and ADO.NET and XML.
- Connect to SQL Server and other data sources.
- Perform connected database operations including executing SELECT commands, database definition commands, dynamic SQL commands, and commands that return data from a SQL Server database in XML.
- Build a DataSet schema, populate it with data, and modify the data programmatically.
- Build a DataSet from an existing data source.
- Use XML techniques while working with DataSets, including mapping tables and columns, creating XSD schemas, building strongly typed DataSets, and interacting with XMLDataDocuments.
- Build a Web service that uses ADO.NET to query and update a data source.
- Troubleshoot errors within an ADO.NET application.
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
Labs
- Data-Centric Applications and ADO.NET
After Completing This Goal, 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.
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
Labs
- Connecting to Data Sources
After Completing This Goal, 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.
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
Labs
- Performing Connected Database Operations
After Completing This Goal, 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.
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
Labs
- Building, Binding, Opening, and Saving DataSets
- Manipulating DataSets
After Completing This Goal, 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.
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
Labs
- Working with XML Data in ADO.NET
After Completing This Goal, 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.
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
Labs
- Retrieving Data into a Disconnected Application
- Retrieving and Updating Customers and Orders Data
After Completing This Goal, 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.
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
Labs
- Troubleshooting an ADO.NET Application
After Completing This Goal, Students will be Able To
- Build a Web service.
- Consume a Web service in a client application.
- Troubleshoot errors in an ADO.NET application.