How do I get the Application Name from either SQL Server connection string or the IIS application name using C#?

Question

Hi All,

How do I get the Application Name from an SQL Server connection string in the web.config file.

I want to use to log escalated error messages from a web application into the Windows Event Log.

Maybe there is a better way of doing this, ie using the IIS/Web application name?

Thanks

Mark

Answer 1

What does the connection string look like?

DbConnectionStringBuilder is good for parsing and inspecting connection-string values by key:

        DbConnectionStringBuilder db = new DbConnectionStringBuilder();
        db.ConnectionString = connectionString;
        Console.WriteLine(db["Application Name"]);

otherwise you can get various details from the http server variables.

Answer 2

SqlConnectionStringBuilder is also useful if you are using SQL Server:

SqlConnectionStringBuilder sc = new SqlConnectionStringBuilder(connectionString);
string applicationName = sc.ApplicationName;