Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition

Chapter 3. Connecting to Your Database

In this chapter:

Creating SqlConnection Objects

Opening SqlConnection Objects

Closing SqlConnection Objects

Cleaning Up After Yourself

Connection Strings

Connection Pooling

Using the SqlConnection as a Starting Point

Visual Studio Design-Time Features

SqlConnection Object Reference

Questions That Should Be Asked More Frequently

Part of building a database application requires that you connect to your data source and manage that connection. In the ADO.NET object model, a Connection object represents a connection to your data source. Connection objects also serve as a starting point for creating queries and transactions.

This chapter will serve as your guide to using Connection objects by explaining the major features ...