Chapter 9. Getting Connected

Introduction

Connectivity StrategiesThat Include Security

Configuring the Server and Firewall

Connection Strategies

Establishing a Connection

Writing Code to Create Connections

Understanding and Managing the Connection Pool

Building a ConnectionString for Other Providers

Getting Visual Studio to Build Your ConnectionString

Opening and Closing Connections (Semi-) Automatically

Understanding the Connection Properties

Using the Connection Methods

Handling Connection Events

Managing Connection Exceptions

Summary