Managing ADO.NET Connections and Commands with VB 2008

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


ADO.NET connections and commands are crucial components of building data-driven applications. This course examines managing connections using connection pools and configuration files, as well as stored procedures, and using generic data-access code to establish a connection. Specific topics covered include optimizing ADO.NET connections and commands, ADO.NET transactions, and working with Multiple Active Result Sets (MARS) and asynchronous commands.
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

180 min.

Course Objectives

Optimizing Data Connections with Visual Basic 2008

  • identify ways to pool connections
  • recognize the steps for retrieving a connection string from a configuration file
  • identify the steps for monitoring connection resources
  • Using Stored Procedures and Statements with Parameters

  • recognize the code for using parameters with SQL statements
  • recognize the steps for using the ExecuteNonQuery method
  • identify the steps for creating a stored procedure with parameters
  • Managing Generic Data Access

  • recognize how to use the DBProviderFactory, DbConnection, DbCommand, and DbException objects
  • identify the steps for using generic data access code to retrieve provider information
  • Coding Generic Data Access

    Managing ADO.NET Transactions with Visual Basic 2008

  • recognize how the .NET Framework APIs can be used to configure transactions
  • identify the code for implementing implicit and explicit transactions and for managing concurrency
  • recognize the ways for managing and implementing transactions using the System.Transaction namespace
  • Implementing ADO.NET Transactions

    Working with Multiple Active Result Sets (MARS)

  • recognize the steps and considerations for enabling and using MARS
  • identify the code for using MARS to manipulate data
  • Executing Commands Asynchronously

  • identify the uses of asynchronous design patterns in a given scenario
  • recognize how to poll an asynchronous operation, implement a callback, and monitor asynchronous operations
  • Handling Special Data Types

  • recognize the code for manipulating large objects
  • identify the code for moving large amounts of data
  • identify the benefits and uses of the SqlBulkCopy class
  • identify the code for populating a table-valued parameter
  • Working with MARS and Asynchronous Commands