SqlConnectionStringBuilder.InitialCatalog Eigenschaft

Definition

Ruft den Namen der Datenbank ab, die der Verbindung zugeordnet ist, oder legt einen Namen fest.Gets or sets the name of the database associated with the connection.

public:
 property System::String ^ InitialCatalog { System::String ^ get(); void set(System::String ^ value); };
[System.ComponentModel.TypeConverter(typeof(System.Data.SqlClient.SqlConnectionStringBuilder/SqlInitialCatalogConverter))]
public string InitialCatalog { get; set; }
member this.InitialCatalog : string with get, set
Public Property InitialCatalog As String

Eigenschaftswert

Der Wert der InitialCatalog-Eigenschaft bzw. String.Empty, wenn kein Wert angegeben wurde.The value of the InitialCatalog property, or String.Empty if none has been supplied.

Attribute

Ausnahmen

Verwenden Sie Value, um den Wert auf NULL festzulegen.To set the value to null, use Value.

Beispiele

Im folgenden Beispiel wird eine einfache Verbindungszeichenfolge erstellt, und anschließend wird der Verbindungszeichenfolge mithilfe der SqlConnectionStringBuilder-Klasse der Name der Datenbank hinzugefügt.The following example creates a simple connection string and then uses the SqlConnectionStringBuilder class to add the name of the database to the connection string. Im Code wird der Inhalt der InitialCatalog-Eigenschaft angezeigt, um zu überprüfen, ob die Klasse eine Konvertierung vom Synonym ("Database") in den entsprechenden Eigenschaftswert vornehmen konnte.The code displays the contents of the InitialCatalog property, just to verify that the class was able to convert from the synonym ("Database") to the appropriate property value.

using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        try
        {
            string connectString = "Data Source=(local);" +
                "Integrated Security=true";

            SqlConnectionStringBuilder builder = 
                new SqlConnectionStringBuilder(connectString);
            Console.WriteLine("Original: " + builder.ConnectionString);

            // Normally, you could simply set the InitialCatalog
            // property of the SqlConnectionStringBuilder object. This
            // example uses the default Item property (the C# indexer)
            // and the "Database" string, simply to demonstrate that
            // setting the value in this way results in the same
            // connection string:
            builder["Database"] = "AdventureWorks";
            Console.WriteLine("builder.InitialCatalog = " 
                + builder.InitialCatalog);
            Console.WriteLine("Modified: " + builder.ConnectionString);

            using (SqlConnection connection = 
                new SqlConnection(builder.ConnectionString))
            {
                connection.Open();
                // Now use the open connection.
                Console.WriteLine("Database = " + connection.Database);
            }

        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
        }

        Console.WriteLine("Press any key to finish.");
        Console.ReadLine();
    }
}
Imports System.Data.SqlClient
    
Module Module1
    Sub Main()
        Try
            Dim connectString As String = _
             "Data Source=(local);" & _
             "Integrated Security=True"

            Dim builder As New SqlConnectionStringBuilder(connectString)
            Console.WriteLine("Original: " & builder.ConnectionString)

            ' Normally, you could simply set the InitialCatalog
            ' property of the SqlConnectionStringBuilder object. This
            ' example uses the default Item property (the C# indexer)
            ' and the "Database" string, simply to demonstrate that
            ' setting the value in this way results in the same
            ' connection string.
            builder("Database") = "AdventureWorks"
            Console.WriteLine("builder.InitialCatalog = " _
                & builder.InitialCatalog)
            Console.WriteLine("Modified: " & builder.ConnectionString)

            Using connection As New SqlConnection(builder.ConnectionString)
                connection.Open()
                ' Now use the open connection.
                Console.WriteLine("Database = " & connection.Database)
            End Using

        Catch ex As Exception
            Console.WriteLine(ex.Message)
        End Try

        Console.WriteLine("Press any key to finish.")
        Console.ReadLine()
    End Sub
End Module

Hinweise

Diese Eigenschaft entspricht den Schlüsseln "Initial Catalog" und "database" in der Verbindungszeichenfolge.This property corresponds to the "Initial Catalog" and "database" keys within the connection string.

Gilt für:

Siehe auch