ConnectionStringsSection.ConnectionStrings Property

Definition

Namespace:

System.Configuration

Assembly:

System.Configuration.ConfigurationManager.dll

Source:

ConnectionStringsSection.cs

Gets a ConnectionStringSettingsCollection collection of ConnectionStringSettings objects.

public:
 property System::Configuration::ConnectionStringSettingsCollection ^ ConnectionStrings { System::Configuration::ConnectionStringSettingsCollection ^ get(); };

public System.Configuration.ConnectionStringSettingsCollection ConnectionStrings { get; }

member this.ConnectionStrings : System.Configuration.ConnectionStringSettingsCollection

Public ReadOnly Property ConnectionStrings As ConnectionStringSettingsCollection

Property Value

ConnectionStringSettingsCollection

A ConnectionStringSettingsCollection collection of ConnectionStringSettings objects.

Examples

The following example shows how to use the ConnectionStrings property of the ConnectionStringsSection object.

static void ShowConnectionStrings()
{
    // Get the application configuration file.
    System.Configuration.Configuration config =
            ConfigurationManager.OpenExeConfiguration(
            ConfigurationUserLevel.None);

    // Get the connectionStrings section.
    ConnectionStringsSection csSection =
        config.ConnectionStrings;

    for (int i = 0; i <
        ConfigurationManager.ConnectionStrings.Count; i++)
    {
        ConnectionStringSettings cs =
            csSection.ConnectionStrings[i];

        Console.WriteLine($"  Connection String: \"{cs.ConnectionString}\"");

        Console.WriteLine($"#{i}");
        Console.WriteLine($"  Name: {cs.Name}");

        Console.WriteLine($"  Provider Name: {cs.ProviderName}");
    }
}

Shared Sub ShowConnectionStrings() 

    ' Get the application configuration file.
    Dim config _
    As System.Configuration.Configuration = _
    ConfigurationManager.OpenExeConfiguration( _
    ConfigurationUserLevel.None)

    ' Get the conectionStrings section.
    Dim csSection _
    As ConnectionStringsSection = _
    config.ConnectionStrings
    
    For i As Integer = 0 To ConfigurationManager.ConnectionStrings.Count - 1
        Dim cs As ConnectionStringSettings = _
        csSection.ConnectionStrings(i)
        
        Console.WriteLine( _
        "  Connection String: ""{0}""", cs.ConnectionString)
        Console.WriteLine("#{0}", i)
        Console.WriteLine("  Name: {0}", cs.Name)
        
        Console.WriteLine( _
        "  Provider Name: {0}", cs.ProviderName)

    Next i

End Sub

See also

• ConnectionStringSettingsCollection
• ConnectionStringSettings