Configuration.ConnectionStrings Proprietà

Definizione

Spazio dei nomi:

System.Configuration

Assembly:

System.Configuration.ConfigurationManager.dll

Origine:

Configuration.cs

Ottiene un ConnectionStringsSection oggetto della sezione di configurazione che si applica a questo Configuration oggetto.

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

public System.Configuration.ConnectionStringsSection ConnectionStrings { get; }

member this.ConnectionStrings : System.Configuration.ConnectionStringsSection

Public ReadOnly Property ConnectionStrings As ConnectionStringsSection

Valore della proprietà

ConnectionStringsSection

Oggetto ConnectionStringsSection della sezione di configurazione che rappresenta la connectionStrings sezione di configurazione applicabile a questo Configuration oggetto.

Esempio

Nell'esempio di codice seguente viene illustrato come utilizzare la ConnectionStrings proprietà .

ConnectionStringsSection
    conStrSection =
    config.ConnectionStrings as ConnectionStringsSection;
Console.WriteLine("Section name: {0}",
    conStrSection.SectionInformation.SectionName);

try
{
    if (conStrSection.ConnectionStrings.Count != 0)
    {
        Console.WriteLine();
        Console.WriteLine("Using ConnectionStrings property.");
        Console.WriteLine("Connection strings:");

        // Get the collection elements.
        foreach (ConnectionStringSettings connection in
          conStrSection.ConnectionStrings)
        {
            string name = connection.Name;
            string provider = connection.ProviderName;
            string connectionString = connection.ConnectionString;

            Console.WriteLine("Name:               {0}",
              name);
            Console.WriteLine("Connection string:  {0}",
              connectionString);
            Console.WriteLine("Provider:            {0}",
               provider);
        }
    }
}
catch (ConfigurationErrorsException e)
{
    Console.WriteLine("Using ConnectionStrings property: {0}",
        e.ToString());
}

Dim conStrSection As ConnectionStringsSection = TryCast(config.ConnectionStrings, ConnectionStringsSection)
Console.WriteLine("Section name: {0}", conStrSection.SectionInformation.SectionName)

Try
    If conStrSection.ConnectionStrings.Count <> 0 Then
        Console.WriteLine()
        Console.WriteLine("Using ConnectionStrings property.")
        Console.WriteLine("Connection strings:")

        ' Get the collection elements.
        For Each connection As ConnectionStringSettings In conStrSection.ConnectionStrings
            Dim name As String = connection.Name
            Dim provider As String = connection.ProviderName
            Dim connectionString As String = connection.ConnectionString

            Console.WriteLine("Name:               {0}", name)
            Console.WriteLine("Connection string:  {0}", connectionString)
            Console.WriteLine("Provider:            {0}", provider)
        Next connection
    End If
Catch e As ConfigurationErrorsException
    Console.WriteLine("Using ConnectionStrings property: {0}", e.ToString())
End Try

Commenti

Usare la ConnectionStrings proprietà per accedere e modificare la connectionStrings sezione di configurazione definita nel file di configurazione aperto.