Entity Framework Core Cookbook - Second Edition

Capturing the audit data

So, we want to track every time a record was changed. There are several ways to do this, but we'll do it the Entity Framework way, so that we do not depend on any database-specific features–see, for example, the Change Data Tracking feature of SQL Server Enterprise.

The data we're interested in is as follows:

• Creation timestamp
• Creation user
• Last update timestamp
• Last update user

Getting ready

We will be using the NuGet Package Manager to install the Entity Framework Core 1 package, Microsoft.EntityFrameworkCore. We will also be using a SQL Server database to store the data, so we will also need Microsoft.EntityFrameworkCore.SqlServer.

We also need the System.Security.Principal.Windows package in order to get the current logged-in ...