I have my core project in C#.

I work on a database, where some tables have the columns &quot;user_mod&quot; and &quot;date_mod&quot; for sign who and when made some mods and the same with &quot;data_new&quot; and &quot;user_new&quot;.

My question: is there a way to centralize this and make this data inserted automatically, where I create the instance of `dbContext`?

If not, I will use an audit trail tool. I have seen some of these, but there is a problem: all of these, require some code in my model. But I don&#39;t want to write in my model, because if I have to change it, I will lost the mods. Is it possible use an audit trail for EF6 without writing in the model file(s)? How?


EDIT:

My attempt to override the saveChanges.


    public partial class PieEntities : DbContext
    {
        public override int SaveChanges(System.Data.Objects.SaveOptions options)
        {
            var timestamp = DateTime.Now;

            EntityState es = EntityState.Added;
            ObjectStateManager o = new ObjectStateManager();
     
            foreach (ObjectStateEntry entry in o.GetObjectStateEntries(EntityState.Added ))  {
                if (entry.Entity.GetType() == typeof(TabImpianti)) {
                    TabImpianti impianto = entry.Entity as TabImpianti;
                    impianto.DATA_INS = timestamp;
                    impianto.DATA_MOD = timestamp;
                    string u = mdlImpostazioni.p.UserName;
                    impianto.USER_INS = u;
                    impianto.USER_MOD = u;
                }
            }
            return base.SaveChanges(options);
        }
    }

**UPDATE: I&#39;ve summarized the [solution here][1].**


  [1]: https://programmingistheway.wordpress.com/2016/02/11/entity-framework-6-audittrack-changes/

All Audit Trail Solutions on Gang of Coders

Total of 1 Audit Trail Solutions

Entity Framework 6: audit/track changes