learn something new
FIND A CLASS
Virtual Training Schedule
Map : Bloomington, IL
Map : Springfield, IL
Find a Class
> Class Summary
MS2542 - Advanced Data Access with Microsoft Visual Studio 2005
If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at
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).
Click here for a printer-friendly version of this page.
This course has not been scheduled yet. Please contact us by clicking the link below to learn about availability.
Contact us for additional availability.
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.
Detailed Class Syllabus
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
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
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
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
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
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
Copyright © 1996 - 2013 Levi, Ray & Shoup, Inc. All rights reserved. |
Trademark Information and Legal Disclaimers