add-migration

Add EF Core Migration

Create a new EF Core migration for a microservice's database context.

Arguments

• {Name} -- Migration name in PascalCase (e.g., AddOrdersTable)
• {Service} -- Target microservice (ask if ambiguous)

Configuration

Read cloudstack.json from the project root at the start of execution. Extract:

• SERVICES = backend.services[] (default: discover from src/*/ directories containing .Application/ subfolders)
• SOLUTION = backend.solutionPath (default: find *.sln in src/)

If cloudstack.json does not exist, auto-detect by scanning the project structure.

Service DbContext Discovery

If a service-to-DbContext mapping is not defined in cloudstack.json, auto-detect by searching for *DbContext.cs files:

grep -rn "class.*DbContext" src/{Service}/**/Infrastructure/ --include="*.cs"

Find the Infrastructure and Host projects:

find src/{Service} -name "*.Infrastructure.csproj" -o -name "*.Host.csproj"

Process

Step 1: Verify Changes

Before creating a migration, check that entity configurations are in place:

# Find the entity configuration
grep -rn "IEntityTypeConfiguration" src/{Service}/

Step 2: Create Migration

Run from the Infrastructure project directory:

dotnet ef migrations add {Name} \
  --project src/{Service}/{Service}.Infrastructure \
  --startup-project src/{Service}/{Service}.Host \
  --output-dir Persistence/Migrations

If the startup project differs from the convention, search for the .Host project:

find src/{Service} -name "*.Host.csproj" -o -name "*.Host" -type d

Step 3: Review Migration

Read the generated migration file and verify:

• Only expected changes are included
• No data loss operations (dropping columns/tables) without user confirmation
• Index names follow conventions
• Foreign keys are correct

# Find the latest migration
ls -t src/{Service}/**/Migrations/*.cs | head -2

Step 4: Apply Migration (Optional)