Clarification Question

[christophwille]

        var blog = sqlServerDb.Blogs
            .OrderBy(b => b.BlogId)
            .First();

vs

        var query= sqlServerDb.Blogs
            .OrderBy(b => b.BlogId);

        var blog = query.First();

The latter one shows the visualizer - this is the expected behavior, correct? (query must be separate from projection)

[Giorgi]

Correct, it isn't possible to inspect queries that return a project (First, Max, Sum, etc). This visualizer can show plans only for IQueryable instances.

For such cases, you can separate queries like in your example but it won't give the real query/plan. When you apply First, Sum, or other projections the query and hence the plan will be different.