0

If a software application uses Entity Framework Core (3.1) and connects to Microsoft SQL Server (2019) for data, in the SQL Server Profiler, we see it is listed as "Core Microsoft SqlClient Data Provider" under column "ApplicationName".

enter image description here

I wonder if we can change this name in the application source code? For example, to an easier-to-distinguish name, such as "FileServer".

The benefit is that when there are multiple different applications accessing that SQL Server, we can distinguish (or filter) them more easily.

JoyfulPanda
  • 867
  • 6
  • 14
  • 4
    The application name passed to SQL Server is defined in the connection string in the application, using the `Application Name` property. You'll need to edit the connection string to add the property and define the value you want. – Thom A Jul 07 '21 at 14:04
  • 1
    @Larnu, add that as an answer. – Svyatoslav Danyliv Jul 07 '21 at 14:39

0 Answers0