dotnet / dotnet/EntityFramework.Docs

Document how to add timestamps to the __EFMigrationsHistory table

Open
#2,812 3 comments 1 reaction 0 assignees View on GitHub
area-migrations
Dominant language
Mermaid
Stars
1.7k
Forks
2k
Avg merge
7d 23h
Merged PRs (30d)
16

Description

**Problem:**
Sometimes migrations doesn't work perfectly for some reason. It's often a bit hard to debug why because you can't check when a certain migration was applied to that database. It could be because some migrations depend on each other, but it could also be because a migration created corrupt data and we need to track that back.

**Proposal:**
Add a timestamp column in the __EFMigrationsHistory table that inserts a `GETDATE()` on inserts.

**Possible issues:**
Some people might have added this through their own migrations before. So there could be a collision. I guess the script could possibly check that before creating the column or it could be configurable.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.