Advanced ADO.NET Programming

Advanced ADO.NET Programming

Overview/Description
To explain how to modify DataSet data, update data sources, read and write XML data sources, and interact with ADO.NET

Target Audience
C# programmers and candidates for the Microsoft MCSD and MCAD certification paths

Prerequisites
A good knowledge of C# language, SQL, relational databases, and Visual Studio .NET

Expected Duration
200 Minutes

Objectives:

Advanced ADO.NET Programming

identify update strategies for the ADO.NET disconnected model.

identify the steps to perform transactions at a given level of security.

select the steps to update a datasource with a merged DataSet in a given scenario.

select the methods to handle update errors programmatically in a given scenario.

update a datasource securely using transactions and exception handling.

select the correct methods to read and write data from an XML data source to a DataSet and back in a given scenario.

select the steps to allow data in DataSets to be managed by XmlDataDocument services.

use XmlDataDocument services to manage DataSet data.

identify the differences between ADO and ADO.NET.

select the steps to enable managed code to use ADO objects.

Course Number: 129902_eng