Entity Framework Core Integration

Overview

Curiosity.Migrations supports using Entity Framework Core inside your code migrations. This allows you to perform complex data operations using an ORM rather than raw SQL.

Using Entity Framework in Migrations

Attaching to Connection

When creating an Entity Framework DbContext within a code migration, you can attach it to the same database connection that the migration is using:

public override async Task UpgradeAsync(DbTransaction? transaction = null, CancellationToken cancellationToken = default)
{
    // Create DbContext options using the migration's connection
    var contextOptionsBuilder = new DbContextOptionsBuilder<MyDbContext>();
    contextOptionsBuilder.UseNpgsql(MigrationConnection.Connection!);

    // Create your context with the configured options
    await using (var dbContext = new MyDbContext(contextOptionsBuilder.Options))
    {
        // Attach the migration's transaction to the context
        await dbContext.Database.UseTransactionAsync(transaction, cancellationToken);

        // Perform EF operations
        // ...

        await dbContext.SaveChangesAsync(cancellationToken);
    }
}

Transaction Control

By default, code migrations run within a transaction. You can disable this behavior by setting IsTransactionRequired = false in your migration constructor:

public MyCodeMigration()
{
    IsTransactionRequired = false; // Disable automatic transaction
}

When transactions are disabled, you can manually create transactions for specific operations:

public override async Task UpgradeAsync(DbTransaction? transaction = null, CancellationToken cancellationToken = default)
{
    // Create a custom transaction for a specific operation
    using (var customTransaction = MigrationConnection.BeginTransaction())
    {
        // Use the transaction with Entity Framework
        var contextOptionsBuilder = new DbContextOptionsBuilder<MyDbContext>();
        contextOptionsBuilder.UseNpgsql(MigrationConnection.Connection!);

        await using (var dbContext = new MyDbContext(contextOptionsBuilder.Options))
        {
            await dbContext.Database.UseTransactionAsync(customTransaction, cancellationToken);

            // Perform operations
            // ...

            await dbContext.SaveChangesAsync(cancellationToken);
        }

        customTransaction.Commit();
    }
}