2541 Core Data Access with Microsoft Visual Studio 2005

Overview

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.

After course completion, students will be able to connect databases and read data, and query and update databases by using commands. Students will also be able to perform transactional operations, disconnected operations programmatically, and disconnected operations by using Visual Studio 2005 wizards. They will also be able to confidently perform XML operations on disconnected data, read and write XML, and process XML data by using the Document Object Model DOM.

Outline

I. Connecting to Databases and Reading Data
II. Querying and Updating Databases by using Commands
III. Performing Transactional Operations
IV. Performing Disconnected Operations Programmatically
V. Performing Disconnected Operations by Using Visual Studio 2005 Wizards
VI. Performing XML Operations on Disconnected Data
VII. Reading and Writing XML Data
VIII. Processing XML Data by Using DOM

Course Length

3 days

Audience

This course is intended for current application developers who have a desire to learn more about specific technology areas in distributed application development. 

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. They should be able to understand the .NET Framework 2.0 and the Common Language Runtime and be able to program an application using a .NET Framework 2.0 compliant language. Additionally, students are expected to know how to make assemblies available to other applications, have a good understanding of XML including XML declaration, elements, attributes and namespaces. They should also be able to explain XML schema concepts.