public ModificationFunctionsEndToEndTests()
{
// force database initialization, we don't want this to happen inside transaction
using (var context = new GearsOfWarStoredProceduresContext())
{
context.Database.Delete();
context.Weapons.Count();
}
using (var context = new ArubaStoredProceduresContext())
{
context.Database.Delete();
context.Configs.Count();
}
using (var context = new FantasyStoredProceduresContext())
{
context.Database.Delete();
context.Creatures.Count();
}
}
public void Update_Fantasy_entities_using_stored_procedures()
{
ExtendedSqlAzureExecutionStrategy.ExecuteNew(
() =>
{
using (new TransactionScope())
{
using (var context = new FantasyStoredProceduresContext())
{
var city = context.Cities.OrderBy(c => c.Id).First();
var creature = context.Creatures.OrderBy(c => c.Id).First();
var province = context.Provinces.OrderBy(h => h.Id).First();
var npc = context.Npcs.OrderBy(n => n.Id).First();
var spell = context.Spells.OrderBy(s => s.Id).First();
city.Name = "Changed City";
creature.Details.Attributes.Mana = 123;
province.Shape = DbGeometry.FromText("POINT(23 45)", DbGeometry.DefaultCoordinateSystemId);
npc.Name = "Changed NPC Name";
spell.MagickaCost = 166;
context.SaveChanges();
}
using (var context = new FantasyStoredProceduresContext())
{
var city = context.Cities.OrderBy(c => c.Id).First();
var creature = context.Creatures.OrderBy(c => c.Id).First();
var province = context.Provinces.OrderBy(h => h.Id).First();
var npc = context.Npcs.OrderBy(n => n.Id).First();
var spell = context.Spells.OrderBy(s => s.Id).First();
Assert.Equal("Changed City", city.Name);
Assert.Equal(123, creature.Details.Attributes.Mana);
Assert.Equal(23, province.Shape.XCoordinate);
Assert.Equal(45, province.Shape.YCoordinate);
Assert.Equal("Changed NPC Name", npc.Name);
Assert.Equal(166, spell.MagickaCost);
}
}
});
}