I just added the following helper in select locations.
public static void SetTransactionIsolationLevelReadUncommited(MisesModel context) |
{ |
context.ExecuteStoreCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;"); |
} |
I also enabled reading snapshots from Mises and MisesCommunity. I have not enabled snapshot isolation yet:
USE Mises
ALTER DATABASE Mises
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
GO
--ALTER DATABASE Mises SET ALLOW_SNAPSHOT_ISOLATION ON
ALTER DATABASE Mises SET READ_COMMITTED_SNAPSHOT ON
GO
ALTER DATABASE Mises
SET MULTI_USER;
GO