SetTransactionIsolationLevelReadUncommited(MisesModel context)

13 views
Skip to first unread message

David Veksler

unread,
Jun 27, 2012, 12:27:56 AM6/27/12
to Mises.org Development

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

Reply all
Reply to author
Forward
0 new messages