Configuration.ConnectionStrings Proprietà

Definizione

Spazio dei nomi:

System.Configuration

Assembly:

System.Configuration.ConfigurationManager.dll

Pacchetto:

System.Configuration.ConfigurationManager v8.0.0

Source:

Configuration.cs

Ottiene un oggetto sezione di configurazione ConnectionStringsSection valido per questo oggetto Configuration.

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 sezione di configurazione ConnectionStringsSection che rappresenta la sezione di configurazione connectionStrings valida per questo oggetto Configuration.

Esempio

Nell'esempio di codice seguente viene illustrato come usare 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 proprietà per accedere e modificare la ConnectionStringsconnectionStrings sezione di configurazione definita nel file di configurazione aperto.