CSharp · Console
// Entity Framework Plus
// Doc: https://entityframework-plus.net/audit
// @nuget: Microsoft.EntityFrameworkCore.SqlServer
// @nuget: Z.EntityFramework.Plus.EFCore
using System;
using System.Linq;
using Microsoft.EntityFrameworkCore;
using System.Collections.Generic;
using Microsoft.Data.SqlClient;
using Z.EntityFramework.Plus;
using System.ComponentModel.DataAnnotations;
public class Program
{
public static void Main()
{
using (var context = new EntityContext())
{
context.Database.EnsureCreated();
}
GenerateData();
AuditManager.DefaultConfiguration.AutoSavePreAction = (context, audit) =>
{
// ADD "Where(x => x.AuditEntryID == 0)" to allow multiple SaveChanges with same Audit
var customAuditEntries = audit.Entries.Select(x => new DbAuditEntry(x)).ToList();
(context as EntityContext).AuditEntries.AddRange(customAuditEntries);
};
// Audit : Easily tracks changes, exclude/include entity or property and auto save audit entries in the database.
using (var context = new EntityContext())
{
var listToRemove = context.Customers.Where(x => x.CustomerName == "Customer_A" ).ToList();
var listToModify = context.Customers.Where(x => x.CustomerName == "Customer_B" ).ToList();
var listToAdd = new List<Customer>() { new Customer() { CustomerName = "Customer_C", ContactName = "Description"}};
context.Customers.AddRange(listToAdd); // add
context.Customers.RemoveRange(listToRemove); // remove
listToModify.First().ContactName = "Updated_A"; // modify
Audit audit = new Audit();
audit.CreatedBy = "ZZZ Projects"; // Optional
context.SaveChanges(audit);
// Access to all auditing information
var entries = audit.Entries;
}
using (var context = new EntityContext())
{
FiddleHelper.WriteTable("All Entry", context.AuditEntries.Include(x => x.Properties).AsNoTracking().ToList());
}
}
public static void GenerateData()
{
using (var context = new EntityContext())
{
context.Customers.Add(new Customer() { CustomerName ="Customer_A", ContactName = "Description"});
context.Customers.Add(new Customer() { CustomerName ="Customer_B", ContactName = "Description" });
context.SaveChanges();
}
}
public class EntityContext : DbContext
{
public EntityContext()
{
}
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
optionsBuilder.UseSqlServer(new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()));
base.OnConfiguring(optionsBuilder);
}
public DbSet<DbAuditEntry> AuditEntries { get; set; }
public DbSet<DbAuditEntryProperty> AuditEntryProperties { get; set; }
public DbSet<Customer> Customers { get; set; }
}
public class DbAuditEntry
{
public DbAuditEntry()
{
}
public DbAuditEntry(AuditEntry entry)
{
EntitySetName = entry.EntitySetName;
EntityTypeName = entry.EntityTypeName;
State = entry.State;
StateName = entry.StateName;
CreatedBy = entry.CreatedBy;
CreatedDate = entry.CreatedDate;
Properties = entry.Properties.Select(x => new DbAuditEntryProperty(x)).ToList();
}
[Key]
public int AuditEntryID { get; set; }
public string EntitySetName { get; set; }
public string EntityTypeName { get; set; }
public AuditEntryState State { get; set; }
public string StateName { get; set; }
public string CreatedBy { get; set; }
public DateTime CreatedDate { get; set; }
public List<DbAuditEntryProperty> Properties { get; set; }
}
public class DbAuditEntryProperty
{
public DbAuditEntryProperty()
{
}
public DbAuditEntryProperty(AuditEntryProperty property)
{
RelationName = property.RelationName;
PropertyName = property.PropertyName;
OldValue = property.OldValueFormatted;
NewValue = property.NewValueFormatted;
}
[Key]
public int AuditEntryPropertyID { get; set; }
public string RelationName { get; set; }
public string PropertyName { get; set; }
public string OldValue { get; set; }
public string NewValue { get; set; }
}
public class Customer
{
public int CustomerID { get; set; }
public string CustomerName { get; set; }
public string ContactName { get; set; }
}
}