EntityCoreFileLogger 1.0.0

File log for EF Core

Provides a class to log EF Core operations

Instructions

Add the following to the project that uses EF Core or the base project where the base project uses a class project with EF Core operations.

<Target Name="MakeLogDir" AfterTargets="Build">
   
   <MakeDir Directories="$(OutDir)LogFiles\$([System.DateTime]::Now.ToString(yyyy-MM-dd))" />
</Target>

Setup for ASP.NET Core

builder.Services.AddDbContext<Context>(options =>
    options.UseOracle(builder.Configuration.GetConnectionString(nameof(ConnectionStrings.NorthWindConnection)))
        .EnableSensitiveDataLogging()
        .LogTo(new DbContextToFileLogger().Log, new[]
            {
                DbLoggerCategory.Database.Command.Name
            },
            LogLevel.Information));

builder.Services.AddDbContextPool<Context>(options =>
    options.UseSqlServer(configuration.GetConnectionString("DefaultConnection"))
        .EnableSensitiveDataLogging()
        .LogTo(new DbContextToFileLogger().Log,
            new[] { DbLoggerCategory.Database.Command.Name },
            LogLevel.Information));