Chapter 5 : Configuring Connections and Connecting to Data

Lesson 0: ADO.NET introduce Lesson 1: Creating and Configuring Connection Objects Lesson 2: Connecting to Data Using Connection Objects Lesson 3: Working with Connection Pools Lesson 4: Handling Connection Errors Lesson 5: Enumerating the Available SQL Servers on a Network

1

Overview of ADO.NET with the .NET Framework

Introdution to ADO.NET Introdution to ADO.NET

Universal Data Access (UDA)
Microsoft’s strategy for accessing data for multiple providers Goal is to access any type of data from any application on any type of computer

Introdution to ADO.NET Introdution to ADO.NET

2

OLEDB
Technology designed to implement the UDA concept Provides an standardized object-oriented interface Allows access data from any source Library functions Hard to use
Introdution to ADO.NET Introdution to ADO.NET

ADO.NET
ActiveX Data Objects ActiveX Data Objects ADO ADO

Important Core of the .NET Framework
Microsoft’s