I've asked this question on SE and MSDN, but I can't link to the pages here as my comment gets rejected as spam. Title of both questions is "Add extra database command with CommandTree interceptor".
I am trying to implement an auditable datastore in Entity Framework using interceptors as detailed in this video. My intention is to keep a history of every record's state at any given point in time. This requires that I convert all delete statements to updates and all update statements to update + insert.
The issue I'm running into is that I cannot figure out a way to add an extra insert into the command tree. Is this possible with EF Interceptors?