View sql queries generated by EF Core

Question

Is there anyway to see what SQL query EF Core is generating? (ASP .Net Core 1.1)

Answer 1

Just my opinion, but I believe the easiest, fastest and cleanest solution is to use SQL Profiler.

Just run the SQL Profiler that comes with SSMS, start the trace, execute the action that executes the query, pause the trace and check the exact query that was executed.

It's independent of the EF version you are using.