Getting Started With ADO.NET Connections and Commands

This course is included in our On-demand training solution.


ADO.NET allows developers to create applications that are driven by data and services. This course identifies the various ways to manage ADO.NET connections and also details how to access data by using command objects and the DataReader object. Specific topics covered in the course include and introduction to ADO.NET, defining ADO.NET Connection objects, managing connections with Visual Basic 2008, and using ADO.NET command objects and DataReaders. This course is one of a series in the SkillSoft learning path that covers the objectives for the Technology Specialist (TS): Microsoft .NET Framework 3.5, ADO.NET Application Development 70-561. Passing this exam will earn the learner credit towards the MCTS: .NET Framework 3.5, ADO.NET Applications certification.

Target Audience

All organizations or individual consultants who are building or intend to build .NET Framework 3.5 applications with ADO.NET, Visual Studio 2008 and Visual Basic 2008; corporate employees, consultants, and university or college students who are preparing for the Technology Specialist (TS): Microsoft .NET Framework 3.5, ADO.NET Application Development 70-561.


Thorough knowledge of software-development concepts and the process of building business applications; experience building data applications with the Microsoft .NET Framework; working experience of Visual Studio 2008, Visual Basic 2008, and ADO.NET 3.5.

Expected Duration

120 min.

Course Objectives

Introduction to ADO.NET

  • identify the features, capabilities, and benefits of ADO.NET
  • identify the components and uses of the ADO.NET object model, the DataSet object, and data providers
  • identify the uses and benefits of LINQ and the Entity Framework
  • Defining an ADO.NET Connection Object

  • select the appropriate .NET data provider in a given scenario
  • identify the steps for setting the ConnectionString property
  • identify the features of the ConnectionString property’s provider-specific attributes
  • Managing Connections With Visual Basic 2008

  • identify ways to open and close connections
  • recognize ways for handling connection events
  • recognize the code for handling typical exceptions
  • Managing ADO.NET Connections with Visual Basic 2008

    Using ADO.NET Commands and DataReaders

  • recognize the steps for creating a command to retrieve a single value from a data source
  • recognize the uses of DataReader properties and methods and the steps for retrieving a result set from a database
  • name the different ways of processing rows of read-only data
  • identify the code for using ExecuteXmlReader for returning an XML stream
  • Working with ADO.NET Commands using Visual Basic 2008