How do i view the SQL generated by EntityFramework Core?

Question

I'm looking for something simple so any monkey like me can understand and implement it easily. If it's possible i only want to see the SQL queries and no extra code or commentaries that could confuse me.

I'm using ASP.NET Core 3.1 and Entity Framework Core 3.1

Fei Han · Accepted Answer · 2020-07-17 03:02:08Z

3

How do i view the SQL generated by EntityFramework Core?

You can try to set Microsoft.EntityFrameworkCore to Debug in appsettings.json to log EF events.

"Logging": {
  "LogLevel": {
    "Default": "Information",
    "Microsoft": "Warning",
    "Microsoft.Hosting.Lifetime": "Information",
    "Microsoft.EntityFrameworkCore": "Debug"
  }
}

Debug code and check the generated SQL query in Output window.

edited Jul 17, 2020 at 3:02

answered Jul 17, 2020 at 2:52

Fei Han

28.1k1 gold badge35 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do i view the SQL generated by EntityFramework Core?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related