Accessing SQL from Entity Framework Core Queries in ASP.NET Core

Question

In a post in the last week or so, someone made reference to a post: http://rion.io/2016/10/19/accessing-entity-framework-core-queries-behind-the-scenes-in-asp-net-core/

The blog outlined using internals of EF to show the generated SQL for a given EF query. Having a tool like this is invaluable, and will help my EF dev team to write better code. However, as it uses internal and unsupported code, it will not build using EF 2.1.4. The reference to RelationalQueryModelVisitor is now gone, and the code will not build.

I am using using .net core 2.1 as well.

Is there another or similar approach available?

Thanks.

In that article, one of the comments points to this: gist.github.com/nour-s/3bbf9b2588faa6b849393639a8b39757 — Gabriel Luci
– Gabriel Luci, Commented Nov 24, 2018 at 20:58
@GabrielLuci Yes, agreed. The reference you provided has the issue. — JamieMeyer
– JamieMeyer, Commented Nov 24, 2018 at 21:02
So did you try that one? People in the comments claim that it works with 2.1 — Gabriel Luci
– Gabriel Luci, Commented Nov 24, 2018 at 21:42
The original post, as well as my previous response to you indicate this is the case. Do you have a different result? — JamieMeyer
– JamieMeyer, Commented Nov 24, 2018 at 21:47
Maybe you misunderstand me. The link I gave has different code than the article you mention in your original post. — Gabriel Luci
– Gabriel Luci, Commented Nov 24, 2018 at 22:26

Gabriel Luci · Accepted Answer · 2018-11-25 01:55:50Z

1

Use the class in this link, which does work in .NET Core 2.1. Yes, I know you said you tried it, but I just tried it and it worked, so there must be something else going wrong in your project. Tell us the compiler error you are getting and we can help further.

Here is what I did:

Created a new ASP.NET Core project and made sure it's targetting .NET Core 2.1.
Added Microsoft.EntityFrameworkCore version 2.1.4 from NuGet.
Created an IQueryableExtensions class and pasted the code.

It compiles.

The RelationalQueryModelVisitor class does still exist in .NET Core 2.1. The documentation shows it is still there (notice the "Entity Framework Core 2.1" in the top left of the docs) and the current source code on GitHub still shows it there.

edited Nov 25, 2018 at 1:55

answered Nov 25, 2018 at 0:01

Gabriel Luci

41.5k4 gold badges66 silver badges98 bronze badges

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

Comments

Moho · Accepted Answer · 2018-11-24 23:13:43Z

0

Would using their logging functionality be sufficient?

https://learn.microsoft.com/en-us/ef/core/miscellaneous/logging

public static readonly LoggerFactory MyLoggerFactory
    = new LoggerFactory(new[] {new ConsoleLoggerProvider((_, __) => true, true)});

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    => optionsBuilder
        .UseLoggerFactory(MyLoggerFactory) // Warning: Do not create a new ILoggerFactory instance each time
        .UseSqlServer(...);

answered Nov 24, 2018 at 23:13

Moho

16.8k1 gold badge36 silver badges35 bronze badges

Comments

Brandon · Accepted Answer · 2019-04-12 21:57:44Z

0

It's in the Microsoft.EntityFrameworkCore.Relational nuget package.

answered Apr 12, 2019 at 21:57

Brandon

9081 gold badge17 silver badges38 bronze badges

Collectives™ on Stack Overflow

Accessing SQL from Entity Framework Core Queries in ASP.NET Core

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related