kasthack.AutoTagging

What

Automatic SQL tagging proxies for .NET:

• Dapper is currently supported.
• A custom DbConnection proxy that would be able to capture proper tags without recompilation is in development.

Why does this exist?

I needed a way to tag database queries in an existing project without having to rewrite a large amount of code.

Usage

• Install nuget package kasthack.Autotagging.DapperProxy
• Remove using Dapper from your source files.
• Add using kasthack.Autotagging.DapperProxy to your source files or as a global using.
• (Optional) Set TaggingSqlMapper.AppName
• That's it! All database queries sent through Dapper will be prefixed with the following comment:

-- App: {app_name}
-- File: {callerFile}:{callerLine}
-- Method: {callerMethod}

<your query>

• This allows your DBAs and DevOps teams to easily identify the sources of problematic queries and address them.

How does it work?

• Source generator mirrors all Dapper methods, adds optional [Caller(MemberName|FilePath|LineNumber)] parameters to these methods, and generates a nuget-package with proxying extension methods.
• Your code automatically picks up matching overloads, while the compiler fills in caller information during the build.