1
builder.UseSqlServer(connectionString)
2
    .UseRecompileExtensions(); // Register interceptor

1
var name = "SomeName";
2
var result = context.SomeItems
3
    .Where(x => x.Name == name)
4
    .WithRecompile() // Add tag
5
    .ToList();

1
SELECT [s].[Id], [s].[Name]
2
FROM [SomeItems] AS [s]
3
WHERE [s].[Name] = @__name_0
4
OPTION(RECOMPILE)

1
public static class RecompileExtensions
2
{
3
    private const string RecompileTag = "recompile_query_tag";
4
    private const string RecompileComment = "-- " + RecompileTag + "\r\n";
5

6
    public static DbContextOptionsBuilder UseRecompileExtensions(this DbContextOptionsBuilder builder)
7
    {
8
        return builder.AddInterceptors(RecompileInterceptor.Instance);
9
    }
10

11
    public static IQueryable<T> WithRecompile<T>(this IQueryable<T> query)
12
    {
13
        return query.TagWith(RecompileTag);
14
    }
15

16
    private class RecompileInterceptor : DbCommandInterceptor
17
    {
18
        public static RecompileInterceptor Instance = new();
19

20
        public override InterceptionResult<DbDataReader> ReaderExecuting(
21
            DbCommand command,
22
            CommandEventData eventData,
23
            InterceptionResult<DbDataReader> result)
24
        {
25
            CorrectCommand(command);
26
            return base.ReaderExecuting(command, eventData, result);
27
        }
28

29
        private static void CorrectCommand(DbCommand command)
30
        {
31
            var newQuery = command.CommandText.Replace(RecompileComment, "");
32

33
            if (!ReferenceEquals(newQuery, command.CommandText))
34
            {
35
                if (newQuery.StartsWith("\r\n"))
36
                    newQuery = newQuery.Substring(2);
37

38
                newQuery += "\r\nOPTION(RECOMPILE)";
39
                command.CommandText = newQuery;
40
            }
41
        }
42
    }
43
}