Search code examples
entity-frameworkentity-framework-4

Logging changes through Entity Framework

Can anyone direct me to a good strategy for implementing change tracking in my Entity Framework model?

I have around 20 entities to track changes on (accessed via facades / unit of work) and I need to be able to display who changed what when on displaying the record in the UI.

I know there's Context.OnSavingChanges (or whatever it's called) but I'd probably want to access the changes in queries like context.MyEntity.ChangeLog

Must I create a ChangeLog entity, add associations to all the entities or is there a better via via savingchanges?

Richard

P.s. Have a great weekend!

Solution

  • Entity framework is ORM = API responsible for persistence and loading from database. What you persist or load is completely up to you so if you want change tracking you must to code it.

    The most common approach is indeed using OnSavingChanges or overriding SaveChanges because you are usually saving changed executed by single user.