public void Optimistic_concurrency_error_attempting_to_delete_previously_modified_entity_when_using_property_as_concurrency_token()
{
ExtendedSqlAzureExecutionStrategy.ExecuteNew(
() =>
{
using (new TransactionScope())
{
using (var context = new GearsOfWarContext())
{
using (var context2 = new GearsOfWarContext())
{
var baird = context.Gears.Where(g => g.Nickname == "Baird").Single();
var baird2 = context2.Gears.Where(g => g.Nickname == "Baird").Single();
baird.Rank = MilitaryRank.Lieutenant;
context.SaveChanges();
context2.Gears.Remove(baird2);
Assert.Throws <DbUpdateException>(() => context2.SaveChanges()).InnerException
.ValidateMessage(typeof(DbContext).Assembly(), "Update_ConcurrencyError", null);
}
}
}
});
}
public void Modifying_non_generated_key_throws()
{
ExtendedSqlAzureExecutionStrategy.ExecuteNew(
() =>
{
using (new TransactionScope())
{
using (var context = new GearsOfWarContext())
{
var squad = new Squad
{
Id = 10,
Name = "Lima",
};
context.Squads.Add(squad);
context.SaveChanges();
squad.Id = 20;
Assert.Throws <InvalidOperationException>(() => context.SaveChanges())
.ValidateMessage(typeof(DbContext).Assembly(), "ObjectStateEntry_CannotModifyKeyProperty", null, "Id");
}
}
});
}
public void Optimistic_concurrency_error_on_property_update_previously_modified_entity_when_using_timestamp()
{
ExtendedSqlAzureExecutionStrategy.ExecuteNew(
() =>
{
using (new TransactionScope())
{
using (var context = new GearsOfWarContext())
{
using (var context2 = new GearsOfWarContext())
{
var gnasher = context.Weapons.Where(w => w.Name == "Gnasher").Single();
var gnasher2 = context2.Weapons.Where(w => w.Name == "Gnasher").Single();
gnasher.Name = "Gnasher Mk 2";
context.SaveChanges();
gnasher2.Name = "Sawed-off";
Assert.Throws <DbUpdateConcurrencyException>(() => context2.SaveChanges())
.ValidateMessage(typeof(DbContext).Assembly(), "Update_ConcurrencyError", null);
}
}
}
});
}
public static void Seed(GearsOfWarContext context)
{
var squads = GearsOfWarData.CreateSquads();
var missions = GearsOfWarData.CreateMissions();
var squadMissions = GearsOfWarData.CreateSquadMissions();
var cities = GearsOfWarData.CreateCities();
var weapons = GearsOfWarData.CreateWeapons();
var tags = GearsOfWarData.CreateTags();
var gears = GearsOfWarData.CreateGears();
var locustLeaders = GearsOfWarData.CreateLocustLeaders();
var factions = GearsOfWarData.CreateFactions();
GearsOfWarData.WireUp(squads, missions, squadMissions, cities, weapons, tags, gears, locustLeaders, factions);
context.Squads.AddRange(squads);
context.Missions.AddRange(missions);
context.SquadMissions.AddRange(squadMissions);
context.Cities.AddRange(cities);
context.Weapons.AddRange(weapons);
context.Tags.AddRange(tags);
context.Gears.AddRange(gears);
context.LocustLeaders.AddRange(locustLeaders);
context.Factions.AddRange(factions);
context.SaveChanges();
GearsOfWarData.WireUp2(locustLeaders, factions);
context.SaveChanges();
}
public void Modifying_identity_non_key_throws()
{
ExtendedSqlAzureExecutionStrategy.ExecuteNew(
() =>
{
using (new TransactionScope())
{
using (var context = new GearsOfWarContext())
{
var squad = new Squad
{
Id = 10,
Name = "Lima",
};
context.Squads.Add(squad);
context.SaveChanges();
var squadInternalNumber = squad.InternalNumber;
squad.InternalNumber = squadInternalNumber + 1;
Assert.Throws <DbUpdateException>(() => context.SaveChanges())
.InnerException.InnerException.ValidateMessage(
typeof(DbContext).Assembly(),
"Update_ModifyingIdentityColumn",
null,
"Identity",
"InternalNumber",
"CodeFirstDatabaseSchema.Squad");
}
}
});
}
public void Insert_update_delete_entity_with_spatial_property()
{
ExtendedSqlAzureExecutionStrategy.ExecuteNew(
() =>
{
using (new TransactionScope())
{
using (var context = new GearsOfWarContext())
{
var GeographySrid = 4326;
var halvoBay = new City
{
Name = "Halvo Bay",
Location = DbGeography.FromText("POINT(10 10)", GeographySrid),
};
context.Cities.Add(halvoBay);
context.SaveChanges();
Assert.True(context.Cities.Where(c => c.Name == "Halvo Bay").Any());
halvoBay.Location = DbGeography.FromText("POINT(20 20)", GeographySrid);
context.SaveChanges();
var halvoBaysNewLocation = context.Cities.Where(g => g.Name == "Halvo Bay").Select(g => g.Location).Single();
Assert.True(halvoBaysNewLocation.SpatialEquals(DbGeography.FromText("POINT(20 20)", GeographySrid)));
context.Cities.Remove(halvoBay);
context.SaveChanges();
Assert.False(context.Cities.Where(g => g.Name == "Halvo Bay").Any());
}
}
});
}
public void Modifying_identity_generated_key_throws()
{
ExtendedSqlAzureExecutionStrategy.ExecuteNew(
() =>
{
using (new TransactionScope())
{
using (var context = new GearsOfWarContext())
{
var tag = new CogTag
{
Id = Guid.NewGuid(),
Note = "Some Note",
};
context.Tags.Add(tag);
context.SaveChanges();
tag.Id = Guid.NewGuid();
Assert.Throws <InvalidOperationException>(() => context.SaveChanges())
.ValidateMessage(typeof(DbContext).Assembly(), "ObjectStateEntry_CannotModifyKeyProperty", null, "Id");
}
}
});
}
public void Inserting_entity_that_references_itself_in_one_to_many_relationship_works()
{
using (var context = new GearsOfWarContext())
{
var squad = new Squad
{
Name = "One Man Squad",
};
var tag = new CogTag
{
Note = "Tag",
};
var oneManArmy = new Gear
{
FullName = "One Man Army",
Nickname = "OMA",
Rank = MilitaryRank.Private,
Squad = squad,
Tag = tag,
};
oneManArmy.Reports = new List <Gear> {
oneManArmy
};
context.Gears.Add(oneManArmy);
context.SaveChanges();
var oma = context.Gears.Where(g => g.Nickname == "OMA").Include(g => g.Reports).Single();
Assert.Same(oma, oma.Reports.Single());
}
}
protected override void Seed(GearsOfWarContext context)
{
base.Seed(context);
// Set up full-text search and add some full-text binary data
context.Database.ExecuteSqlRaw(
@"
UPDATE [Missions]
SET
[BriefingDocumentFileExtension] = '.html',
[BriefingDocument] = CONVERT(varbinary(max), '<h1>Deploy the Lightmass Bomb to destroy the Locust Horde</h1>')
WHERE [Id] = 1;
UPDATE [Missions]
SET
[BriefingDocumentFileExtension] = '.html',
[BriefingDocument] = CONVERT(varbinary(max), '<h1>Two-day long military counterattack to kill the remaining Locust</h1>')
WHERE [Id] = 2;
IF (FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') = 1)
BEGIN
IF EXISTS (SELECT 1 FROM sys.fulltext_catalogs WHERE [name] = 'GearsOfWar_FTC')
BEGIN
DROP FULLTEXT CATALOG GearsOfWar_FTC;
END
CREATE FULLTEXT CATALOG GearsOfWar_FTC AS DEFAULT;
CREATE FULLTEXT INDEX ON Missions (BriefingDocument TYPE COLUMN BriefingDocumentFileExtension) KEY INDEX PK_Missions;
WAITFOR DELAY '00:00:03';
END");
}
public void Update_resulting_in_data_truncation_throws_exception()
{
ExtendedSqlAzureExecutionStrategy.ExecuteNew(
() =>
{
using (new TransactionScope())
{
using (var context = new GearsOfWarContext())
{
var cogTagNoteMaxLength = 40;
var cogTag = new CogTag
{
Id = Guid.NewGuid(),
Note = new string('A', cogTagNoteMaxLength),
};
context.Tags.Add(cogTag);
context.SaveChanges();
cogTag.Note = new string('A', cogTagNoteMaxLength + 1);
Assert.Throws <DbUpdateException>(() => context.SaveChanges());
}
}
});
}
public void Optimisic_concurrency_error_when_deleting_previously_modified_reference()
{
ExtendedSqlAzureExecutionStrategy.ExecuteNew(
() =>
{
using (new TransactionScope())
{
using (var context = new GearsOfWarContext())
{
using (var context2 = new GearsOfWarContext())
{
var jacinto = context.Cities.Where(c => c.Name == "Jacinto").Single();
var cole = context.Gears.Where(g => g.Nickname == "Cole Train").Include(g => g.CityOfBirth).Single();
var cole2 = context2.Gears.Where(g => g.Nickname == "Cole Train").Include(g => g.CityOfBirth).Single();
cole.CityOfBirth = jacinto;
context.SaveChanges();
cole2.CityOfBirth = null;
Assert.Throws <DbUpdateException>(() => context2.SaveChanges())
.InnerException.ValidateMessage(typeof(DbContext).Assembly(), "Update_ConcurrencyError", null);
}
}
}
});
}
public void Optimistic_concurrency_error_attempting_to_delete_previously_modified_entity_when_using_timestamp()
{
using (var context = new GearsOfWarContext())
{
using (var context2 = new GearsOfWarContext())
{
var troika = new HeavyWeapon
{
Name = "Troika",
Overheats = true,
};
context.Weapons.Add(troika);
context.SaveChanges();
var troika2 = context2.Weapons.Where(w => w.Name == "Troika").Single();
troika.Overheats = false;
context.SaveChanges();
context2.Weapons.Remove(troika2);
Assert.Throws <DbUpdateConcurrencyException>(() => context2.SaveChanges())
.ValidateMessage(typeof(DbContext).Assembly, "Update_ConcurrencyError", null);
}
}
}
public void Insert_update_and_delete_entity_with_enum_property()
{
using (var context = new GearsOfWarContext())
{
var taisTag = new CogTag
{
Note = "Tai's tag",
};
var tai = new Gear
{
FullName = "Tai Kaliso",
Nickname = "Tai",
Squad = context.Squads.First(),
Rank = MilitaryRank.Corporal,
Tag = taisTag,
};
context.Gears.Add(tai);
context.SaveChanges();
Assert.True(context.Gears.Where(g => g.Nickname == "Tai" && g.Rank == MilitaryRank.Corporal).Any());
tai.Rank = MilitaryRank.Sergeant;
context.SaveChanges();
var taisNewRank = context.Gears.Where(g => g.Nickname == "Tai").Select(g => g.Rank).Single();
Assert.Equal(MilitaryRank.Sergeant, taisNewRank);
context.Gears.Remove(tai);
context.SaveChanges();
Assert.False(context.Gears.Where(g => g.Nickname == "Tai").Any());
}
}
public void Same_entity_with_one_to_one_relationship_attached_to_two_different_entities_throw_on_insert()
{
using (var context = new GearsOfWarContext())
{
var tag = new CogTag
{
Note = "Who's tag is it?",
};
var gear1 = new Gear
{
Nickname = "Gear1",
FullName = "Gear1",
Rank = MilitaryRank.Private,
Squad = context.Squads.First(),
Tag = tag,
};
var gear2 = new Gear
{
Nickname = "Gear2",
FullName = "Gear2",
Rank = MilitaryRank.Private,
Squad = context.Squads.First(),
Tag = tag,
};
context.Gears.AddRange(new[] { gear1, gear2 });
Assert.Throws <DbUpdateException>(() => context.SaveChanges());
}
}
public void Verify_that_deletes_precede_inserts()
{
using (var context = new GearsOfWarContext())
{
var squad1 = new Squad
{
Id = 3,
Name = "Alpha",
};
context.Squads.Add(squad1);
context.SaveChanges();
var squad2 = new Squad
{
Id = 3,
Name = "Bravo",
};
context.Squads.Add(squad2);
context.Squads.Remove(squad1);
context.SaveChanges();
Assert.Equal(
"Bravo", context.Squads.Where(o => o.Id == 3).Select(s => s.Name).Single());
}
}
public void Inserting_entities_that_both_reference_each_other_throws()
{
using (var context = new GearsOfWarContext())
{
var snub = new StandardWeapon
{
Name = "Snub",
Specs = new WeaponSpecification
{
AmmoPerClip = 12,
ClipsCount = 11,
}
};
var sawedoff = new StandardWeapon
{
Name = "Sawed-Off Shotgun",
Specs = new WeaponSpecification
{
AmmoPerClip = 1,
ClipsCount = 6,
}
};
snub.SynergyWith = sawedoff;
sawedoff.SynergyWith = snub;
context.Weapons.Add(snub);
Assert.Throws <DbUpdateException>(() => context.SaveChanges())
.InnerException.ValidateMessage(typeof(DbContext).Assembly, "Update_ConstraintCycle", null);
}
}
public void Optimistic_concurrency_error_attempting_to_modify_previously_deleted_entity_when_using_timestamp()
{
ExtendedSqlAzureExecutionStrategy.ExecuteNew(
() =>
{
using (new TransactionScope())
{
using (var context = new GearsOfWarContext())
{
using (var context2 = new GearsOfWarContext())
{
var troika = new HeavyWeapon
{
Name = "Troika",
Overheats = true,
};
context.Weapons.Add(troika);
context.SaveChanges();
var troika2 = context2.Weapons.OfType <HeavyWeapon>().Where(w => w.Name == "Troika").Single();
context.Weapons.Remove(troika);
context.SaveChanges();
troika2.Overheats = false;
Assert.Throws <DbUpdateConcurrencyException>(() => context2.SaveChanges())
.ValidateMessage(typeof(DbContext).Assembly(), "Update_ConcurrencyError", null);
}
}
}
});
}
public void Verify_that_deletes_precede_inserts()
{
ExtendedSqlAzureExecutionStrategy.ExecuteNew(
() =>
{
using (new TransactionScope())
{
using (var context = new GearsOfWarContext())
{
var squad1 = new Squad
{
Id = 3,
Name = "Alpha",
};
context.Squads.Add(squad1);
context.SaveChanges();
var squad2 = new Squad
{
Id = 3,
Name = "Bravo",
};
context.Squads.Add(squad2);
context.Squads.Remove(squad1);
context.SaveChanges();
Assert.Equal(
"Bravo", context.Squads.Where(o => o.Id == 3).Select(s => s.Name).Single());
}
}
});
}
static UpdateTests()
{
// force database initialization, we don't want this to happen inside transaction
using (var context = new GearsOfWarContext())
{
context.Weapons.Count();
}
}
public override GearsOfWarContext CreateContext(InMemoryTestStore _)
{
var context = new GearsOfWarContext(_serviceProvider, _options);
context.ChangeTracker.AutoDetectChangesEnabled = false;
return(context);
}
public override GearsOfWarContext CreateContext(InMemoryTestStore _)
{
var context = new GearsOfWarContext(_options);
context.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
return(context);
}
public void Cascade_delete_works_properly_on_one_to_many_relationship()
{
ExtendedSqlAzureExecutionStrategy.ExecuteNew(
() =>
{
using (new TransactionScope())
{
using (var context = new GearsOfWarContext())
{
var gearsBefore = context.Gears.Count();
var gear1 = new Gear
{
FullName = "Gear1",
Nickname = "Gear1",
Tag = new CogTag
{
Id = Guid.NewGuid(),
Note = "Tag1",
},
};
var gear2 = new Gear
{
FullName = "Gear2",
Nickname = "Gear2",
Tag = new CogTag
{
Id = Guid.NewGuid(),
Note = "Tag2",
},
};
var squad = new Squad
{
Name = "Charlie",
Members = new List <Gear> {
gear1, gear2
},
};
context.Squads.Add(squad);
context.SaveChanges();
var gearsAfterAdd = context.Gears.Count();
context.Squads.Remove(squad);
context.SaveChanges();
var gearsAfterRemove = context.Gears.Count();
Assert.Equal(gearsBefore, gearsAfterRemove);
Assert.Equal(gearsBefore + 2, gearsAfterAdd);
}
}
});
}
public override InMemoryTestStore CreateTestStore()
{
return(InMemoryTestStore.GetOrCreateShared(DatabaseName, () =>
{
using (var context = new GearsOfWarContext(_options))
{
GearsOfWarModelInitializer.Seed(context);
}
}));
}
public override GearsOfWarContext CreateContext(SqliteTestStore testStore)
{
var context = new GearsOfWarContext(_options);
context.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
context.Database.UseTransaction(testStore.Transaction);
return(context);
}
public override GearsOfWarContext CreateContext(SqliteTestStore testStore)
{
var optionsBuilder = new DbContextOptionsBuilder();
optionsBuilder.UseSqlite(testStore.Connection);
var context = new GearsOfWarContext(_serviceProvider, optionsBuilder.Options);
context.Database.UseTransaction(testStore.Transaction);
return(context);
}
public override SqliteTestStore CreateTestStore()
{
return(SqliteTestStore.GetOrCreateShared(DatabaseName, () =>
{
using (var context = new GearsOfWarContext(_options))
{
context.Database.EnsureClean();
GearsOfWarModelInitializer.Seed(context);
}
}));
}
public override GearsOfWarContext CreateContext(SqlServerTestStore testStore)
{
var optionsBuilder = new EntityOptionsBuilder();
optionsBuilder.UseSqlServer(testStore.Connection);
var context = new GearsOfWarContext(_serviceProvider, optionsBuilder.Options);
context.Database.AsRelational().Connection.UseTransaction(testStore.Transaction);
return(context);
}
public override GearsOfWarContext CreateContext(JetTestStore testStore)
{
var context = new GearsOfWarContext(
new DbContextOptionsBuilder(_options)
.UseJet(testStore.Connection, b => b.ApplyConfiguration())
.Options);
context.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
context.Database.UseTransaction(testStore.Transaction);
return(context);
}
public void Inserting_entities_that_reference_themselves_in_a_cycle_throws()
{
ExtendedSqlAzureExecutionStrategy.ExecuteNew(
() =>
{
using (new TransactionScope())
{
using (var context = new GearsOfWarContext())
{
var snub = new StandardWeapon
{
Name = "Snub",
Specs = new WeaponSpecification
{
AmmoPerClip = 12,
ClipsCount = 11,
}
};
var sawedoff = new StandardWeapon
{
Name = "Sawed-Off Shotgun",
Specs = new WeaponSpecification
{
AmmoPerClip = 1,
ClipsCount = 6,
}
};
var longshot = new StandardWeapon
{
Name = "Longshot",
Specs = new WeaponSpecification
{
AmmoPerClip = 1,
ClipsCount = 24,
}
};
snub.SynergyWith = sawedoff;
sawedoff.SynergyWith = longshot;
longshot.SynergyWith = snub;
context.Weapons.Add(snub);
Assert.Throws <DbUpdateException>(() => context.SaveChanges())
.InnerException.ValidateMessage(typeof(DbContext).Assembly(), "Update_ConstraintCycle", null);
}
}
});
}
public override SqlServerTestStore CreateTestStore()
{
return(SqlServerTestStore.GetOrCreateShared(DatabaseName, () =>
{
using (var context = new GearsOfWarContext(
new DbContextOptionsBuilder(_options)
.UseSqlServer(_connectionString, b => b.ApplyConfiguration())
.Options))
{
context.Database.EnsureCreated();
GearsOfWarModelInitializer.Seed(context);
}
}));
}
