I'm looking at using Entity Framework 6.1.1 with SQL Server 2008 R2.
Currently I'm creating my models and database using the code-first EF feature. My basic use-case is to create a journal of all changes to a particular entity (ID
is the key column) to help auditors track all changes made and by whom. e.g:
|ID|Version|Created Date|Created By|Modified Date|Modified By|Modify Action| ... (rest of entity fields)
-------------------------------------------------------------------------------------------------------
| 4| 12 | 12-Mar-14 | tom | 20-Feb-15 | jack | Update |
| 4| 11 | 12-Mar-14 | tom | 14-Feb-15 | jill | Update |
| 4| 1 | 12-Mar-14 | tom | 12-Mar-14 | tom | Create |
Does Entity Framework support this type of database scheme? If so, how can I set my models/solution up to facilitate this?
The other alternative I have is by intercepting all calls to the SaveChanges()
method on the DbContext
and log all database changes into a separate Audit
table, but this might make retrieving information more challenging.
Any help on creating audit trails with SQL Server and EF 6 would be greately appreciated.