'EF6 Temporal Table for Auditing

Is there a way to record who did the change within the Temporal table? I can see the date ranges but I can't see a way of adding a new column to the schema?

sql-serverentity-framework


Solution 1:[1]

Temporal tables don't track "who" only "when". You can add a column to the table to track who performed the last modification, setting that value in an override to DbContext.SaveChanges() or in a Trigger.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 David Browne - Microsoft

Related Questions