Skip to content

Feature like query tags but when calling SaveChanges #14078

Open

Description

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions