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 ...