public void Insert_update_and_delete_entity_with_enum_property() { using (var context = new GearsOfWarContext()) { var taisTag = new CogTag { Id = Guid.NewGuid(), 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 { Id = Guid.NewGuid(), 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 Modifying_identity_generated_key_throws() { 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 { Id = Guid.NewGuid(), 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()); } }
public void Insert_principal_entity_without_required_dependant_does_not_throw() { using (var context = new GearsOfWarContext()) { var nobodysTag = new CogTag { Id = Guid.NewGuid(), Note = "Owner Unknown", }; context.Tags.Add(nobodysTag); context.SaveChanges(); Assert.True(context.Tags.Any(t => t.Note == "Owner Unknown")); } }
public void Update_resulting_in_data_truncation_throws_exception() { 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()); } }
protected override void Seed(GearsOfWarContext context) { var lancer = new StandardWeapon { Name = "Lancer", Specs = new WeaponSpecification { AmmoPerClip = 60, ClipsCount = 8, } }; var gnasher = new StandardWeapon { Name = "Gnasher", Specs = new WeaponSpecification { AmmoPerClip = 8, ClipsCount = 6, }, SynergyWith = lancer, }; var hammerburst = new StandardWeapon { Name = "Hammerburst", Specs = new WeaponSpecification { AmmoPerClip = 20, ClipsCount = 7, } }; var markza = new StandardWeapon { Name = "Markza", Specs = new WeaponSpecification { AmmoPerClip = 10, ClipsCount = 12, }, SynergyWith = gnasher, }; var mulcher = new HeavyWeapon { Name = "Mulcher", Overheats = true, }; context.Weapons.AddRange(new List <Weapon> { lancer, gnasher, hammerburst, markza, mulcher, }); var deltaSquad = new Squad { Id = 1, Name = "Delta", }; var kiloSquad = new Squad { Id = 2, Name = "Kilo", }; context.Squads.AddRange(new[] { deltaSquad, kiloSquad }); var jacinto = new City { Location = DbGeography.FromText("POINT(1 1)", GeographySrid), Name = "Jacinto", }; var ephyra = new City { Location = DbGeography.FromText("POINT(2 2)", GeographySrid), Name = "Ephyra", }; var hanover = new City { Location = DbGeography.FromText("POINT(3 3)", GeographySrid), Name = "Hanover", }; context.Cities.AddRange(new[] { jacinto, ephyra, hanover }); var marcusTag = new CogTag { Note = "Marcus's Tag", }; var domsTag = new CogTag { Note = "Dom's Tag", }; var colesTag = new CogTag { Note = "Cole's Tag", }; var bairdsTag = new CogTag { Note = "Bairds's Tag", }; var paduksTag = new CogTag { Note = "Paduk's Tag", }; var kiaTag = new CogTag { Note = "K.I.A.", }; context.Tags.AddRange( new[] { marcusTag, domsTag, colesTag, bairdsTag, paduksTag, kiaTag }); var marcus = new Gear { Nickname = "Marcus", FullName = "Marcus Fenix", Squad = deltaSquad, Rank = MilitaryRank.Sergeant, Tag = marcusTag, CityOfBirth = jacinto, Weapons = new List <Weapon> { lancer, gnasher }, }; var dom = new Gear { Nickname = "Dom", FullName = "Dominic Santiago", Squad = deltaSquad, Rank = MilitaryRank.Corporal, Tag = domsTag, CityOfBirth = ephyra, Weapons = new List <Weapon> { hammerburst, gnasher } }; var cole = new Gear { Nickname = "Cole Train", FullName = "Augustus Cole", Squad = deltaSquad, Rank = MilitaryRank.Private, Tag = colesTag, CityOfBirth = hanover, Weapons = new List <Weapon> { gnasher, mulcher } }; var baird = new Gear { Nickname = "Baird", FullName = "Damon Baird", Squad = deltaSquad, Rank = MilitaryRank.Corporal, Tag = bairdsTag, Weapons = new List <Weapon> { lancer, gnasher } }; var paduk = new Gear { Nickname = "Paduk", FullName = "Garron Paduk", Squad = kiloSquad, Rank = MilitaryRank.Private, Tag = paduksTag, Weapons = new List <Weapon> { markza }, }; marcus.Reports = new List <Gear> { dom, cole, baird }; baird.Reports = new List <Gear> { paduk }; context.Gears.AddRange(new[] { marcus, dom, cole, baird, paduk }); }
public void Insert_principal_entity_without_required_dependant_does_not_throw() { ExtendedSqlAzureExecutionStrategy.ExecuteNew( () => { using (new TransactionScope()) { using (var context = new GearsOfWarContext()) { var nobodysTag = new CogTag { Id = Guid.NewGuid(), Note = "Owner Unknown", }; context.Tags.Add(nobodysTag); context.SaveChanges(); Assert.True(context.Tags.Any(t => t.Note == "Owner Unknown")); } } }); }
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 Seed(GearsOfWarContext context) { var lancer = new StandardWeapon { Name = "Lancer", Specs = new WeaponSpecification { AmmoPerClip = 60, ClipsCount = 8, } }; var gnasher = new StandardWeapon { Name = "Gnasher", Specs = new WeaponSpecification { AmmoPerClip = 8, ClipsCount = 6, }, SynergyWith = lancer, }; var hammerburst = new StandardWeapon { Name = "Hammerburst", Specs = new WeaponSpecification { AmmoPerClip = 20, ClipsCount = 7, } }; var markza = new StandardWeapon { Name = "Markza", Specs = new WeaponSpecification { AmmoPerClip = 10, ClipsCount = 12, }, SynergyWith = gnasher, }; var mulcher = new HeavyWeapon { Name = "Mulcher", Overheats = true, }; context.Weapons.AddRange(new List<Weapon> { lancer, gnasher, hammerburst, markza, mulcher, }); var deltaSquad = new Squad { Id = 1, Name = "Delta", }; var kiloSquad = new Squad { Id = 2, Name = "Kilo", }; context.Squads.AddRange(new[] { deltaSquad, kiloSquad }); var jacinto = new City { Location = DbGeography.FromText("POINT(1 1)", DbGeography.DefaultCoordinateSystemId), Name = "Jacinto", }; var ephyra = new City { Location = DbGeography.FromText("POINT(2 2)", DbGeography.DefaultCoordinateSystemId), Name = "Ephyra", }; var hanover = new City { Location = DbGeography.FromText("POINT(3 3)", DbGeography.DefaultCoordinateSystemId), Name = "Hanover", }; context.Cities.AddRange(new[] { jacinto, ephyra, hanover }); var marcusTag = new CogTag { Id = Guid.NewGuid(), Note = "Marcus's Tag", }; var domsTag = new CogTag { Id = Guid.NewGuid(), Note = "Dom's Tag", }; var colesTag = new CogTag { Id = Guid.NewGuid(), Note = "Cole's Tag", }; var bairdsTag = new CogTag { Id = Guid.NewGuid(), Note = "Bairds's Tag", }; var paduksTag = new CogTag { Id = Guid.NewGuid(), Note = "Paduk's Tag", }; var kiaTag = new CogTag { Id = Guid.NewGuid(), Note = "K.I.A.", }; context.Tags.AddRange( new[] { marcusTag, domsTag, colesTag, bairdsTag, paduksTag, kiaTag }); var marcus = new Gear { Nickname = "Marcus", FullName = "Marcus Fenix", Squad = deltaSquad, Rank = MilitaryRank.Sergeant, Tag = marcusTag, CityOfBirth = jacinto, Weapons = new List<Weapon> { lancer, gnasher }, }; var dom = new Gear { Nickname = "Dom", FullName = "Dominic Santiago", Squad = deltaSquad, Rank = MilitaryRank.Corporal, Tag = domsTag, CityOfBirth = ephyra, Weapons = new List<Weapon> { hammerburst, gnasher } }; var cole = new Gear { Nickname = "Cole Train", FullName = "Augustus Cole", Squad = deltaSquad, Rank = MilitaryRank.Private, Tag = colesTag, CityOfBirth = hanover, Weapons = new List<Weapon> { gnasher, mulcher } }; var baird = new Gear { Nickname = "Baird", FullName = "Damon Baird", Squad = deltaSquad, Rank = MilitaryRank.Corporal, Tag = bairdsTag, Weapons = new List<Weapon> { lancer, gnasher } }; var paduk = new Gear { Nickname = "Paduk", FullName = "Garron Paduk", Squad = kiloSquad, Rank = MilitaryRank.Private, Tag = paduksTag, Weapons = new List<Weapon> { markza }, }; marcus.Reports = new List<Gear> { dom, cole, baird }; baird.Reports = new List<Gear> { paduk }; context.Gears.AddRange(new[] { marcus, dom, cole, baird, paduk }); context.SaveChanges(); }