Configuration.ConnectionStrings Propriedade

Definição

Namespace:

System.Configuration

Assembly:

System.Configuration.ConfigurationManager.dll

Pacote:

System.Configuration.ConfigurationManager v8.0.0

Origem:

Configuration.cs

Obtém um objeto da seção de configuração ConnectionStringsSection que se aplica a esse objeto 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

Valor da propriedade

ConnectionStringsSection

Um objeto da seção de configuração ConnectionStringsSection que representa a seção de configuração connectionStrings que se aplica a esse objeto Configuration.

Exemplos

O exemplo de código a seguir demonstra como usar a ConnectionStrings propriedade .

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

Comentários

Use a ConnectionStrings propriedade para acessar e alterar a connectionStrings seção de configuração definida no arquivo de configuração aberto.