Getting Started with ADO.NET 4 Connections and Commands Using Visual Basic 2010

Overview/Description
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 an introduction to ADO.NET, defining ADO.NET Connection objects, managing connections with Visual Basic 2010, 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: Accessing Data with Microsoft .NET Framework 4 Exam 70-516. Passing this exam will earn the learner credit towards the MCTS: .NET Framework 4, Data Access certification.

Target Audience
All organizations or individual consultants who are using or intend to use the .NET Framework 4 with Visual Studio 2010 and Visual Basic 2010 to develop Windows Communication Foundation applications; corporate employees, consultants, and university or college students who are preparing for the associated Microsoft Technology Specialist: Windows Communication Foundation Development with Microsoft .NET Framework 4 exam (70-513).

Prerequisites
Thorough knowledge of software-development concepts and the process of building business applications; experience in building applications with the Microsoft .NET Framework; and working experience of Visual Studio 2010 and Visual Basic 2010.

Expected Duration (hours)
2.0

Lesson Objectives

Getting Started with ADO.NET 4 Connections and Commands Using Visual Basic 2010

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

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

identify ways to open and close connections

recognize ways for handling connection events

recognize the code for handling typical exceptions

select a data provider

configure a connection

encrypt data and add a user instance

handle connection events

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

work with Command objects

use a DataReader object

retrieve a single value from a data source

retrieve an XML data stream