EF Core Migrations Deep Dive, Applying Migration, SQL Scripts

Get the source code for this video: Accelerate your Clean Architecture skills: Master the Modular Monolith Architecture: 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 Migration tooling: - FluentMigrator: - DbUp: - Grate: - Flyway: Join my weekly .NET newsletter: Read my Blog here: 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