EF Core Migrations Deep Dive, Applying Migration, SQL Scripts

Get the source code for this video: https://www.patreon.com/milanjovanovic Accelerate your Clean Architecture skills: https://bit.ly/3PupkOJ Master the Modular Monolith Architecture: https://bit.ly/3SXlzSt Managing database schemas as your applications grow can quickly become a headache. Manual changes are error-prone and time-consuming, which can easily lead to inconsistencies between development and production environments. I've seen these issues firsthand on countless projects, and they're not pretty. How can we do better? Enter Entity Framework (EF) Migrations, a powerful tool that lets you version your database schemas. Imagine this: Instead of writing SQL scripts, you define your changes in code. Need to add a column? Rename a table? No problem - EF Migrations has you covered. It tracks every modification to the data model. You can review, test, and apply changes confidently, even across different environments. EF Core Migrations: A Detailed Guide https://www.milanjovanovic.tech/blog/efcore-migrations-a-detailed-guide Migration tooling: - FluentMigrator: https://fluentmigrator.github.io/ - DbUp: https://dbup.readthedocs.io/en/latest/ - Grate: https://erikbra.github.io/grate/ - Flyway: https://flywaydb.org/ Join my weekly .NET newsletter: https://www.milanjovanovic.tech Read my Blog here: https://www.milanjovanovic.tech/blog Chapters 0:00 What are EF Core migrations? 2:13 Configuring an EF Entity 5:18 Creating a database migration 6:27 Creating another database migration 7:55 Applying EF Core database migrations 10:01 Generating SQL Scripts for EF migrations 12:11 Writing custom SQL in EF migrations 13:00 Additional database versioning tools 14:15 EF Core migrations best practices