Building ADO.NET DataSets with C#


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



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

Lesson Objectives

Building ADO.NET DataSets with C#

  • 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