Assembly: System.Data (in System.Data.dll)
The returned ICollection is not a static copy; instead, the ICollection refers back to the values in the original DbConnectionStringBuilder. Therefore, changes to the DbConnectionStringBuilder are reflected in the ICollection.
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.
Sub Main() Dim builder As New DbConnectionStringBuilder builder.ConnectionString = _ "Provider=MSDataShape.1;Persist Security Info=False;" & _ "Data Provider=MSDAORA;Data Source=orac;" & _ "user id=username;password=*******" For Each value As String In builder.Values Console.WriteLine(value) Next End Sub
Displays the following output:
MSDataShape.1 false MSDAORA orac username *******
Available since 10
Available since 2.0