Gets or sets the connection string associated with the DbConnectionStringBuilder.
Assembly: System.Data (in System.Data.dll)
An invalid connection string argument has been supplied.
This property returns a semicolon-delimited list of key/value pairs stored within the collection maintained by the DbConnectionStringBuilder. Each pair contains the key and value, separated by an equal sign. The following example illustrates a typical connection string.
"Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=AdventureWorks;Data Source=(local)"
Data providers may expect specific keys and values for each connection string property. , These values are documented individually. The DbConnectionStringBuilder class does not validate the key/value pairs associated with its connection string, although classes that inherit from it can.
The property of the DbConnectionStringBuilder class acts generally as a mechanism for creating and parsing semicolon-delimited lists of key/value pairs separated with equal signs. It provides no validation or other support specific to connection strings. If you add items to the DbConnectionStringBuilder collection, the property will reflect the changes. If you assign a value to the property, the DbConnectionStringBuilder will try to parse the value, using the semicolon and equal-sign delimiters.
The following example demonstrates possible behaviors of the property. The example:
Creates a connection string by adding key/value pairs, one at a time, to an empty DbConnectionStringBuilder.
Assigns a complete connection string to the property of the DbConnectionStringBuilder instance, and modifies a single key/value pair within the string.
Assigns an arbitrary set of key/value pairs to the property (that is, a string that is not anything remotely like a connection string), and modifies one of the values.
Assigns an invalid connection string to the property, demonstrating the exception that is thrown.
This example includes a password to demonstrate how DbConnectionStringBuilder works with connection strings. In your applications, we recommend that you use Windows Authentication. If you must use a password, do not include a hard-coded password in your application.