//Locking mechanism used for MS SQL Server requires database to have Snapshot isolation level enabled (off by default). // We do it using migrations - and direct SQL connector to run special SQL. public override void RegisterMigrations(Data.Upgrades.DbMigrationSet migrations) { if (migrations.ServerType == Data.Driver.DbServerType.MsSql) { migrations.AddPostUpgradeAction("1.3.0.0", "EnableSnapshot", "Enable snapshot isolation for database.", EnableSnapshotIsolation); } }
public override void RegisterMigrations(Data.Upgrades.DbMigrationSet migrations) { // MS SQL - special case; we have to use Snapshot isolation level for read transaction. // For this, we have to explicitly enable it for the database. We do it using migration if (migrations.ServerType == Data.Driver.DbServerType.MsSql) { migrations.AddPostUpgradeAction("1.0.0.0", "EnableSnapshot", "Enable snapshot isolation", EnableSnapshotIsolation); } }//method