Clever Geek Handbook

How to change application name in Entity Framework

In SQL Management Studio, ever a connection has an app listed along with it ... for each EF connection, I only have "EntityFramework" as the app name. How do I change this so that I can actually put the app name in this field?

+3


source to share


1 answer


http://blogs.msdn.com/b/dditweb/archive/2006/03/02/542151.aspx

From the article:

Here's a great trick that can be very helpful if you're a SQL Profiler fan. In the application connection string add "Application name" / value. Example.

server=MyServer;database=MyDatabase;Integrated Security=SSPI;Application Name=My Application;


After that, run SQL Profiler and you will notice that the profiled events are classified under the name you provide, not the default. Provider name.

Edit:

If you look at your current entity connection string near the end of the string (assuming you are using an autogenerated string), you should already see "Application Name = EntityFramework". You can just change this to your desired app name and arrow!

+3


source






More articles:


All Articles