Entity Framework Core - DbFunction

AuditLog.cs

public class AuditLog
{
    public Guid Id { get; set; } = Guid.NewGuid();

    public DateTimeOffset Created { get; set; } = DateTimeOffset.UtcNow;

    public string LogType { get; set; }

    public string Data { get; set; }
}

DatabaseFunctions.cs

public static class DatabaseFunctions
{
    public static string JsonValue(string source, string path) => throw new NotSupportedException();

    public static void Configure(ModelBuilder modelBuilder)
    {
        modelBuilder
            .HasDbFunction(typeof(DatabaseFunctions).GetMethod(nameof(JsonValue)))
            .HasTranslation(args => SqlFunctionExpression.Create("JSON_VALUE", args, typeof(string), null));
    }
}

DataContext.cs

public class DataContext : DbContext
{
    //pozostała zawartość

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        base.OnModelCreating(modelBuilder);

        DatabaseFunctions.Configure(modelBuilder);
    }
}

query.sql

SELECT *
FROM [AuditLogs]
WHERE JSON_VALUE([Data], N'$.ProductId') = '1612D8E7-8A18-41AD-8BFA-100E1E2D3854'

Show.cs

private static async Task Show()
{
    await using var db = new DataContext();

    var logs = await db.AuditLogs
        .Where(l => DatabaseFunctions.JsonValue(l.Data, "$.ProductId") == _productId.ToString())
        .ToListAsync();

    foreach (var auditLog in logs)
    {
        Console.WriteLine($"Log: {auditLog.LogType}, Date: {auditLog.LogType}, Data: {auditLog.Data}");
    }
}