Set isolation level globally for all EF queries/updates/etc.

I am checking online what is easiest way to set the transaction isolation level when using EF Core 6.

Some people using https://stackoverflow.com/a/59933774/960567

```C#
public class ConnectionIsolationLevelInterceptor: IDbConnectionInterceptor
{
// Have empty implementations for all unused IDbConnectionInterceptor methods
public void BeganTransaction(DbConnection connection, BeginTransactionInterceptionContext interceptionContext)
{
}

...
... all other unused methods
...

public void Opened(DbConnection connection, DbConnectionInterceptionContext interceptionContext)
{
using (DbCommand command = connection.CreateCommand())
{
command.CommandText = "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED";
command.ExecuteNonQuery();
}
}
}
```

Some using Migrator,

```
internal sealed class Configuration : DbMigrationsConfiguration
{
public Configuration()
{
SetSqlGenerator("System.Data.SqlClient", new SqlMigrator());
}

private class SqlMigrator : SqlServerMigrationSqlGenerator
{
public override IEnumerable Generate(
IEnumerable migrationOperations, string providerManifestToken)
{
yield return new MigrationStatement { Sql = "set transaction isolation level read committed" };
foreach (var statement in base.Generate(migrationOperations, providerManifestToken))
yield return statement;
}
}
}
```

and some suggested to use base constructor,

```
: base("DefaultConnection", throwIfV1Schema: false)
{
Database.ExecuteSqlCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;");
}
```

Any guidlines from the team how can we set isolation level globally.

EF Core version:
Database provider: (e.g. Microsoft.EntityFrameworkCore.SqlServer)
Target framework: (e.g. .NET 6.0)
Operating system:
IDE: (e.g. Visual Studio 2022 17.6)