Entity Framework/SQL2008 – How to Automatically Update LastModified fields for Entities?

by

I know I’m a little late to the party, but I just solved this for a project I’m working on and thought I’d share my solution.

First, to make the solution more re-usable, I created a base class with the timestamp properties:

public class EntityBase
{
    public DateTime? CreatedDate { get; set; }
    public DateTime? LastModifiedDate { get; set; }
}

Then I overrode the SaveChanges method on my DbContext:

public class MyContext : DbContext
{
    public override int SaveChanges()
    {
        ObjectContext context = ((IObjectContextAdapter)this).ObjectContext;

        //Find all Entities that are Added/Modified that inherit from my EntityBase
        IEnumerable<ObjectStateEntry> objectStateEntries =
            from e in context.ObjectStateManager.GetObjectStateEntries(EntityState.Added | EntityState.Modified)
            where
                e.IsRelationship == false &&
                e.Entity != null &&
                typeof(EntityBase).IsAssignableFrom(e.Entity.GetType())
            select e;

        var currentTime = DateTime.Now;

        foreach (var entry in objectStateEntries)
        {
            var entityBase = entry.Entity as EntityBase;

            if (entry.State == EntityState.Added)
            {
                entityBase.CreatedDate = currentTime;
            }

            entityBase.LastModifiedDate = currentTime;
        }

        return base.SaveChanges();
    }
}

More Related Contents:

  1. Entity Framework/Linq to SQL: Skip & Take
  2. LINQ to Entities case sensitive comparison
  3. Entity Framework 4 – AddObject vs Attach
  4. Entity Framework/Linq EXpression converting from string to int
  5. A dependent property in a ReferentialConstraint is mapped to a store-generated column
  6. Why re-initiate the DbContext when using the Entity Framework?
  7. Entity Framework – Invalid Column Name ‘*_ID”
  8. Exclude a field/property from the database with Entity Framework 4 & Code-First
  9. Internal .NET Framework Data Provider error 1025
  10. Syncing SQL Server 2008 Databases over HTTP using WCF & Sync Framework
  11. Entity Framework Code Only error: the model backing the context has changed since the database was created
  12. Entity Framework 4: How to find the primary key?
  13. Entity Framework Code First AddOrUpdate method insert Duplicate values
  14. Passing datatable to a stored procedure
  15. Change db table name in EF4 (entity framework 4)
  16. Entity Framework Multiple Object Contexts
  17. 3 Digit currency code to currency symbol
  18. The principal end of this association must be explicitly configured using either the relationship fluent API or data annotations
  19. Repository Pattern, POCO, and Business Entities
  20. What’s wrong with using Thread.Abort()
  21. Converting Bitmap PixelFormats in C#
  22. Clipboard.GetText returns null (empty string)
  23. How does inheritance work for Attributes?
  24. .NET ObservableDictionary
  25. What is the correct way to read from NetworkStream in .NET
  26. WCF Service Client: The content type text/html; charset=utf-8 of the response message does not match the content type of the binding
  27. System.Threading.Timer in C# it seems to be not working. It runs very fast every 3 second
  28. How to check if a DLL file is registered?
  29. Uninstall Custom Action Not Deleting Registry Key
  30. Compare two Color objects

Leave a Comment