|
Workshop Overview
Elements of this syllabus
are subject to change.
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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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. |
