audit-trail – Tarik Billa

Maintaining Referential Integrity – Good or Bad?

September 11, 2023 by Tarik

When discussing auditing, I would go back to the purpose behind it. It isn’t really a backup but rather a history of what has been. For example, for StudentScore, you would want to be sure not to lose the fact that the student originally had a 65% when they now have a 95%. This audit … Read more

Entity Framework 6: audit/track changes

April 20, 2023 by Tarik

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() { … Read more