Logging history of user changes in EF CodeFirst

Question

I want save history of user changes on DB Records. Changes such as edit records (for example value of FirstName field changed from 'n ' to 'x' by user1 in yyyy/dd/mm") , Delete Records and ... .

please suggest a method to implement this in EF codefirst.

After Edit:
And which one is better?
1.Create one table to save all tables log
2.Create a table for each table in database

Similar question here: http://stackoverflow.com/q/6156818/270591 — Slauma, Aug 13 '12 at 21:41
From what you describe I see only that you need a log table with something like this: Date, User, TableName, RecordIdentifier (PK value probably), ColumnName, OldValue, NewValue, Action (Delete, Insert, Update?). Do you see any benefit in option 2? — Slauma, Aug 13 '12 at 21:54
it is great... Please answer below and i choose it as correct answer.tnx — Hossein Moradinia, Aug 13 '12 at 22:08

score 2 · Accepted Answer · answered Aug 12 '12 at 16:23

Override the SaveChanges method.

In your SaveChanges method loop through the entries using ObjectStateManager.GetObjectStateEntries

Then use the ObjectStateEntry CurrentValues.DataRecordInfo.FieldMetadata[].FieldType.Name and the entry.CurrentValues to get the name value pairs

Logging history of user changes in EF CodeFirst

1 Answers1

Linked