2541 Core Data Access with Microsoft Visual Studio 2005 - Class Outline

Print Preview \| E-Mail Outline

2541 Core Data Access with Microsoft Visual Studio 2005 Duration: Traditional Instructor Led Learning - 3.00 Day(s) Online Live - 3.00 Sessions Mentored Learning - Flexible Overview: This 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. Who Should Attend: 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 Course Completion: 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.
Prerequisite Comments:
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

Outline:	Top
Lesson 1: Connecting to Databases and Reading Data
What Is ADO.NET? The Process for Connecting to a Database and Reading Data What Is Connection Pooling?	Top
Lesson 2: Querying and Updating Databases by Using Commands
ADO.NET Commands The Process for Passing Parameters into Commands
Lesson 3: Performing Transactional Operations
What Is a Transaction? The Process for Managing Local Transactions The Process for Managing Distributed Transactions Isolation Levels
Lesson 4: Performing Disconnected Operations Programmatically
What Is the ADO.NET Disconnected Model? The Process for Loading and Saving Data in a DataSet What Are DataViews?
Lesson 5: Performing Disconnected Operations by Using Visual Studio 2005 Wizards
Comparing Untyped DataSets with Typed DataSets What Are Table Adapters? Demonstration: Creating a Typed DataSet by Using Visual Studio 2005 Wizards	Top
Lesson 6: Performing XML Operations on Disconnected Data
XML Representations of DataSets What Are DiffGrams?
Lesson 7: Reading and Writing XML Data
The Process for Serially Reading XML Data The Process for Serially Writing XML Data
Lesson 8: Processing XML Data by Using DOM
What Is DOM? What Are DOM Trees? Types of XML Nodes in a DOM Tree

*Content, days, and times vary depending on your location. Please view the outline on the checkout page prior to purchase or
contact the local center for more information.