What is a common mistake with EF Core migrations in Entity Framework Core?

Automatically applying unreviewed migrations at application startup can cause long locks or breaking production changes. In practice, the value of this concept comes from understanding where it belongs in the architecture, what problem it solves, and what constraints or tradeoffs it introduces.