Unit 1:
Connecting to Databases and Reading Data
This
unit introduces the fundamental skills required to connect to a database and
read data from the database. It describes how to use ADO.NET data providers to
connect to various different kinds of databases, and how to execute a query
that returns a scalar value from the database. It also describes how to use
connection pooling to achieve scalability, and how to handle connection events
and exceptions.
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
This
unit describes how to create and run commands that return a scalar value,
return a result set, update data in the database, or update the schema of the
database. It also describes how to create and run parameterized 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
This
unit describes how to manage transactions in a .NET application at the middle
tier. It describes how to write ADO.NET code to start, commit, and rollback
local transactions. It also describes how to specify an appropriate isolation
level for a transaction, and how to enlist in distributed transactions.
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
This
unit describes how to create and use DataSets
programmatically. It describes how to create DataSet,
DataTable, and DataColumn
objects, how to populate a DataSet manually, and how
to load and save data by using a DataAdapter. It also
describes how to create in-memory views on data by using a DataView.
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
This
unit describes how to create typed DataSets, DataAdapters, and TableAdapters
by using the TableAdapter Configuration Wizard and
the Data Source Configuration Wizard in Visual Studio 2005. It also describes
how to write type-safe code to access data in a typed DataSet.
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
This
unit describes how to read and write DataSets in XML
format. It describes how to read and write data only, schema only, or a
combination of the two. It also describes how to read and write a DataSet as a DiffGram, so that
modifications to the data can be retained when the DataSet
is serialized to XML format.
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
This
unit describes how to use the XmlReader and XmlWriter classes to serially read and write XML data. It
describes how to read elements, attributes, and text content in an XML
document, and perform validation against an XML schema. It also describes how
to create an XML document and write elements, attributes, namespace
declarations, and text content.
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
This
unit describes how to process XML data in memory by using the Document Object
Model (DOM). It describes how to load an XML document into a DOM tree, and
validate the XML document against an XML schema. It also describes how to read
existing XML content, modify XML content, and save the DOM tree to an XML
document.
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.
|
