public async Task IsNotNull_Async()
{
var identitySeed = TestContext.GetIdentitySeed(x => x.Entity_Basics);
TestContext.DeleteAll(x => x.AuditEntryProperties);
TestContext.DeleteAll(x => x.AuditEntries);
TestContext.DeleteAll(x => x.Entity_Basics);
var audit = AuditHelper.AutoSaveAudit();
using (var ctx = new TestContext())
{
TestContext.Insert(ctx, x => x.Entity_Basics, 3);
await ctx.SaveChangesAsync(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.Entity_Basics), entries[0].EntitySetName);
Assert.AreEqual(TestContext.TypeName(x => x.Entity_Basics), entries[1].EntitySetName);
Assert.AreEqual(TestContext.TypeName(x => x.Entity_Basics), entries[2].EntitySetName);
// Entries TypeName
Assert.AreEqual(typeof(Entity_Basic).Name, entries[0].EntityTypeName);
Assert.AreEqual(typeof(Entity_Basic).Name, entries[1].EntityTypeName);
Assert.AreEqual(typeof(Entity_Basic).Name, entries[2].EntityTypeName);
}
// Properties
{
var propertyIndex = -1;
// Properties Count
Assert.AreEqual(2, entries[0].Properties.Count);
Assert.AreEqual(2, entries[1].Properties.Count);
Assert.AreEqual(2, 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(identitySeed + 1, entries[0].Properties[propertyIndex].NewValue);
Assert.AreEqual(identitySeed + 2, entries[1].Properties[propertyIndex].NewValue);
Assert.AreEqual(identitySeed + 3, 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(1, entries[1].Properties[propertyIndex].NewValue);
Assert.AreEqual(2, 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.Entity_Basics), entries[0].EntitySetName);
Assert.AreEqual(TestContext.TypeName(x => x.Entity_Basics), entries[1].EntitySetName);
Assert.AreEqual(TestContext.TypeName(x => x.Entity_Basics), entries[2].EntitySetName);
// Entries TypeName
Assert.AreEqual(typeof(Entity_Basic).Name, entries[0].EntityTypeName);
Assert.AreEqual(typeof(Entity_Basic).Name, entries[1].EntityTypeName);
Assert.AreEqual(typeof(Entity_Basic).Name, entries[2].EntityTypeName);
}
// Properties
{
var propertyIndex = -1;
// Properties Count
Assert.AreEqual(2, entries[0].Properties.Count);
Assert.AreEqual(2, entries[1].Properties.Count);
Assert.AreEqual(2, 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((identitySeed + 1).ToString(), entries[0].Properties[propertyIndex].NewValue);
Assert.AreEqual((identitySeed + 2).ToString(), entries[1].Properties[propertyIndex].NewValue);
Assert.AreEqual((identitySeed + 3).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("1", entries[1].Properties[propertyIndex].NewValue);
Assert.AreEqual("2", entries[2].Properties[propertyIndex].NewValue);
}
}
}
}