Core
Data Access with Microsoft Visual Studio 2005
Course 2541: Three days;
Instructor-Led
Introduction
This
three-day instructor-led workshop provides students with the knowledge and
skills to develop data-access applications by using the Microsoft .NET
Framework and Microsoft Visual Studio 2005. The workshop describes how to
access and update data in a database by using ADO.NET. The workshop also
describes how to create, read, and write XML data.
Audience
This
workshop is intended for corporate and Independent Software Vendor (ISV)
application developers who have a desire to learn more about specific
technology areas in distributed application development.
At
Workshop Completion
After
completing this workshop, students will be able to:
•
Connect to databases and read data.
•
Query and update databases by using
commands.
•
Perform transactional operations.
•
Perform disconnected operations
programmatically.
•
Perform disconnected operations by using
Visual Studio 2005 wizards.
•
Perform XML operations on disconnected
data.
•
Read and write XML data.
•
Process XML data by using the Document
Object Model DOM.
Prerequisites
Before
attending this workshop, students must:
•
Be able to manage a solution environment
using the Visual Studio 2005 integrated development environment IDE and tools
•
Understand the .NET Framework 2.0 and the
Common Language Runtime
•
Be able to program an application using a
.NET Framework 2.0 compliant language
•
Know how to make assemblies available to
other applications
•
Have a good understanding of basic
relational database concepts
•
Be able to use basic SQL commands
•
Have a good understanding of XML including
XML declaration, elements, attributes, and namespaces
•
Be able to explain XML schema concepts
Course
Outline
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.
Solutient
Corporation of Ohio
6133
Rockside Road, Suite 100 – Cleveland, OH
44131
FOR
MORE INFORMATION, CALL 216-654-0025