public void Association_OneToMany() { int leftID; int rightID_0; int rightID_1; TestContext.DeleteAll(x => x.AuditEntries); TestContext.DeleteAll(x => x.Association_OneToMany_Lefts); TestContext.DeleteAll(x => x.Association_OneToMany_Rights); var audit = AuditHelper.AutoSaveAudit(); using (var ctx = new TestContext()) { var left = TestContext.Insert(ctx, x => x.Association_OneToMany_Lefts, 1).First(); var right0 = new Association_OneToMany_Right { ColumnInt = 0 }; var right1 = new Association_OneToMany_Right { ColumnInt = 1 }; left.Rights = new List <Association_OneToMany_Right> { right0, right1 }; ctx.SaveChanges(); leftID = left.ID; rightID_0 = right0.ID; rightID_1 = right1.ID; } using (var ctx = new TestContext()) { TestContext.DeleteAll(ctx, x => x.Association_OneToMany_Rights); ctx.SaveChanges(audit); } // UnitTest - Audit { var entries = audit.Entries; // Entries { // Entries Count Assert.AreEqual(4, entries.Count); // Entries State Assert.AreEqual(AuditEntryState.RelationshipDeleted, entries[0].State); Assert.AreEqual(AuditEntryState.RelationshipDeleted, entries[1].State); // Entries EntitySetName Assert.AreEqual("Association_OneToMany_Left_Rights", entries[0].EntitySetName); Assert.AreEqual("Association_OneToMany_Left_Rights", entries[1].EntitySetName); // Entries TypeName Assert.AreEqual(null, entries[0].TypeName); Assert.AreEqual(null, entries[1].TypeName); } // Properties { var propertyIndex = -1; // Properties Count Assert.AreEqual(2, entries[0].Properties.Count); Assert.AreEqual(2, entries[1].Properties.Count); // Association_OneToMany_Left_Rights_Source;ID propertyIndex = 0; Assert.AreEqual("Association_OneToMany_Left_Rights_Source;ID", entries[0].Properties[propertyIndex].PropertyName); Assert.AreEqual("Association_OneToMany_Left_Rights_Source;ID", entries[1].Properties[propertyIndex].PropertyName); Assert.AreEqual(leftID, entries[0].Properties[propertyIndex].OldValue); Assert.AreEqual(leftID, entries[1].Properties[propertyIndex].OldValue); Assert.AreEqual(null, entries[0].Properties[propertyIndex].NewValue); Assert.AreEqual(null, entries[1].Properties[propertyIndex].NewValue); propertyIndex = 1; Assert.AreEqual("Association_OneToMany_Left_Rights_Target;ID", entries[0].Properties[propertyIndex].PropertyName); Assert.AreEqual("Association_OneToMany_Left_Rights_Target;ID", entries[1].Properties[propertyIndex].PropertyName); Assert.AreEqual(rightID_0, entries[0].Properties[propertyIndex].OldValue); Assert.AreEqual(rightID_1, entries[1].Properties[propertyIndex].OldValue); Assert.AreEqual(null, entries[0].Properties[propertyIndex].NewValue); Assert.AreEqual(null, entries[1].Properties[propertyIndex].NewValue); } } // UnitTest - Audit (Database) { using (var ctx = new TestContext()) { // ENSURE order var entries = ctx.AuditEntries.OrderBy(x => x.AuditEntryID).Include(x => x.Properties).ToList(); entries.ForEach(x => x.Properties = x.Properties.OrderBy(y => y.AuditEntryPropertyID).ToList()); // Entries { // Entries Count Assert.AreEqual(4, entries.Count); // Entries State Assert.AreEqual(AuditEntryState.RelationshipDeleted, entries[0].State); Assert.AreEqual(AuditEntryState.RelationshipDeleted, entries[1].State); // Entries EntitySetName Assert.AreEqual("Association_OneToMany_Left_Rights", entries[0].EntitySetName); Assert.AreEqual("Association_OneToMany_Left_Rights", entries[1].EntitySetName); // Entries TypeName Assert.AreEqual(null, entries[0].TypeName); Assert.AreEqual(null, entries[1].TypeName); } // Properties { var propertyIndex = -1; // Properties Count Assert.AreEqual(2, entries[0].Properties.Count); Assert.AreEqual(2, entries[1].Properties.Count); // Association_OneToMany_Left_Rights_Source;ID propertyIndex = 0; Assert.AreEqual("Association_OneToMany_Left_Rights_Source;ID", entries[0].Properties[propertyIndex].PropertyName); Assert.AreEqual("Association_OneToMany_Left_Rights_Source;ID", entries[1].Properties[propertyIndex].PropertyName); Assert.AreEqual(leftID.ToString(), entries[0].Properties[propertyIndex].OldValue); Assert.AreEqual(leftID.ToString(), entries[1].Properties[propertyIndex].OldValue); Assert.AreEqual(null, entries[0].Properties[propertyIndex].NewValue); Assert.AreEqual(null, entries[1].Properties[propertyIndex].NewValue); propertyIndex = 1; Assert.AreEqual("Association_OneToMany_Left_Rights_Target;ID", entries[0].Properties[propertyIndex].PropertyName); Assert.AreEqual("Association_OneToMany_Left_Rights_Target;ID", entries[1].Properties[propertyIndex].PropertyName); Assert.AreEqual(rightID_0.ToString(), entries[0].Properties[propertyIndex].OldValue); Assert.AreEqual(rightID_1.ToString(), entries[1].Properties[propertyIndex].OldValue); Assert.AreEqual(null, entries[0].Properties[propertyIndex].NewValue); Assert.AreEqual(null, entries[1].Properties[propertyIndex].NewValue); } } } }
public void Inheritance_TPC() { var identitySeedCat = TestContext.GetIdentitySeed(x => x.Inheritance_TPC_Animals, Inheritance_TPC_Cat.Create); var identitySeedDog = TestContext.GetIdentitySeed(x => x.Inheritance_TPC_Animals, Inheritance_TPC_Dog.Create); TestContext.DeleteAll(x => x.AuditEntryProperties); TestContext.DeleteAll(x => x.AuditEntries); TestContext.DeleteAll(x => x.Inheritance_TPC_Animals); var audit = AuditHelper.AutoSaveAudit(); using (var ctx = new TestContext()) { TestContext.Insert(ctx, x => x.Inheritance_TPC_Animals, Inheritance_TPC_Cat.Create, 1); TestContext.Insert(ctx, x => x.Inheritance_TPC_Animals, Inheritance_TPC_Dog.Create, 2); ctx.SaveChanges(audit); } // UnitTest - Audit { var entries = audit.Entries; // Entries { // Entries Count Assert.AreEqual(3, entries.Count); // Entries State Assert.AreEqual(AuditEntryState.EntityAdded, entries[0].State); Assert.AreEqual(AuditEntryState.EntityAdded, entries[1].State); Assert.AreEqual(AuditEntryState.EntityAdded, entries[2].State); // Entries EntitySetName Assert.AreEqual(TestContext.TypeName(x => x.Inheritance_TPC_Animals), entries[0].EntitySetName); Assert.AreEqual(TestContext.TypeName(x => x.Inheritance_TPC_Animals), entries[1].EntitySetName); Assert.AreEqual(TestContext.TypeName(x => x.Inheritance_TPC_Animals), entries[2].EntitySetName); // Entries TypeName Assert.AreEqual(typeof(Inheritance_TPC_Cat).Name, entries[0].EntityTypeName); Assert.AreEqual(typeof(Inheritance_TPC_Dog).Name, entries[1].EntityTypeName); Assert.AreEqual(typeof(Inheritance_TPC_Dog).Name, entries[2].EntityTypeName); } // Properties { var propertyIndex = -1; // Properties Count Assert.AreEqual(3, entries[0].Properties.Count); Assert.AreEqual(3, entries[1].Properties.Count); Assert.AreEqual(3, entries[2].Properties.Count); // ID propertyIndex = 0; Assert.AreEqual("ID", entries[0].Properties[propertyIndex].PropertyName); Assert.AreEqual("ID", entries[1].Properties[propertyIndex].PropertyName); Assert.AreEqual("ID", entries[2].Properties[propertyIndex].PropertyName); Assert.AreEqual(null, entries[0].Properties[propertyIndex].OldValue); Assert.AreEqual(null, entries[1].Properties[propertyIndex].OldValue); Assert.AreEqual(null, entries[2].Properties[propertyIndex].OldValue); Assert.AreEqual(identitySeedCat + 1, entries[0].Properties[propertyIndex].NewValue); Assert.AreEqual(identitySeedDog + 1, entries[1].Properties[propertyIndex].NewValue); Assert.AreEqual(identitySeedDog + 2, entries[2].Properties[propertyIndex].NewValue); // ColumnInt propertyIndex = 1; Assert.AreEqual("ColumnInt", entries[0].Properties[propertyIndex].PropertyName); Assert.AreEqual("ColumnInt", entries[1].Properties[propertyIndex].PropertyName); Assert.AreEqual("ColumnInt", entries[2].Properties[propertyIndex].PropertyName); Assert.AreEqual(null, entries[0].Properties[propertyIndex].OldValue); Assert.AreEqual(null, entries[1].Properties[propertyIndex].OldValue); Assert.AreEqual(null, entries[2].Properties[propertyIndex].OldValue); Assert.AreEqual(0, entries[0].Properties[propertyIndex].NewValue); Assert.AreEqual(0, entries[1].Properties[propertyIndex].NewValue); Assert.AreEqual(1, entries[2].Properties[propertyIndex].NewValue); // ColumnCat | ColumnDog propertyIndex = 2; Assert.AreEqual("ColumnCat", entries[0].Properties[propertyIndex].PropertyName); Assert.AreEqual("ColumnDog", entries[1].Properties[propertyIndex].PropertyName); Assert.AreEqual("ColumnDog", entries[2].Properties[propertyIndex].PropertyName); Assert.AreEqual(null, entries[0].Properties[propertyIndex].OldValue); Assert.AreEqual(null, entries[1].Properties[propertyIndex].OldValue); Assert.AreEqual(null, entries[2].Properties[propertyIndex].OldValue); Assert.AreEqual(0, entries[0].Properties[propertyIndex].NewValue); Assert.AreEqual(0, entries[1].Properties[propertyIndex].NewValue); Assert.AreEqual(1, entries[2].Properties[propertyIndex].NewValue); } } // UnitTest - Audit (Database) { using (var ctx = new TestContext()) { // ENSURE order var entries = ctx.AuditEntries.OrderBy(x => x.AuditEntryID).Include(x => x.Properties).ToList(); entries.ForEach(x => x.Properties = x.Properties.OrderBy(y => y.AuditEntryPropertyID).ToList()); // Entries { // Entries Count Assert.AreEqual(3, entries.Count); // Entries State Assert.AreEqual(AuditEntryState.EntityAdded, entries[0].State); Assert.AreEqual(AuditEntryState.EntityAdded, entries[1].State); Assert.AreEqual(AuditEntryState.EntityAdded, entries[2].State); // Entries EntitySetName Assert.AreEqual(TestContext.TypeName(x => x.Inheritance_TPC_Animals), entries[0].EntitySetName); Assert.AreEqual(TestContext.TypeName(x => x.Inheritance_TPC_Animals), entries[1].EntitySetName); Assert.AreEqual(TestContext.TypeName(x => x.Inheritance_TPC_Animals), entries[2].EntitySetName); // Entries TypeName Assert.AreEqual(typeof(Inheritance_TPC_Cat).Name, entries[0].EntityTypeName); Assert.AreEqual(typeof(Inheritance_TPC_Dog).Name, entries[1].EntityTypeName); Assert.AreEqual(typeof(Inheritance_TPC_Dog).Name, entries[2].EntityTypeName); } // Properties { var propertyIndex = -1; // Properties Count Assert.AreEqual(3, entries[0].Properties.Count); Assert.AreEqual(3, entries[1].Properties.Count); Assert.AreEqual(3, entries[2].Properties.Count); // ID propertyIndex = 0; Assert.AreEqual("ID", entries[0].Properties[propertyIndex].PropertyName); Assert.AreEqual("ID", entries[1].Properties[propertyIndex].PropertyName); Assert.AreEqual("ID", entries[2].Properties[propertyIndex].PropertyName); Assert.AreEqual(null, entries[0].Properties[propertyIndex].OldValue); Assert.AreEqual(null, entries[1].Properties[propertyIndex].OldValue); Assert.AreEqual(null, entries[2].Properties[propertyIndex].OldValue); Assert.AreEqual((identitySeedCat + 1).ToString(), entries[0].Properties[propertyIndex].NewValue); Assert.AreEqual((identitySeedDog + 1).ToString(), entries[1].Properties[propertyIndex].NewValue); Assert.AreEqual((identitySeedDog + 2).ToString(), entries[2].Properties[propertyIndex].NewValue); // ColumnInt propertyIndex = 1; Assert.AreEqual("ColumnInt", entries[0].Properties[propertyIndex].PropertyName); Assert.AreEqual("ColumnInt", entries[1].Properties[propertyIndex].PropertyName); Assert.AreEqual("ColumnInt", entries[2].Properties[propertyIndex].PropertyName); Assert.AreEqual(null, entries[0].Properties[propertyIndex].OldValue); Assert.AreEqual(null, entries[1].Properties[propertyIndex].OldValue); Assert.AreEqual(null, entries[2].Properties[propertyIndex].OldValue); Assert.AreEqual("0", entries[0].Properties[propertyIndex].NewValue); Assert.AreEqual("0", entries[1].Properties[propertyIndex].NewValue); Assert.AreEqual("1", entries[2].Properties[propertyIndex].NewValue); // ColumnCat | ColumnDog propertyIndex = 2; Assert.AreEqual("ColumnCat", entries[0].Properties[propertyIndex].PropertyName); Assert.AreEqual("ColumnDog", entries[1].Properties[propertyIndex].PropertyName); Assert.AreEqual("ColumnDog", entries[2].Properties[propertyIndex].PropertyName); Assert.AreEqual(null, entries[0].Properties[propertyIndex].OldValue); Assert.AreEqual(null, entries[1].Properties[propertyIndex].OldValue); Assert.AreEqual(null, entries[2].Properties[propertyIndex].OldValue); Assert.AreEqual("0", entries[0].Properties[propertyIndex].NewValue); Assert.AreEqual("0", entries[1].Properties[propertyIndex].NewValue); Assert.AreEqual("1", entries[2].Properties[propertyIndex].NewValue); } } } }