Get generated SQL for a DbContext.SaveChanges in Entity Framework Core

Question

In Entity Framework Core, is it possible to see the SQL that will be applied when the SaveChanges() method is called on the DbContext?

Answer 1

EF Core 5.0+

There are a simple builtin solution, add the following function to the DbContext class.

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
=> optionsBuilder.LogTo(Console.WriteLine);

this will log both queries and commands.

See here for mote details: Simple Logging