Advanced ADO.NET Programming with C#


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



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 (hours)
3.3

Lesson Objectives

Advanced ADO.NET Programming with C#

  • 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