M2389: Programming with Microsoft ADO.NET

3 Day Course
Hands On
Official Microsoft Curriculum
Code M2389

This course has been retired in favour of the newer ADO.NET 3.5 course.

Modules

Hide all

Data-Centric Applications and ADO.NET (4 topics)

  • Design of Data-Centric Applications
  • ADO.NET Architecture
  • ADO.NET and XML

Connecting to Data Sources (6 topics)

  • Choosing a .NET Data Provider
  • Defining a Connection
  • Managing a Connection
  • Handling Coonection Exceptions
  • Connection Pooling

Performing Connected Database Operations (7 topics)

  • Working in a Connected Environment
  • Building Command Objects
  • Executing Commands That Return a Single Value
  • Executing Commands That Return Rows
  • Executing Commands That Do Not Return Rows
  • Using Transactions

Building DataSets (7 topics)

  • Working in a Disconnected Environment
  • Building DataSets and DataTables
  • Binding and Saving a DataSet
  • Defining Data Relationships
  • Modifying Data in a DataTable
  • Sorting and Filtering

Reading and Writing XML with ADO.NET (4 topics)

  • Creating XSD Schemas
  • Loading Schemas and Data into DataSets
  • Writing XML from a DataSet

Building DataSets from Existing Data Sources (6 topics)

  • Configuring a DataAdapter to Retrieve Information
  • Populating a DataSet Using a DataAdapter
  • Configuring a DataAdapter to Update the Underlying Data Source
  • Persisting Changes to a Data Source
  • How to Handle Conflicts

Building and Consuming a Web Service That Uses ADO.NET (1 topic)

  • Building and Consuming a Web Service That Returns Data

Prerequisites

The course assumes that students have the following skills:
  • Understanding of relational database concepts: table, row, column, primary keys, foreign keys, constraints, and views
  • Data query and modification experience, including experience with SELECT, INSERT, UPDATE, and DELETE commands
  • Exposure to XML documents, style sheets, and schemas
  • Experience with Visual Basic .NET, Visual Basic for Applications, or previous versions of Visual Basic
  • Experience building user interfaces, including Web applications or Microsoft Windows® applications

Relevant Certifications

Sections