How do you create and apply migrations in EF Core?

Creating and applying migrations in Entity Framework Core (EF Core) is a straightforward process that helps manage changes to your database schema over time. Here’s a step-by-step guide on how to do it:

Step 1: Set Up Your EF Core Project

Before creating migrations, ensure you have EF Core set up in your project:

1. Install EF Core Packages: If you haven't already, install the necessary EF Core packages using NuGet. At a minimum, you'll need:

   • Microsoft.EntityFrameworkCore
   • Microsoft.EntityFrameworkCore.SqlServer (or another provider)
   • Microsoft.EntityFrameworkCore.Tools

   You can install these via the NuGet Package Manager or the Package Manager Console:

   
   Install-Package Microsoft.EntityFrameworkCore
   Install-Package Microsoft.EntityFrameworkCore.SqlServer
   Install-Package Microsoft.EntityFrameworkCore.Tools
   

Step 2: Define Your Entity Models

Create or modify your entity classes. For example, if you have a Product entity, it might look like this:

public class Product
{
    public int ProductId { get; set; }
    public string Name { get; set; }
    public decimal Price { get; set; }
}

Step 3: Create a DbContext

Define a DbContext that includes a DbSet for your entity:

public class AppDbContext : DbContext
{
    public DbSet<Product> Products { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer("YourConnectionStringHere");
    }
}

Step 4: Create a Migration

After defining or modifying your entities, you can create a migration. Open your terminal or command prompt and navigate to your project directory, then use the following command:

dotnet ef migrations add InitialCreate

• Replace InitialCreate with a descriptive name for your migration.
• This command generates a new migration file in the Migrations directory of your project, containing the necessary code to create or modify the database schema based on the current model.

Step 5: Apply the Migration

To apply the migration and update the database schema, run the following command:

dotnet ef database update

• This command applies all pending migrations to the database, executing the Up() methods defined in the migration files.

Step 6: Verify Changes

After applying the migration, you can verify that the changes have been made to your database. This can be done by checking the database schema using SQL Server Management Studio or any database management tool.

Step 7: Updating the Model and Creating Additional Migrations

If you make further changes to your entity models (e.g., adding a new property), repeat the following steps:

1. Modify the entity class (e.g., add a Description property to the Product entity).

2. Create a new migration:

   dotnet ef migrations add AddProductDescription

3. Apply the migration:

   
   dotnet ef database update
   

Additional Commands

• List Migrations: To see all migrations applied to your database, use:

  
  dotnet ef migrations list
  

• Revert a Migration: If you need to roll back a migration, you can specify the name of the migration you want to revert to:

  
  dotnet ef database update PreviousMigrationName
  

• Remove a Migration: If you want to remove the last migration that hasn't been applied yet, you can use:

  
  dotnet ef migrations remove
  

Summary

Creating and applying migrations in EF Core involves:

1. Defining or modifying your entity models and DbContext.
2. Using the dotnet ef migrations add command to create a migration based on your changes.
3. Applying the migration with dotnet ef database update to update the database schema.
4. Repeating these steps as your model evolves over time.

Migrations provide a systematic way to manage schema changes and keep the database synchronized with your application's data model.