DbConnectionStringBuilder.ConnectionString Propriedade
Definição
Obtém ou define a cadeia de conexão associada a DbConnectionStringBuilder.Gets or sets the connection string associated with the DbConnectionStringBuilder.
public:
property System::String ^ ConnectionString { System::String ^ get(); void set(System::String ^ value); };
public string ConnectionString { get; set; }
member this.ConnectionString : string with get, set
Public Property ConnectionString As String
Valor da propriedade
A cadeia de conexão atual, criada de pares chave-valor contidos dentro de DbConnectionStringBuilder.The current connection string, created from the key/value pairs that are contained within the DbConnectionStringBuilder. O valor padrão é uma cadeia de caracteres vazia.The default value is an empty string.
Exceções
Um argumento de cadeia de conexão inválido foi fornecido.An invalid connection string argument has been supplied.
Exemplos
O exemplo a seguir demonstra os possíveis comportamentos da ConnectionString propriedade.The following example demonstrates possible behaviors of the ConnectionString property. O exemplo:The example:
Cria uma cadeia de conexão adicionando pares de chave/valor, um de cada vez, a um vazio DbConnectionStringBuilder .Creates a connection string by adding key/value pairs, one at a time, to an empty DbConnectionStringBuilder.
Atribui uma cadeia de conexão completa à ConnectionString propriedade da DbConnectionStringBuilder instância e modifica um único par de chave/valor dentro da cadeia de caracteres.Assigns a complete connection string to the ConnectionString property of the DbConnectionStringBuilder instance, and modifies a single key/value pair within the string.
Atribui um conjunto arbitrário de pares de chave/valor à ConnectionString Propriedade (ou seja, uma cadeia de caracteres que não seja algo de forma remota, como uma cadeia de conexão), e modifica um dos valores.Assigns an arbitrary set of key/value pairs to the ConnectionString property (that is, a string that is not anything remotely like a connection string), and modifies one of the values.
Atribui uma cadeia de conexão inválida à ConnectionString propriedade, demonstrando a exceção que é lançada.Assigns an invalid connection string to the ConnectionString property, demonstrating the exception that is thrown.
Observação
Este exemplo inclui uma senha para demonstrar como o DbConnectionStringBuilder funciona com cadeias de conexão.This example includes a password to demonstrate how DbConnectionStringBuilder works with connection strings. Em seus aplicativos, recomendamos que você use a autenticação do Windows.In your applications, we recommend that you use Windows Authentication. Se você precisar usar uma senha, não inclua uma senha embutida em código em seu aplicativo.If you must use a password, do not include a hard-coded password in your application.
static void Main()
{
// Create a new DbConnctionStringBuilder, and add items
// to the internal collection of key/value pairs.
DbConnectionStringBuilder builder = new
DbConnectionStringBuilder();
builder.Add("Data Source", @"c:\MyData\MyDb.mdb");
builder.Add("Provider", "Microsoft.Jet.Oledb.4.0");
builder.Add("Jet OLEDB:Database Password", "********");
builder.Add("Jet OLEDB:System Database",
@"c:\MyData\Workgroup.mdb");
// Set up row-level locking.
builder.Add("Jet OLEDB:Database Locking Mode", 1);
// Display the contents of the connection string, which
// will now contain all the key/value pairs delimited with
// semicolons.
Console.WriteLine(builder.ConnectionString);
Console.WriteLine();
// Clear the DbConnectionStringBuilder, and assign a complete
// connection string to it, to demonstrate how
// the class parses connection strings.
builder.Clear();
builder.ConnectionString =
"Data Source=(local);Initial Catalog=AdventureWorks;"
+ "Integrated Security=SSPI";
// The DbConnectionStringBuilder class has parsed the contents,
// so you can work with any individual key/value pair.
builder["Data Source"] = ".";
Console.WriteLine(builder.ConnectionString);
Console.WriteLine();
// Because the DbConnectionStringBuilder class doesn't
// validate its key/value pairs, you can use this class
// to store any semicolon-delimited list. The following
// snippet places an arbitrary string into the ConnectionString
// property, changes one of the values, and then displays the
// resulting string.
builder.Clear();
builder.ConnectionString =
"Value1=10;Value2=20;Value3=30;Value4=40";
builder["Value2"] = 25;
Console.WriteLine(builder.ConnectionString);
Console.WriteLine();
builder.Clear();
try
{
// Assigning an invalid connection string
// throws an ArgumentException.
builder.ConnectionString = "xxx";
}
catch (ArgumentException)
{
Console.WriteLine("Invalid connection string.");
}
Console.WriteLine();
Console.WriteLine("Press Enter to finish.");
Console.ReadLine();
}
Sub Main()
' Create a new DbConnctionStringBuilder, and add items
' to the internal collection of key/value pairs.
Dim builder As New DbConnectionStringBuilder()
builder.Add("Data Source", "c:\MyData\MyDb.mdb")
builder.Add("Provider", "Microsoft.Jet.Oledb.4.0")
builder.Add("Jet OLEDB:Database Password", "*******")
builder.Add("Jet OLEDB:System Database", _
"c:\MyData\Workgroup.mdb")
' Set up row-level locking.
builder.Add("Jet OLEDB:Database Locking Mode", 1)
' Display the contents of the connection string, which
' will now contain all the key/value pairs delimited with
' semicolons.
Console.WriteLine(builder.ConnectionString)
Console.WriteLine()
' Clear the DbConnectionStringBuilder, and assign a complete
' connection string to it, to demonstrate how
' the class parses connection strings.
builder.Clear()
builder.ConnectionString = _
"Data Source=(local);Initial Catalog=AdventureWorks;" & _
"Integrated Security=SSPI"
' The DbConnectionStringBuilder class has parsed the contents,
' so you can work with any individual key/value pair.
builder("Data Source") = "."
Console.WriteLine(builder.ConnectionString)
Console.WriteLine()
' Because the DbConnectionStringBuilder class doesn't
' validate its key/value pairs, you can use this class
' to store any semicolon-delimited list. The following
' snippet places an arbitrary string into the ConnectionString
' property, changes one of the values, and then displays the
' resulting string.
builder.Clear()
builder.ConnectionString = _
"Value1=10;Value2=20;Value3=30;Value4=40"
builder("Value2") = 25
Console.WriteLine(builder.ConnectionString)
Console.WriteLine()
builder.Clear()
Try
' Assigning an invalid connection string
' throws an ArgumentException.
builder.ConnectionString = "xxx"
Catch ex As ArgumentException
Console.WriteLine("Invalid connection string.")
End Try
Console.WriteLine()
Console.WriteLine("Press Enter to finish.")
Console.ReadLine()
End Sub
Comentários
Essa propriedade retorna uma lista delimitada por ponto-e-vírgula de pares de chave/valor armazenados na coleção mantida pelo DbConnectionStringBuilder .This property returns a semicolon-delimited list of key/value pairs stored within the collection maintained by the DbConnectionStringBuilder. Cada par contém a chave e o valor, separados por um sinal de igual.Each pair contains the key and value, separated by an equal sign. O exemplo a seguir ilustra uma cadeia de conexão típica.The following example illustrates a typical connection string.
"Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=AdventureWorks;Data Source=(local)"
Os provedores de dados podem esperar chaves e valores específicos para cada propriedade de cadeia de conexão.Data providers may expect specific keys and values for each connection string property. , Esses valores são documentados individualmente., These values are documented individually. A DbConnectionStringBuilder classe não valida os pares de chave/valor associados à sua cadeia de conexão, embora classes que herdam dele possam.The DbConnectionStringBuilder class does not validate the key/value pairs associated with its connection string, although classes that inherit from it can.
A ConnectionString propriedade da DbConnectionStringBuilder classe age geralmente como um mecanismo para criar e analisar listas delimitadas por ponto e vírgula de pares de chave/valor separados por sinais de igualdade.The ConnectionString property of the DbConnectionStringBuilder class acts generally as a mechanism for creating and parsing semicolon-delimited lists of key/value pairs separated with equal signs. Ele não fornece validação ou outro suporte específico para cadeias de conexão.It provides no validation or other support specific to connection strings. Se você adicionar itens à DbConnectionStringBuilder coleção, a ConnectionString propriedade refletirá as alterações.If you add items to the DbConnectionStringBuilder collection, the ConnectionString property will reflect the changes. Se você atribuir um valor à ConnectionString propriedade, o DbConnectionStringBuilder tentará analisar o valor usando o ponto e vírgula e os delimitadores de sinal de igual.If you assign a value to the ConnectionString property, the DbConnectionStringBuilder will try to parse the value, using the semicolon and equal-sign delimiters.