What does App=EntityFramework do in Sql connection string?

12,984

Solution 1

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

Solution 2

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.

Share:
12,984
dotnetnoob
Author by

dotnetnoob

I'm work as a self employment online marketeer, and have recently decided to upgrade my skills so that I can accomplish more with my own websites. I tend to ask a lot of questions, and being a noob I guess they'll be pretty basic, so I should be a great source of reputation points :)

Updated on June 14, 2022

Comments

  • dotnetnoob
    dotnetnoob almost 2 years

    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!