BstDbContextLibrary.SqlServer 10.0.7

How to use

ApplicationDbContext: OnConfiguring:

optionsBuilder.AddInterceptors(new ReadUncommittedInterceptor());

Implement IDbContextSqlServer on the context and return true from IsReadUncommittedEnabled() to opt in.

10.0.7

ReadUncommittedInterceptor now actually sets the isolation level. Up to 10.0.6 it only emitted SET IMPLICIT_TRANSACTIONS OFF, so every query still ran at READ COMMITTED despite the type name.

• reads get SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
• writes get SET TRANSACTION ISOLATION LEVEL READ COMMITTED; instead of being skipped, so the level cannot leak from a read into the next write on the same pooled connection
• DELETE FROM and MERGE count as writes; keyword matching is now Ordinal

Note that EF Core 10 logs the command text captured before interception, so these statements do not appear in the EF log even though they reach the server. Verify with sys.dm_exec_cached_plans.