Description
openedon Dec 4, 2018
I just setup a basic extension method that adds the calling file's path & line number as a tag to the given query:
public static class IQueryableTagExtensions
{
public static IQueryable<T> TagWithFileInfo<T>(this IQueryable<T> source, [CallerFilePath] string fromFile = null, [CallerLineNumber] int onLine = 0, string comment = null)
{
var tagMessage = fromFile + "@" + onLine + (string.IsNullOrEmpty(comment) ? "" : " - " + comment);
return source.TagWith(tagMessage);
}
}
This works fine when querying for data, but I'd also like it to be part of the queries that execute when calling db.SaveChanges()
. Is this possible currently? Adding query tags to updates is just as important, if not more important with this one, than adding them to selects.
The inspiration for this came from Stack Overflow who prepends this info to every query that runs through Dapper https://gist.github.com/NickCraver/c6f371bf8df37e05c4f09fd3c02ef6a2
What I really like about this is when using MiniProfiler this info becomes available making debugging easier. Then taken a step further it's included in Sentry's breadcrumbs that are part of logged exceptions, and it's also passed into App Insights. Both of those scenarios make production issues easier to track down.
Further technical details
EF Core version: 2.2.0
Database Provider: Microsoft.EntityFrameworkCore.SqlServer
Operating system: Win10
IDE: Visual Studio 2017 15.9.3