public void Test_IgnoreOverrideProperties_Basic()
{
var list = new List <AuditEventEntityFramework>();
Audit.Core.Configuration.Setup()
.UseDynamicProvider(x => x.OnInsertAndReplace(ev =>
{
list.Add(ev as AuditEventEntityFramework);
}))
.WithCreationPolicy(EventCreationPolicy.InsertOnEnd);
Audit.EntityFramework.Configuration.Setup()
.ForContext <MyTransactionalContext>(config => config
.ForEntity <IntegrationTest.Blog>(_ => _.Ignore(blog => blog.BloggerName)));
Audit.EntityFramework.Configuration.Setup()
.ForAnyContext(config => config
.ForEntity <IntegrationTest.Blog>(_ => _.Override <string>("Title", null)));
var title = Guid.NewGuid().ToString().Substring(0, 25);
using (var ctx = new MyTransactionalContext())
{
var blog = new Blog()
{
Title = title,
BloggerName = "test"
};
ctx.Blogs.Add(blog);
ctx.SaveChanges();
}
using (var ctx = new MyTransactionalContext())
{
var blog = ctx.Blogs.First(b => b.Title == title);
blog.BloggerName = "another";
blog.Title = "x";
ctx.SaveChanges();
}
Assert.AreEqual(2, list.Count);
var entries = list[0].EntityFrameworkEvent.Entries;
Assert.AreEqual(1, entries.Count);
Assert.AreEqual("Insert", entries[0].Action);
Assert.IsFalse(entries[0].ColumnValues.ContainsKey("BloggerName"));
Assert.AreEqual(null, entries[0].ColumnValues["Title"]);
entries = list[1].EntityFrameworkEvent.Entries;
Assert.AreEqual(1, entries.Count);
Assert.AreEqual("Update", entries[0].Action);
Assert.IsFalse(entries[0].ColumnValues.ContainsKey("BloggerName"));
Assert.AreEqual(null, entries[0].ColumnValues["Title"]);
Assert.AreEqual(1, entries[0].Changes.Count);
Assert.AreEqual("Title", entries[0].Changes[0].ColumnName);
Assert.AreEqual(null, entries[0].Changes[0].NewValue);
Assert.AreEqual(null, entries[0].Changes[0].OriginalValue);
}
public void Test_EF_PrimaryKeyUpdate()
{
var logs = new List <AuditEvent>();
Audit.Core.Configuration.Setup()
.UseDynamicProvider(p => p
.OnInsert(ev => { logs.Add(ev); }));
Audit.EntityFramework.Configuration.Setup()
.ForContext <MyTransactionalContext>()
.Reset()
.UseOptOut();
using (var ctx = new MyTransactionalContext())
{
ctx.Blogs.Add(new IntegrationTest.Blog()
{
BloggerName = "abc",
Title = "Test_EF_PrimaryKeyUpdate",
Posts = new List <IntegrationTest.Post>()
{
new Post()
{
Title = "post-test",
Content = "post content",
DateCreated = DateTime.Now
}
}
});
ctx.SaveChanges();
}
Assert.AreEqual(1, logs.Count);
Assert.AreEqual("Blogs", logs[0].GetEntityFrameworkEvent().Entries[0].Table);
Assert.AreEqual("Posts", logs[0].GetEntityFrameworkEvent().Entries[1].Table);
Assert.AreEqual((int)logs[0].GetEntityFrameworkEvent().Entries[0].ColumnValues["Id"], (int)logs[0].GetEntityFrameworkEvent().Entries[0].PrimaryKey["Id"]);
Assert.IsTrue((int)logs[0].GetEntityFrameworkEvent().Entries[0].ColumnValues["Id"] > 0);
Assert.IsTrue((int)logs[0].GetEntityFrameworkEvent().Entries[0].PrimaryKey["Id"] > 0);
Assert.IsTrue((int)logs[0].GetEntityFrameworkEvent().Entries[1].ColumnValues["Id"] > 0);
Assert.IsTrue((int)logs[0].GetEntityFrameworkEvent().Entries[1].PrimaryKey["Id"] > 0);
Assert.IsTrue((int)logs[0].GetEntityFrameworkEvent().Entries[1].ColumnValues["BlogId"] > 0);
Assert.AreEqual((int)logs[0].GetEntityFrameworkEvent().Entries[1].ColumnValues["BlogId"], (int)logs[0].GetEntityFrameworkEvent().Entries[0].PrimaryKey["Id"]);
}
public void Test_EF_IgnoreOverride_CheckCrossContexts()
{
var list = new List <AuditEventEntityFramework>();
Audit.Core.Configuration.Setup()
.UseDynamicProvider(x => x.OnInsertAndReplace(ev =>
{
list.Add(ev as AuditEventEntityFramework);
}))
.WithCreationPolicy(EventCreationPolicy.InsertOnEnd);
Audit.EntityFramework.Configuration.Setup()
.ForContext <MyTransactionalContext>(config => config
.ForEntity <IntegrationTest.Blog>(_ => _.Ignore(blog => blog.BloggerName)));
Audit.EntityFramework.Configuration.Setup()
.ForContext <MyBaseContext>(config => config
.ForEntity <IntegrationTest.Blog>(_ => _.Override <string>("Title", null)));
var title = Guid.NewGuid().ToString();
using (var ctx = new MyTransactionalContext())
{
var blog = new Blog()
{
Title = title,
BloggerName = "test"
};
ctx.Blogs.Add(blog);
ctx.SaveChanges();
}
Assert.AreEqual(1, list.Count);
var entries = list[0].EntityFrameworkEvent.Entries;
Assert.AreEqual(1, entries.Count);
Assert.AreEqual("Insert", entries[0].Action);
Assert.IsFalse(entries[0].ColumnValues.ContainsKey("BloggerName"));
Assert.AreEqual(title, entries[0].ColumnValues["Title"]);
}
public void Test_EF_ProxiedLazyLoading()
{
var list = new List <AuditEventEntityFramework>();
Audit.Core.Configuration.Setup()
.UseDynamicProvider(x => x.OnInsertAndReplace(ev =>
{
list.Add(ev as AuditEventEntityFramework);
}))
.WithCreationPolicy(EventCreationPolicy.InsertOnEnd);
Audit.EntityFramework.Configuration.Setup()
.ForContext <MyTransactionalContext>(config => config
.ForEntity <IntegrationTest.Blog>(_ => _.Ignore(blog => blog.BloggerName)));
Audit.EntityFramework.Configuration.Setup()
.ForContext <MyBaseContext>(config => config
.ForEntity <IntegrationTest.Blog>(_ => _.Override <string>("Title", null)));
var title = Guid.NewGuid().ToString().Substring(0, 25);
using (var ctx = new MyTransactionalContext())
{
var blog = ctx.Blogs.FirstOrDefault();
blog.Title = title;
ctx.SaveChanges();
}
Assert.AreEqual(1, list.Count);
var entries = list[0].EntityFrameworkEvent.Entries;
Assert.IsTrue(entries[0].GetEntry().Entity.GetType().FullName.StartsWith("Castle.Proxies."));
Assert.AreEqual(1, entries.Count);
Assert.AreEqual("Update", entries[0].Action);
Assert.IsFalse(entries[0].ColumnValues.ContainsKey("BloggerName"));
Assert.AreEqual(title, entries[0].ColumnValues["Title"]);
}
public void Test_EF_SaveOnSameContext_Transaction()
{
var b1Title = Guid.NewGuid().ToString().Substring(1, 10);
var p1Title = Guid.NewGuid().ToString().Substring(1, 10);
var logs = new List <AuditEvent>();
Audit.Core.Configuration.Setup()
.UseDynamicProvider(p => p
.OnInsert(ev =>
{
logs.Add(ev);
}))
.WithCreationPolicy(EventCreationPolicy.Manual);
using (var ctx = new MyTransactionalContext())
{
ctx.Blogs.Add(new IntegrationTest.Blog()
{
BloggerName = "fede",
Title = b1Title,
Posts = new List <IntegrationTest.Post>()
{
new Post()
{
Title = p1Title,
Content = "post1 content",
DateCreated = DateTime.Now
}
}
});
ctx.SaveChanges();
}
using (var ctx = new MyTransactionalContext())
{
var p = ctx.Posts.FirstOrDefault(x => x.Title == p1Title);
var b = ctx.Blogs.FirstOrDefault(x => x.Title == b1Title);
Assert.NotNull(p);
Assert.NotNull(b);
ctx.Blogs.Remove(b);
ctx.Posts.Remove(p);
ctx.SaveChanges();
}
using (var ctx = new MyTransactionalContext())
{
ctx.Blogs.Add(new IntegrationTest.Blog()
{
BloggerName = "ROLLBACK",
Title = "blog1-test"
});
ctx.SaveChanges();
}
using (var ctx = new MyTransactionalContext())
{
var p = ctx.Posts.FirstOrDefault(x => x.Title == p1Title);
var b = ctx.Blogs.FirstOrDefault(x => x.Title == b1Title);
Assert.Null(p);
Assert.Null(b);
}
Assert.AreEqual(3, logs.Count);
#if NET452 || NET461
Assert.IsTrue(logs[0].Environment.CallingMethodName.Contains(new System.Diagnostics.StackTrace().GetFrame(0).GetMethod().Name));
#endif
}
public void Test_EF_IncludeIgnoreFilters()
{
var logs = new List <AuditEvent>();
Audit.Core.Configuration.Setup()
.UseDynamicProvider(p => p
.OnInsert(ev =>
{
logs.Add(ev);
}));
Audit.EntityFramework.Configuration.Setup()
.ForContext <MyTransactionalContext>()
.Reset()
.UseOptOut()
.IgnoreAny(t => t.Name.StartsWith("Blo"));
using (var ctx = new MyTransactionalContext())
{
ctx.Blogs.Add(new IntegrationTest.Blog()
{
BloggerName = "fede",
Title = "blog1-test",
Posts = new List <IntegrationTest.Post>()
{
new Post()
{
Title = "post1-test",
Content = "post1 content",
DateCreated = DateTime.Now
}
}
});
ctx.SaveChanges();
}
Assert.AreEqual(1, logs.Count);
Assert.AreEqual(1, logs[0].GetEntityFrameworkEvent().Entries.Count);
Assert.AreEqual("Posts", logs[0].GetEntityFrameworkEvent().Entries[0].Table);
logs.Clear();
Audit.EntityFramework.Configuration.Setup()
.ForContext <MyTransactionalContext>()
.Reset()
.UseOptIn()
.IncludeAny(t => t.Name.StartsWith("Blog"));
using (var ctx = new MyTransactionalContext())
{
ctx.Blogs.Add(new IntegrationTest.Blog()
{
BloggerName = "fede",
Title = "blog1-test",
Posts = new List <IntegrationTest.Post>()
{
new Post()
{
Title = "post1-test",
Content = "post1 content",
DateCreated = DateTime.Now
}
}
});
ctx.SaveChanges();
}
Assert.AreEqual(1, logs.Count);
Assert.AreEqual(1, logs[0].GetEntityFrameworkEvent().Entries.Count);
Assert.AreEqual("Blogs", logs[0].GetEntityFrameworkEvent().Entries[0].Table);
#if NET452 || NET461
Assert.IsTrue(logs[0].Environment.CallingMethodName.Contains(new System.Diagnostics.StackTrace().GetFrame(0).GetMethod().Name));
#endif
}
public void Test_EF_SaveOnSameContext_Transaction()
{
var b1Title = Guid.NewGuid().ToString().Substring(1, 10);
var p1Title = Guid.NewGuid().ToString().Substring(1, 10);
var logs = new List <AuditEvent>();
Audit.Core.Configuration.Setup()
.UseDynamicProvider(p => p
.OnInsert(ev =>
{
logs.Add(ev);
}))
.WithCreationPolicy(EventCreationPolicy.Manual);
using (var ctx = new MyTransactionalContext())
{
ctx.Blogs.Add(new IntegrationTest.Blog()
{
BloggerName = "fede",
Title = b1Title,
Posts = new List <IntegrationTest.Post>()
{
new Post()
{
Title = p1Title,
Content = "post1 content",
DateCreated = DateTime.Now
}
}
});
ctx.SaveChanges();
}
using (var ctx = new MyTransactionalContext())
{
var p = ctx.Posts.FirstOrDefault(x => x.Title == p1Title);
var b = ctx.Blogs.FirstOrDefault(x => x.Title == b1Title);
Assert.NotNull(p);
Assert.NotNull(b);
ctx.Blogs.Remove(b);
ctx.Posts.Remove(p);
ctx.SaveChanges();
}
using (var ctx = new MyTransactionalContext())
{
ctx.Blogs.Add(new IntegrationTest.Blog()
{
BloggerName = "ROLLBACK",
Title = "blog1-test"
});
ctx.SaveChanges();
}
using (var ctx = new MyTransactionalContext())
{
var p = ctx.Posts.FirstOrDefault(x => x.Title == p1Title);
var b = ctx.Blogs.FirstOrDefault(x => x.Title == b1Title);
Assert.Null(p);
Assert.Null(b);
}
Assert.Equal(3, logs.Count);
}