| 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 2 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 2?
|
| • 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 2.
|
| • 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 2 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 2 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 2 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 2 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 2 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 DataSet.
|
| • 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 |
Top