EF Core Query SQL

This is a repository dedicated to testing out a reflection-based snippet for printing SQL generated from a EF Core query LINQ expression.

The snippet code can be found in multiple places with comments worth following for updated versions:

• Stack Overflow question
• GitHub gist
• Blog post 1
• Blog post 2

Let's create the test application and include the EF code NuGet packages:

dotnet new console
dotnet add package Microsoft.EntityFrameworkCore
dotnet add package Microsoft.EntityFrameworkCore.SqlServer

For the classes see, AppDbContext, User, Car and Trip in code.

Console.WriteLine(appDbContext.Users.Include(u => u.Car).Where(u => u.Car != null).ToSql());

SELECT [u].[Id], [u].[CarId], [u].[Name], [u.Car].[Id], [u.Car].[Make], [u.Car].[Model]
FROM [Users] AS [u]
INNER JOIN [Cars] AS [u.Car] ON [u].[CarId] = [u.Car].[Id]
WHERE [u].[CarId] IS NOT NULL

To-Do

Turn this into a hosted app (Azure Function?) and offer it as a tool for the dev community

https://github.com/aspnet/EntityFrameworkCore/wiki/Getting-and-Building-the-Code and debug passing a First expression

Mention the detailed logging option which shows the executed SQL statements