Summary

This (long) chapter dissected the SqlConnection object and the mechanisms ADO.NET and the SqlClient .NET Data Provider implement to manage, pool, and dismantle connections. So many features are enabled, hidden, exposed, or disabled by use of the SqlConnection properties (especially the ConnectionString) that we had to spend a long time working through this content. Once you're connected to SQL Serverregardless of the versionyou're ready to start executing queries. Remember, the SqlConnection object is also the place where InfoMessage events are returned, as well as some SQL Server errorsso be ready. Next stop is the SqlCommand object.