如何在EF核心中为RLS在SQL中设置会话上下文

using Microsoft.EntityFrameworkCore.Diagnostics;
using Microsoft.EntityFrameworkCore.SqlServer.Infrastructure.Internal;

public class RlsInterceptor : ISqlServerConnectionInterceptor
{
    public void ConnectionOpening(DbConnection connection, ConnectionEventData eventData, InterceptionResult result)
    {
        // 设置会话上下文
        using (var command = connection.CreateCommand())
        {
            command.CommandText = "SET CONTEXT_INFO 0x123456";
            command.ExecuteNonQuery();
        }
    }

    public void ConnectionClosing(DbConnection connection, ConnectionEventData eventData, InterceptionResult result)
    {
        // 在连接关闭时执行自定义操作
    }
}

// 在Startup.cs中的ConfigureServices方法中注册拦截器
public void ConfigureServices(IServiceCollection services)
{
    services.AddDbContext<MyDbContext>(options =>
    {
        options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection"))
            .AddInterceptors(new RlsInterceptor());
    });
}