Jan 12, 2023 · Entity Framework Core (EF Core) simple logging can be used to easily obtain logs while developing and debugging applications. This form of logging requires minimal configuration and no additional NuGet packages.

Jul 25, 2022 · Specifically, EF includes: The DbContext.Database.Log property can be set to a delegate for any method that takes a string. Most commonly it is used with any TextWriter by setting it to the “Write” method of that TextWriter. All SQL generated by the current context will be logged to that writer.

Need an account? Create one now.

If you've got a .NET Core setup with a logger, then EF will log its queries to whichever output you want: debug output window, console, file, etc. You merely need to configure the 'Information' log level in your appsettings. For instance, this has EF logging to the debug output window:

Jan 12, 2023 · Entity Framework Core (EF Core) contains several mechanisms for generating logs, responding to events, and obtaining diagnostics. Each of these is tailored to different situations, and it is important to select the best mechanism for the task in hand, even when multiple mechanisms could work.

Feb 26, 2025 · I'm writing a simple console program, I tried using the same logging technique that EF6 uses, but DbContext.Database.Log is not available on Entity Framework Core. Is there a way to log or just take a peek at the SQL generated by EF Core? This is how I got it working based on Avi Cherry's comment:

Entity Framework Core integrates with the .NET Core logging to log SQL and change tracking information to the various output targets. First, install the Nuget package for logging provider of your choice and then tie up the DbContext to ILoggerFactory .

Specifically, EF includes: The DbContext.Database.Log property can be set to a delegate for any method that takes a string. Most commonly it is used with any TextWriter by setting it to the “Write” method of that TextWriter. All SQL generated …

Jun 18, 2019 · To log EF events we need to change the logging level for EF Core events to Trace or Debug through appsettings.json or code. For example, including this in appsettings.json: "Logging": { "LogLevel": { "Microsoft.EntityFrameworkCore":"Debug" } }, Will log EF events :

May 18, 2020 · Logging with .NET Core (and Entity Framework Core) requires some plumbing, and requires you to opt-in to the built-in Dependency Injection infrastructure, which you have to enable manually for application types that are not ASP.NET Core.