Entity Framework 6: audit/track changes

by

If using EF6’s DbContext you can use ChangeTracker in SaveChanges override to find added/modified entities of custom type, for example IAuditedEntity.

public interface IAuditedEntity {
  string CreatedBy { get; set; }
  DateTime CreatedAt { get; set; }
  string LastModifiedBy { get; set; }
  DateTime LastModifiedAt { get; set; }
}

public override int SaveChanges() {
  var addedAuditedEntities = ChangeTracker.Entries<IAuditedEntity>()
    .Where(p => p.State == EntityState.Added)
    .Select(p => p.Entity);

  var modifiedAuditedEntities = ChangeTracker.Entries<IAuditedEntity>()
    .Where(p => p.State == EntityState.Modified)
    .Select(p => p.Entity);

  var now = DateTime.UtcNow;

  foreach (var added in addedAuditedEntities) {
    added.CreatedAt = now;
    added.LastModifiedAt = now;
  }

  foreach (var modified in modifiedAuditedEntities) {
    modified.LastModifiedAt = now;
  }

  return base.SaveChanges();
}

More Related Contents:

  1. Entity Framework Provider type could not be loaded?
  2. How to update record using Entity Framework 6?
  3. How to filter “Include” entities in entity framework?
  4. EF Code-First One-to-one relationship: Multiplicity is not valid in Role * in relationship
  5. Entity Framework 6 GUID as primary key: Cannot insert the value NULL into column ‘Id’, table ‘FileStore’; column does not allow nulls
  6. Mapping composite keys using EF code first
  7. Setting unique Constraint with fluent API?
  8. Lazy Loading vs Eager Loading
  9. Implementing Audit Log / Change History with MVC & Entity Framework
  10. Dynamic MySQL database connection for Entity Framework 6
  11. Entity Framework 6 Code First Custom Functions
  12. DbSet.Attach(entity) vs DbContext.Entry(entity).State = EntityState.Modified
  13. Problems using Entity Framework 6 and SQLite
  14. Database.BeginTransaction vs Transactions.TransactionScope [duplicate]
  15. Save detached entity in Entity Framework 6
  16. Eager , Lazy and explicit loading in EF6
  17. Configure multiple database Entity Framework 6
  18. Entity Framework 6 transaction rollback
  19. Log Queries executed by Entity Framework DbContext
  20. How are people unit testing with Entity Framework 6, should you bother?
  21. Async PartialView causes “HttpServerUtility.Execute blocked…” exception
  22. How to group by DateTime.Date in EntityFramework
  23. How to use String property as primary key in Entity Framework
  24. How does the SQLite Entity Framework 6 provider handle Guids?
  25. How can set a default value constraint with Entity Framework 6 Code First?
  26. Entering keys manually with Entity Framework
  27. The cast to value type ‘Int32’ failed because the materialized value is null
  28. What are the downsides to turning off ProxyCreationEnabled for CTP5 of EF code first
  29. How to COUNT rows within EntityFramework without loading contents?
  30. Simulating Cross Context Joins–LINQ/C#

Leave a Comment