Change Application Name in Sql Server Profiler

Question

When profiling a .Net Application in SQL Server Profiler the default Application Name is taken from the Data Provider. How can I change this to my own Application Name?

Answer 1

Just add Application Name=My Application; to the Connectionstring

Example: connectionString="Server=mySqlServer;Initial Catalog=myDatabase;User id=aUser;Password=aPassword;Application Name=My Application;"

You can also use App=My Application