Advanced
Data Access with Microsoft Visual Studio 2005
Workshop 2542: Two days;
Instructor-Led
Introduction
This
two-day instructor-led workshop provides students with the knowledge and skills
needed to use advanced data access features and techniques in the Microsoft
.NET Framework and Microsoft Visual Studio 2005. The workshop describes how to
access data and how to implement database functionality by using Microsoft
ADO.NET 2.0 and Microsoft SQL Server 2005. The workshop also describes how to
locate, edit, and transform XML by using XPath and Extensible Style sheet
Language for Transformations (XSLT).
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:
•
Minimize and handle database operation
conflicts.
•
Handle large objects.
•
Enhance database performance.
•
Create managed code objects for SQL Server
2005.
•
Query XML by using XPath.
•
Transform XML by using XSLT style sheets.
Prerequisites
Before
attending this workshop, students must:
•
Have attended or studied Workshop 2541,
Core Data Access with Microsoft Visual Studio 2005, or possess equivalent
knowledge and skills.
•
Know how to use delegates.
•
Be able to use database stored procedures,
triggers, and aggregates.
•
Be able to explain XPath concepts and basic
syntax.
•
Be able to explain XSLT style sheet concepts.
Workshop
Outline
Unit 1:
Minimizing and Handling Database Operation Conflicts
This
unit describes how to minimize data access conflicts, and how to handle these
conflicts when they occur. It describes how to implement optimistic concurrency
in the ADO.NET disconnected model, and how to implement optimistic concurrency
by using the various isolation levels available in SQL Server 2005.
Lessons
•
Why Do Data Conflicts Arise?
•
Isolation Levels Available in SQL Server
2005
•
Guidelines for Using SQL Server 2005
Isolation Levels
Lab
1: Minimizing and Handling Database Operation Conflicts
•
Exercise 1. Reading Committed Data by Using
Locks
•
Exercise 2. Reading Committed Data by Using
Statement-Level Snapshots
•
Exercise 3. Reading Committed Data by Using
Transaction-Level Snapshots
•
Exercise 4. Handling Data Concurrency by
Using ADO.NET
After
completing this unit, students will be able to:
•
Explain why data conflicts arise.
•
Describe the isolation levels that are
available in SQL Server 2005.
•
Describe the guidelines for using SQL
Server 2005 isolation levels.
•
Read committed data by using locks.
•
Read committed data by using
statement-level snapshots.
•
Read committed data by using
transaction-level snapshots.
•
Handle data concurrency by using ADO.NET.
Unit 2:
Handling Large Objects
This
unit describes how to read and write large values efficiently to a SQL Server
database. It describes how to read large binary values and large text values by
using SequentialAccess for a SqlDataReader. It also describes how to write
large binary values and large text values, and how to conserve resources when
writing large values.
Lessons
•
What Are Binary Large Objects and Character
Large Objects?
•
The Process for Reading Large Objects from
a Database
•
The Process for Writing Large Objects to a
Database
Lab
2: Handling Large Objects
•
Exercise 1. Reading Large Values from SQL
Server
•
Exercise 2. Writing Large Values to SQL
Server
•
Exercise 3. Conserving Resources When
Writing Large Values to SQL Server
After
completing this unit, students will be able to:
•
Describe binary large objects and character
large objects.
•
Explain the process for reading large
objects from a database.
•
Explain the process for writing large
objects to a database.
•
Read large values from SQL Server.
•
Write large values to SQL Server.
•
Conserve resources when writing large
values to SQL Server.
Unit 3:
Enhancing Database Performance
This
unit describes how to enhance database performance by using new features
available in ADO.NET 2.0. The unit describes how to perform asynchronous data
operations, create multiple active result sets, perform batch updates, and
perform bulk copies.
Lessons
•
ADO.NET Enhancements in the .NET Framework
2.0
•
SQL Server Provider Statistics
Lab
3: Enhancing Database Performance
•
Exercise 1. Accessing Multiple Result Sets
Concurrently
•
Exercise 2. Performing Asynchronous Data
Access Operations
•
Exercise 3. Performing a Batch Update
•
Exercise 4. Performing a Bulk Data Copy
After
completing this unit, students will be able to:
•
Describe the ADO.NET enhancements in
Microsoft .NET Framework 2.0.
•
Describe the support for run-time
statistics in the .NET Framework Data Provider for SQL Server.
•
Access multiple result sets concurrently.
•
Perform asynchronous data access
operations.
•
Perform a batch update.
•
Perform a bulk data copy.
Unit 4:
Creating Managed Code Objects for SQL Server 2005
This
unit describes how to create database objects for SQL Server 2005 in a .NET
Framework programming language. It describes how to create stored procedures,
triggers, user-defined functions, aggregates, and user-defined types in managed
code. Additionally, it describes how to deploy an assembly that contains
managed objects into SQL Server 2005, and how to declare database objects to
reference the managed objects.
Lessons
•
The Benefits of Creating Managed Code
Objects
•
Demonstration: The Process for Importing an
Existing Assembly into SQL Server 2005
•
Demonstration: The Process for Implementing
Managed Code Objects in SQL Server 2005
Lab
4: Creating Managed Code Objects for SQL Server 2005
•
Exercise 1. Creating Managed Stored
Procedures and Triggers
•
Exercise 2. Creating Managed User-Defined
Functions
•
Exercise 3. Creating a Managed Aggregate
•
Exercise 4. Creating a Managed User-Defined
Type
•
Exercise 5. Importing Existing Assemblies
into SQL Server 2005 (if time permits)
After
completing this unit, students will be able to:
•
Describe the benefits of creating managed
code objects for SQL Server 2005.
•
Explain the process for importing an
existing assembly into SQL Server 2005.
•
Explain the process for implementing managed
code objects in SQL Server 2005.
•
Create managed stored procedures and
triggers.
•
Create managed user-defined functions.
•
Create a managed aggregate.
•
Create a managed user-defined type.
Unit 5:
Querying XML by Using XPath
This
unit describes how to use XPath in a .NET Framework application. It describes
how to create an XPathNavigator object on an XML document, and how to locate
content and evaluate expressions by using the XPathNavigator object.
Additionally, it describes how to edit XML data by using the XPathNavigator
object.
Lessons
•
The XPath Data Model
•
The Process for Selecting and Editing XML
Data by Using XPathNavigator
•
The Process for Evaluating XPath
Expressions by Using XPathNavigator
Lab
5: Querying XML by Using XPath
•
Exercise 1. Selecting XML Data by Using
XPathNavigator
•
Exercise 2. Evaluating XPath Expressions by
Using XPath Navigator
•
Exercise 3. Creating and Using Compiled
XPath Expressions
•
Exercise 4. Editing XML Data by Using
XPathNavigator
After
completing this unit, students will be able to:
•
Describe the XPath data model.
•
Explain the process for selecting and
editing XML data by using XPathNavigator.
•
Explain the process for evaluating XPath
expressions by using XPathNavigator.
•
Select XML data by using XPathNavigator.
•
Evaluate XPath expressions by using
XPathNavigator.
•
Create and use compiled XPath expressions.
•
Edit XML data by using XPathNavigator.
Unit 6:
Transforming XML by Using XSLT Style Sheets
This
unit describes how to transform XML documents in a .NET Framework application.
It introduces how to load an XSLT style sheet in an application, and how to
execute the style sheet to transform an XML document. The unit also describes
how to pass parameters into a style sheet, and how to create and use extension
objects.
Lessons
•
What Is XSLT?
•
The Process for Executing an XSLT Style
Sheet
•
What Are Extension Objects?
Lab
6: Transforming XML by Using XSLT Style Sheets
•
Exercise 1. Transforming an XML Document by
Using an XSLT Style Sheet
•
Exercise 2. Resolving External Resources
During XSLT Processing
•
Exercise 3. Passing Parameters into an XSLT
Style Sheet
•
Exercise 4: Creating and Using Extension
Objects
After
completing this unit, students will be able to:
•
Describe the purpose of XSLT.
•
Explain the process for executing an XSLT
style sheet.
•
Describe the purpose of extension objects.
•
Transform an XML document by using an XSLT
style sheet.
•
Resolve external resources during XSLT
processing.
•
Pass parameters into an XSLT style sheet.
•
Create and use extension objects.
Solutient
Corporation of Ohio
6133
Rockside Road, Suite 100 – Cleveland, OH
44131
FOR
MORE INFORMATION, CALL 216-654-0025