Building ADO.NET DataSets

Overview/Description
To describe how to use ADO.NET's disconnected DataSet object model, including DataSets, DataAdapters, DataTables, DataRelations, DataRows, and DataColumns

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
140 Minutes

Objectives:

Building ADO.NET DataSets

  • compare and contrast connected and disconnected data access strategies in ADO.NET.
  • identify the main properties and constituent objects of the DataSet class, the role of constraints, relations, and views, and strategies for using DataSets.
  • identify the steps to create and configure a specific DataAdapter.
  • select the steps to populate a specific DataSet using a DataAdapter.
  • identify the steps to create a DataSet with defined properties in given scenario.
  • create a DataSet with DataTables and custom expression columns.
  • identify the steps to use an XSD schema with DataSets in a given scenario.


    • Course Number: 129901_eng