Export (0) Print
Expand All

SqlConnectionStringBuilder.ApplicationName Property

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

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)

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 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