Export (0) Print
Expand All

SqlConnectionStringBuilder.ApplicationName Property

Gets or sets the name of the application associated with the connection string.

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

public string ApplicationName { get; set; }
/** @property */
public String get_ApplicationName ()

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

public function get ApplicationName () : String

public function set ApplicationName (value : String)

Not applicable.

Property Value

The name of the application, or ".NET SqlClient Data Provider" if no name has been supplied.

This property corresponds to the "Application Name" and "app" keys within the connection string. If the value passed in is null when you try to set the property, the ApplicationName 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 new SqlConnectionStringBuilder and assigns a connection string in the object's constructor. The code displays the parsed and recreated version of the connection string, and then modifies the ApplicationName property of the object. Finally, the code displays the new connection string, including the new key/value pair.

using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        try
        {
            string connectString = "Server=(local);Initial Catalog=AdventureWorks;" + 
                "Integrated Security=true";
            SqlConnectionStringBuilder builder = 
                new SqlConnectionStringBuilder(connectString);
            Console.WriteLine("Original: " + builder.ConnectionString);
            Console.WriteLine("ApplicationName={0}",
                builder.ApplicationName);

            builder.ApplicationName = "My Application";
            Console.WriteLine("Modified: " + builder.ConnectionString);

            Console.WriteLine("Press any key to finish.");
            Console.ReadLine();

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

The sample displays the following text in the console window:

Original: Data Source=(local);Initial Catalog=AdventureWorks;Integrated Security=True
ApplicationName=".Net SqlClient Data Provider"
Modified: Data Source=(local);Initial Catalog=AdventureWorks;Integrated Security=True;Application Name="My Application"

Windows 98, Windows Server 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 Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

.NET Framework

Supported in: 3.0, 2.0

Community Additions

ADD
Show:
© 2014 Microsoft