EF Core logging issue

Question

I installed Microsoft.Extensions.Logging.Debug according to the tutorial and wanted to see how each query statement of ef core is converted into sql.

And added the following code in Context:

public partial class MyDbnContext : DbContext
{
         [Obsolete]
         public static readonly LoggerFactory LoggerFactory = new LoggerFactory(new[] { new DebugLoggerProvider((_, __) => true) });
         protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
         {
             base.OnConfiguring(optionsBuilder);
             optionsBuilder.UseLoggerFactory(LoggerFactory);
         }
}

But every time the query statement is executed, the corresponding sql statement does not appear.

Answer 1

For ASP.NET Core or Razor Pages

In Program.cs

public class Program
{
    public static void Main(string[] args)
    {
        var builder = WebApplication.CreateBuilder(args);

        // Add services to the container.
        builder.Services.AddRazorPages();

        builder.Services.AddDbContext<Context>(options =>
            options.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection"))
                .EnableSensitiveDataLogging());

Screenshot

Windows forms or Console project

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    => optionsBuilder
        .UseSqlServer("Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=NorthWind2022;Integrated Security=True")
        .EnableSensitiveDataLogging()
        .LogTo(message => Debug.WriteLine(message),
            new[] { DbLoggerCategory.Database.Command.Name },
            LogLevel.Information);

Screenshot

NuGet packages in project file

<ItemGroup>
    <PackageReference Include="Microsoft.EntityFrameworkCore" Version="7.0.10" />
    <PackageReference Include="Microsoft.EntityFrameworkCore.Relational" Version="7.0.10" />
    <PackageReference Include="Microsoft.EntityFrameworkCore.SqlServer" Version="7.0.10" />
</ItemGroup>

Better Logging with SeriLog

See the following

• GitHub repository 1
• GitHub repository 2
• From Microsoft