Hitchhikers Guide to Visual Studio and SQL Server: Best Practice Architectures and Examples, 7th Edition (Microsoft Windows Server System Series)

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