Export (0) Print
Expand All

SqlConnectionStringBuilder.InitialCatalog Property

Note: This property is new in the .NET Framework version 2.0.

Gets or sets the name of the database associated with the connection.

Namespace: System.Data.SqlClient
Assembly: System.Data (in system.data.dll)

public string InitialCatalog { get; set; 
/** @property */
public String get_InitialCatalog ()

/** @property */
public void set_InitialCatalog (String value)

public function get InitialCatalog () : String

public function set InitialCatalog (value : String)

Property Value

The value of the InitialCatalog property, or String.Empty if none has been supplied.

This property corresponds to the "Initial Catalog" and "database" keys within the connection string.

If the value passed in is null when you try to set the property, the InitialCatalog property is reset. If the value has not been set and the developer tries to retrieve the property, the return value is String.Empty.

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. 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();
    


Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.

.NET Framework

Supported in: 2.0

Community Additions

ADD
Show:
© 2014 Microsoft