Chapter 4. Advanced Connectivity to the Data Store

Chapter 2 explained how to create a DbConnection object and communicate to the data store as quickly and easily as possible. This chapter explores some of the more advanced connectivity options and best practices by looking at connection pooling, clustered connections, and asynchronous access. But first we examine the ConnectionStringBuilder object, which we use throughout this chapter when implementing these advanced options.

Building Accurate Connection Strings

You’ll often want to prompt the user for information that will be used to build a connection string. For example, when the user starts your application for the first time or before you grant the user the ability to export data from one ...

Get Programming Microsoft® ADO.NET 2.0 Applications: Advanced Topics now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.