How do you show underlying SQL query in EF Core?

by

Update for .NET 6 and later: EF logging is enabled by default in development.

Just add "Microsoft.EntityFrameworkCore.Database.Command": "Information" to appsettings.Development.json so it’s only logged in dev mode. You typically don’t want to log every query in a production app.

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=(localdb)\\mssqllocaldb;Database=MyDB-2;Trusted_Connection=True;MultipleActiveResultSets=true"
  },
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft": "Warning",
      "Microsoft.Hosting.Lifetime": "Information"
     ,"Microsoft.EntityFrameworkCore.Database.Command": "Information"
    }
  },
  "AllowedHosts": "*"
}

The SQL output shows in the command window or VS output window.

enter image description here

See SQL Logging of Entity Framework Core in the official docs. In older versions, it was a bug that it didn’t log by default, see this GitHub issue.

More Related Contents:

  1. Filtering on Include in EF Core
  2. Entering keys manually with Entity Framework
  3. Dynamically change connection string in Asp.Net Core
  4. Many-to-many self referencing relationship
  5. .Net Core 3.0 possible object cycle was detected which is not supported
  6. .NET Core 2.1 Identity get all users with their associated roles
  7. auto create database in Entity Framework Core
  8. Command dotnet ef not found
  9. Dynamically changing schema in Entity Framework Core
  10. How to unapply a migration in ASP.NET Core with EF Core
  11. How to store JSON in an entity field with EF Core?
  12. Is there an Entity Framework 7 Database-First POCO Generator?
  13. How can I call a SQL Stored Procedure using EntityFramework 7 and Asp.Net 5
  14. Azure Function, EF Core, Can’t load ComponentModel.Annotations 4.2.0.0
  15. Could not load file or assembly Microsoft.Extensions.DependencyInjection.Abstractions, Version=1.1.0.0
  16. How to auto create database on first run?
  17. loading a full hierarchy from a self referencing table with EntityFramework.Core
  18. Entity framework EF.Functions.Like vs string.Contains
  19. Avoid or control circular references in Entity Framework Core
  20. EF Core Mapping EntityTypeConfiguration
  21. Entity Framework | Sequence contains more than one matching element
  22. Working with SQL views in Entity Framework Core
  23. Entity Framework core – Contains is case sensitive or case insensitive?
  24. Entity Framework Core: `SqlNullValueException: Data is Null.` How to troubleshoot?
  25. How to get user information in DbContext using Net Core
  26. How should I manage DbContext Lifetime in MVC Core?
  27. How to set Identity Seed value in code-first?
  28. EF Core takes a lot of time, sometimes, to perform SELECT query
  29. How to access DbContext in .NET 6 minimal API Program.cs
  30. Update-Database command is not working in ASP.Net Core / Entity Framework Core because object in database already exists

Leave a Comment