SQLiteInMemoryConnectionProviderAsync.cs

public class SQLiteInMemoryConnectionProvider : DriverConnectionProvider
{
    private AsyncLocal<DbConnection> _connection = new AsyncLocal<DbConnection>();

    public override DbConnection? GetConnection()
    {
        return _connection.Value ??= base.GetConnection();
    }

    public override void CloseConnection(DbConnection conn) { }
}