remember to use DbContext.Database.BeginTransaction() https://docs.microsoft.com/en-us/ef/core/saving/transactions