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 *******
Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows XP SP2 x64 Edition, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.