Removes the entry with the specified key from the System.Data.SqlClient.SqlConnectionStringBuilder instance.
- keyword
The key of the key/value pair to be removed from the connection string in this System.Data.SqlClient.SqlConnectionStringBuilder.
![]()
true if the key existed within the connection string and was removed; false if the key did not exist.
Because the Remove method returns a value that indicates its success, it is not required to look for a key before trying to remove the key/value pair from the System.Data.SqlClient.SqlConnectionStringBuilder instance. Because the System.Data.SqlClient.SqlConnectionStringBuilder maintains a fixed-size collection of key/value pairs, calling the SqlConnectionStringBuilder.Remove(string) method simply resets the value of the key/value pair back to its default value.
Because the collection of keys supported by the System.Data.SqlClient.SqlConnectionStringBuilder is fixed, every item within the collection has a known default value. The following table lists the keys, and the value for each when the System.Data.SqlClient.SqlConnectionStringBuilder is first initialized, or after the SqlConnectionStringBuilder.Remove(string) method has been called.
| Application Name |
".Net SqlClient Data Provider" |
| Asynchronous Processing |
False |
| AttachDBFilename |
Empty string |
| Connection Timeout |
15 |
| Context Connection |
False |
| Current Language |
Empty string |
| Data Source |
Empty string |
| Encrypt |
False |
| Enlist |
True |
| Failover Partner |
Empty string |
| Initial Catalog |
Empty string |
| Integrated Security |
False |
| Load Balance Timeout |
0 |
| Max Pool Size |
100 |
| Min Pool Size |
0 |
| MultipleActiveResultSets |
False |
| Network Library |
Empty string |
| Packet Size |
8000 |
| Password |
Empty string |
| Persist Security Info |
False |
| Pooling |
True |
| Replication |
False |
| Transaction Binding |
Implicit Unbind |
| User ID |
Empty string |
| User Instance |
False |
| Workstation ID |
Empty string |