How to output file name and line number of Entity Framework queries during debugging or logging

In Entity Framework Core the TagWith feature is useful as it allows us to add arbitrary messages which will get outputted along with queries if we have query logging enabled.

And from Entity Framework Core 6 preview 6 there is a new TagWith overload which will automatically include the filename and the line number along with the query.

A simple example is below…


You might also be interested in...

Labelling Entity Framework Core queries in log files using TagWith
In Entity Framework Core (2.2+) if you’re capturing queries in logs consider using the TagWith feature to output an arbitrary … Continue reading Labelling Entity Framework Core queries in log...

How to add SQL query hints to Entity Framework Core queries
I don’t think there’s anything built into Entity Framework for this as query hints can often be very DB platform … Continue reading How to add SQL query hints to...

Using split queries (AsSplitQuery) in Entity Framework Core to avoid the cartesian explosion problem
Without lazy loading in Entity Framework Core we must eagerly load related entities which means we can experience the ‘cartesian … Continue reading Using split queries (AsSplitQuery) in Entity Framework...

String.FirstOrDefault() LINQ queries now supported in Entity Framework Core 5.0
Entity Framework Core 5.0 now supports the translation of String.FirstOrDefault() LINQ queries. In EF Core 3.1 the following would fail… … Continue reading String.FirstOrDefault() LINQ queries now supported in Entity...

Suppress output of OnConfiguring method in Entity Framework Core 5.0
If you’re using Entity Framework Core with the database first approach and re-scaffold you’ll see that by default EF Core … Continue reading Suppress output of OnConfiguring method in Entity...

Leave a Reply

Your email address will not be published. Required fields are marked *