Can we see parameter values for SQL dependency calls?

Question

Have an asp.net core application that makes EF calls to a SQL database. When I pull in sql dependency calls as part of querying the logs, I see the statement, but any query parameter values are simply the parameterized statements, but I dont see what values were used in the statement. Is there a way to see those?

Answer 1

I'm assuming that you've already enabled database query monitoring and set builder.Services.ConfigureTelemetryModule<DependencyTrackingTelemetryModule>((module, o) => { module.EnableSqlCommandTextInstrumentation = true; });

If so, make sure you have enabled sensitive logging on the DbContext. Also, if I'm not mistaking, when you configure Logging for EF category to Information and lower, then the parameterized value should print out locally. If they print out locally, then that same configuration should trace out logs.

Should these suggestions not work, please let me know by commenting down below.