Retrieving SQL Generated by Entity Framework Core

Question

I'm trying to retrieve the raw SQL generated by Entity Framework for the following LINQ query:

pagedItemResults = from firstItem in dbData.Accession
                        join secondItem in pagedRowNumberResults
                        on firstItem.AccessionNumber equals secondItem
                        select new PaginationResultRow
                        {
                            Number = firstItem.AccessionNumber,
                            ID = firstItem.AccessionId,
                            Name = firstItem.AcquisitionType.Name,
                            Description = firstItem.Description
                        };

Although it may be extremely simple and similar to the other answers already out there for previous versions of EF, I've had no luck and found nothing online.. any ideas??

I know on normal Entity framework you could just do pagedItemResults.ToString() and it would output the query string, can you not do that on core? — Scott Chamberlain
– Scott Chamberlain, Commented Mar 22, 2016 at 16:00

vendettamit · Accepted Answer · 2016-03-22 16:00:07Z

3

You can turn on logging by implementing ILoggerProvider. See details in documentation.

You only need to register the logger with a single context instance. Once you have registered it, it will be used for all other instances of the context in the same AppDomain.

        using (var db = new BloggingContext())
        {
            var serviceProvider = db.GetInfrastructure<IServiceProvider>();
            var loggerFactory = serviceProvider.GetService<ILoggerFactory>();
            loggerFactory.AddProvider(new MyLoggerProvider());
        }

You can also define categories what you want to log.

    private static string[] _categories =
    {
        typeof(Microsoft.Data.Entity.Storage.Internal.RelationalCommandBuilderFactory).FullName,
        typeof(Microsoft.Data.Entity.Storage.Internal.SqlServerConnection).FullName
    };

answered Mar 22, 2016 at 16:00

vendettamit

14.7k2 gold badges36 silver badges56 bronze badges

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

1 Comment

Scott Chamberlain Over a year ago

Note, I think he might be using ASP.NET core, according to the documentation it still works but it has slightly different instructions on what you need to do to register the logger.

Gilles-Antoine Nys · Accepted Answer · 2018-09-18 12:29:22Z

2

You can log tsql generated to output window by :

Microsoft.Extensions.Logging.Debug

First, get it from Nuget, then in your context, you must define a LoggerFactory.

After that, use it in OnConfiguring in your context.

public static readonly Microsoft.Extensions.Logging.LoggerFactory _loggerFactory =
                    new LoggerFactory(new[] {
                    new Microsoft.Extensions.Logging.Debug.DebugLoggerProvider()
    });

optionsBuilder.UseLoggerFactory(_loggerFactory);

edited Sep 18, 2018 at 12:29

Gilles-Antoine Nys

1,48116 silver badges21 bronze badges

answered Sep 18, 2018 at 11:48

masehhat

6906 silver badges11 bronze badges

Comments

sovemp · Accepted Answer · 2016-03-22 15:55:35Z

0

I really like MiniProfiler, see http://miniprofiler.com/. Short of something like this, I would say you'd have to use a profiler on the actual database.

answered Mar 22, 2016 at 15:55

sovemp

1,4121 gold badge13 silver badges33 bronze badges

Collectives™ on Stack Overflow

Retrieving SQL Generated by Entity Framework Core

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related