|
Unit 1: Connecting to Databases and Reading Data
Lessons
What Is ADO.NET?
The Process for Connecting to a Database and Reading Data
What Is Connection Pooling?
Lab 1: Connecting to Databases and Reading Data
Exercise 1. Connecting to a Database
Exercise 2. Saving a Connection String Securely in an Application Configuration File
Exercise 3. Retrieving Data from a Database
Exercise 4. Handling Connection Events and Exceptions
Exercise 5. Configuring and Using Connection Pooling (if time permits)
After completing this unit, students will be able to:
Describe the key features of ADO.NET.
Explain the process for connecting to a database and reading data from a database.
Describe the benefits of connection pooling.
Connect to a database.
Save a connection string securely in an application configuration file.
Retrieve data from a database.
Handle connection events and exceptions.
Unit 2: Querying and Updating Databases by Using Commands
Lessons
ADO.NET Commands
The Process for Passing Parameters into Commands
Lab 2: Querying and Updating Databases by Using Commands
Exercise 1. Creating and Running Query Commands
Exercise 2. Creating and Running Parameterized Commands
Exercise 3. Creating and Running Update Commands
Exercise 4. Using Globalized Formats for Storing and Accessing Data (if time permits)
After completing this unit, students will be able to:
List the different types of ADO.NET commands.
Explain the process for creating and executing parameterized commands.
Create and run query commands.
Create and run parameterized commands.
Create and run update commands.
Unit 3: Performing Transactional Operations
Lessons
What Is a Transaction?
The Process for Managing Local Transactions
The Process for Managing Distributed Transactions
Isolation Levels
Lab 3: Performing Transactional Operations
Exercise 1. Performing Data Updates within a Transaction
Exercise 2. Choosing an Appropriate Isolation Level for a Transaction
Exercise 3. Enlisting in a Distributed Transaction
Exercise 4. Managing Transactions in the Data Tier (if time permits)
After completing this unit, students will be able to:
Describe the concept of transactional operations.
Explain the process for managing a local transaction.
Explain the process for managing a distributed transaction.
Describe the effect of setting the isolation level for a transaction.
Perform data updates within a transaction.
Choose an appropriate isolation level for a transaction.
Enlist in a distributed transaction.
Unit 4: Performing Disconnected Operations Programmatically
Lessons
What Is the ADO.NET Disconnected Model?
The Process for Loading and Saving Data in a DataSet
What Are DataViews?
Lab 4: Performing Disconnected Operations Programmatically
Exercise 1. Creating a DataSet Programmatically
Exercise 2. Populating and Saving a DataSet
Exercise 3. Adding, Modifying, and Deleting Data in a DataSet
Exercise 4. Merging DataSets
Exercise 5. Creating and Using DataViews (if time permits)
After completing this unit, students will be able to:
Describe the ADO.NET disconnected data model.
Explain the process for loading and saving data in a DataSet.
Describe how to use DataViews to provide a view on data.
Create a DataSet programmatically.
Populate and save a DataSet.
Add, modify, and delete data in a DataSet.
Merge DataSets.
Unit 5: Performing Disconnected Operations by Using Visual Studio 2005 Wizards
Lessons
Comparing Untyped DataSets with Typed DataSets
What Are Table Adapters?
Demonstration: Creating a Typed DataSet by Using Visual Studio 2005 Wizards
Lab 5: Performing Disconnected Operations by Using Visual Studio 2005 Wizards
Exercise 1. Creating a Typed DataSet by Using the DataSet Designer
Exercise 2. Loading, Displaying, and Saving Data in a Typed DataSet
Exercise 3. Adding Code to a Typed DataSet
Exercise 4. Creating a Typed DataSet by Using the Data Source Configuration Wizard
Exercise 5. Adding Queries to a Table Adapter (if time permits)
After completing this unit, students will be able to:
Explain the differences between untyped DataSets and typed DataSets.
Explain how table adapters work in conjunction with data tables in a typed DataSet.
Describe the process for creating a typed DataSet by using Visual Studio 2005 Wizards.
Create a typed DataSet by using the DataSet Designer.
Load, display, and save data in a typed DataSet.
Add code to a typed DataSet.
Create a typed DataSet by using the Data Source Configuration Wizard.
Unit 6: Performing XML Operations on Disconnected Data
Lessons
XML Representations of DataSets
What Are DiffGrams?
Lab 6: Performing XML Operations on Disconnected Data
Exercise 1. Saving a DataSet as XML Data
Exercise 2. Loading a DataSet from XML
Exercise 3. Saving and Loading DataSet Schema Information
After completing this unit, students will be able to:
Describe scenarios in which you can represent a DataSet as XML data.
Explain how a DiffGram retains information about modifications to a DataSet.
Save a DataSet as XML data.
Load a DataSet from XML.
Save and load DataSet schema information.
Unit 7: Reading and Writing XML Data
Lessons
The Process for Serially Reading XML Data
The Process for Serially Writing XML Data
Lab 7: Reading and Writing XML Data
Exercise 1. Writing XML Data by Using XmlWriter
Exercise 2. Reading XML Data by Using XmlReader
After completing this unit, students will be able to:
Describe the process for serially reading XML data.
Describe the process for serially writing XML data.
Write XML data by using XmlWriter.
Read XML data by using XmlReader.
Unit 8: Processing XML Data by Using DOM
Lessons
What Is DOM?
What Are DOM Trees?
Types of XML Nodes in a DOM Tree
Lab 8: Processing XML Data by Using DOM
Exercise 1. Reading XML Data by Using DOM
Exercise 2. Writing XML Data by Using DOM
After completing this unit, students will be able to:
Explain what DOM is and describe how to process XML data in memory by using DOM.
Explain what a DOM tree is and describe how to represent XML documents as a DOM tree.
List the types of nodes in a DOM tree.
Read XML data by using DOM.
Modify XML data by using DOM.
|
