MS2541 Core Data Access with Microsoft Visual Studio 2005

Corporate and Independent Software Vendor (ISV) application developers who have a desire to learn more about specific technology areas in distributed application development.

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.

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

Unit 1: Connecting to Databases and Reading Data

Unit 2: Querying and Updating Databases by Using Commands

Unit 3: Performing Transactional Operations

Unit 4: Performing Disconnected Operations Programmatically

Unit 5: Performing Disconnected Operations by Using Visual Studio 2005 Wizards

Unit 6: Performing XML Operations on Disconnected Data

Unit 7: Reading and Writing XML Data

Unit 8: Processing XML Data by Using DOM