Ask Learn
Preview
Ask Learn is an AI assistant that can answer questions, clarify concepts, and define terms using trusted Microsoft documentation.
Please sign in to use Ask Learn.
Sign inThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Removes the entry with the specified key from the SqlConnectionStringBuilder instance.
public:
override bool Remove(System::String ^ keyword);
public override bool Remove(string keyword);
override this.Remove : string -> bool
Public Overrides Function Remove (keyword As String) As Boolean
The key of the key/value pair to be removed from the connection string in this SqlConnectionStringBuilder.
true
if the key existed within the connection string and was removed; false
if the key did not exist.
keyword
is null (Nothing
in Visual Basic)
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 SqlConnectionStringBuilder instance. Because the SqlConnectionStringBuilder maintains a fixed-size collection of key/value pairs, calling the Remove method simply resets the value of the key/value pair back to its default value.
Because the collection of keys supported by the 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 SqlConnectionStringBuilder is first initialized, or after the Remove method has been called.
Key | Default value |
---|---|
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 |
Product | Versions |
---|---|
.NET | Core 1.0, Core 1.1, 6 (package-provided), 7 (package-provided), 8 (package-provided), 9 (package-provided), 10 (package-provided) |
.NET Framework | 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1 |
.NET Standard | 2.0 (package-provided) |
.NET feedback
.NET is an open source project. Select a link to provide feedback:
Ask Learn is an AI assistant that can answer questions, clarify concepts, and define terms using trusted Microsoft documentation.
Please sign in to use Ask Learn.
Sign in