What does App=EntityFramework do in Sql connection string?

connection-string database entity-framework sql

Question

I have 2 connection strings - 1 local and 1 for my main production server. Entity Framework added App=EntityFramework to my local string when I installed it (4.1) - I'm now on 4.3. What does this do - I can't find any reference to it?

Here's my local connection string:

<add name="LocalConnection"
      providerName="System.Data.EntityClient"
      connectionString="metadata=
      res://*/;
      provider=System.Data.SqlClient;
      provider connection string='
      Data Source=.\SQLEXPRESS;
      AttachDBFilename=C:\mypath\MyDb.mdf;
      Integrated Security=True;
      User Instance=True;
      MultipleActiveResultSets=True;
      App=EntityFramework'" />

Just curious!

1
27
4/23/2016 7:54:53 AM

Accepted Answer

It's just the synonym of the Application Name.

You can see the Connection String properties outlined here:

http://msdn.microsoft.com/en-gb/library/system.data.sqlclient.sqlconnection.connectionstring.aspx

12
3/20/2013 9:14:12 AM

Popular Answer

App and Application Name are simply a way for somebody debugging SQL Server to know which client is connecting to it. If you had a SQL Server that has several apps that used it, it might be hard to know which one was sending which statements. If each app used a different Application Name it would be very clear.

Check this out for more info.



Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow