I got an API configured with the latest version of Application Insights, like this:

services.AddApplicationInsightsTelemetry(o =>
{
    o.ConnectionString = string.Format("InstrumentationKey={0};", configuration.InstrumentationKey);
    o.RequestCollectionOptions.InjectResponseHeaders = true;
    o.EnableQuickPulseMetricStream = true;
    o.EnableAdaptiveSampling = false;     
    o.EnableDebugLogger =false;
});

I got the API configured with NLog and specifying that I only want to track error messages:

<?xml version="1.0" encoding="utf-8" ?>
<nlog xmlns=".xsd"
      xmlns:xsi=";
      autoReload="true">
  <extensions>
    <add assembly="NLog.Web.AspNetCore"/>
    <add assembly="Microsoft.ApplicationInsights.NLogTarget" />
  </extensions>
  <targets>
    <target xsi:type="ApplicationInsightsTarget" name="aiTarget">
      <instrumentationKey>XXXXXXXXX</instrumentationKey>
      <contextproperty name="threadid" layout="${threadid}" />
    </target>
  </targets>
  <rules>
    <logger name="*" minlevel="Error" writeTo="aiTarget" />
  </rules>
</nlog>

And in the appsettings.json of the API I have:

"Logging": {
   "IncludeScopes": false,
   "LogLevel": {
     "Default": "Error",
     "System": "Error",
     "Microsoft": "Error"
   }
}

However in Application Insights, I get log trace messages from Entity Framework Core:

How can I stop these EF Core traces appearing there?

Thanks,
Juan Antonio

I got an API configured with the latest version of Application Insights, like this:

services.AddApplicationInsightsTelemetry(o =>
{
    o.ConnectionString = string.Format("InstrumentationKey={0};", configuration.InstrumentationKey);
    o.RequestCollectionOptions.InjectResponseHeaders = true;
    o.EnableQuickPulseMetricStream = true;
    o.EnableAdaptiveSampling = false;     
    o.EnableDebugLogger =false;
});

I got the API configured with NLog and specifying that I only want to track error messages:

<?xml version="1.0" encoding="utf-8" ?>
<nlog xmlns="http://www.nlog-project./schemas/NLog.xsd"
      xmlns:xsi="http://www.w3./2001/XMLSchema-instance"
      autoReload="true">
  <extensions>
    <add assembly="NLog.Web.AspNetCore"/>
    <add assembly="Microsoft.ApplicationInsights.NLogTarget" />
  </extensions>
  <targets>
    <target xsi:type="ApplicationInsightsTarget" name="aiTarget">
      <instrumentationKey>XXXXXXXXX</instrumentationKey>
      <contextproperty name="threadid" layout="${threadid}" />
    </target>
  </targets>
  <rules>
    <logger name="*" minlevel="Error" writeTo="aiTarget" />
  </rules>
</nlog>

And in the appsettings.json of the API I have:

"Logging": {
   "IncludeScopes": false,
   "LogLevel": {
     "Default": "Error",
     "System": "Error",
     "Microsoft": "Error"
   }
}

However in Application Insights, I get log trace messages from Entity Framework Core:

How can I stop these EF Core traces appearing there?

Thanks,
Juan Antonio

• -core
• entity-framework-core
• azure-application-insights

1 Answer 1

As far as I see from this image you have sensitive data logging enabled on your DbContext class. You just need to disable it. Configuring sensitive data logging normally happens in your Startup.cs class where you register your DbContext in the DI container using the DbContextOptionsBuilder class to configure it.

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    => optionsBuilder
        .LogTo(Console.WriteLine)
        .EnableSensitiveDataLogging();

The configuration of your DbContext class in Startip.cs should look something like this:

services.AddDbContext<ApplicationDbContext>(options =>
    {
              options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection"));
        options.EnableSensitiveDataLogging();
    });

Just remove the last line from the code block above i.e.

EnableSensitiveDataLogging()

and you should be good to go. More on EF Core sensitive data logging In short most likely your problem has nothing to do with Azure App Insights but with how you have configured your DbContext class.