Home > Courses Certifications > Programming > Course 2541 synopsis

2541- Core Data Access with Microsoft Visual Studio 2005

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
• 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

Duration: 3 days

Module 1: Connecting to Databases and Reading Data

• ADO.Net
• Connect and Read Data
• Creating a Connection
• Connection Events
• Connection Exceptions
• Connection Pooling
• Pool Settings

Module 2: Querying and Updating Databases

• ADO.Net Commands
• Command Properties
• Command Methods
• Bind Data to Control
• Pass Parameters to Command
• Parameter Properties
• Server Explorer

Module 3: Transactional Operations

• What is a Transaction?
• Transaction Support
• Transaction Characteristics
• Managing Local Transactions
• Local Transaction Example
• Managing Distributed Transactions
• Create Transaction
• Isolation
• Isolation Levels
• Isolation Matrix

Module 4: Disconnected Operations

• ADO.NET Disconnected Model
• Create DataSet Model
• Special Columns
• Constraints and Relations
• DataSet Relations
• Data Adapter
• Loading and Saving Data in a DataSet
• Data Adapter Properties
• Data Views
• Data View Properties

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

• Disconnected Datasets
• Untyped vs. Typed Datasets
• Tables in Typed Dataset
• Retrieve Data from a DataTable
• DataTable Methods
• DataTable Properties
• Table Adapters

Module 6: XML Operations on Disconnected Data

• XML and ADO.Net
• Work with XML and DataSets
• Diff Gram

Module 7: Reading and Writing XML Data

• Serially Reading XML Data
• Create XML Reader
• Sample XML Reader
• Serially Writing XML Data
• Create XML Writer
• Sample XML writer

Module 8: Processing XML Data by Using DOM

• What Is DOM?
• Load an XML Document
• What Are DOM Trees?
• Dom Tree
• XML Nodes in a DOM Tree
• XML Collection Classes