Database Migration

Database migration via EF Bundle.

If your .NET project is using Entity Framework (EF) to manage database migrations, you can apply these migrations directly in GitHub Actions workflows. We recommend using EF Migration Bundles when migrating in your pipelines.

Two reusable workflows are available to make this easier to do:

• Generate EF Bundle
• Apply EF Bundle

Usage

Given the following example project structure:

Kattehotell/
└──── Data/
    ├── Data.csproj
    ├── DbContext.cs
    ├── Migrations/
    │   ├── YYYYMMDDHHMMSS_migration.Designer.cs
    │   ├── YYYYMMDDHHMMSS_migration.cs
    │   └── ...
    │
    └── ...

The following workflow can be used:

name: Migrate Database

on:
  push:
    branches: [master]
  workflow_dispatch:

jobs:
  generate-ef-bundle:
    uses: BYM-IKT/github-actions/.github/workflows/generate-ef-bundle.yml@v1
    secrets: inherit
    with:
      path-to-project: "Kattehotell/Data/Data.csproj"

  apply-ef-bundle:
    needs: [generate-ef-bundle]
    uses: BYM-IKT/github-actions/.github/workflows/apply-ef-bundle.yml@v1
    with:
      aws-account-id-target:       "<<YOUR-AWS-ACCOUNT-ID>>"
      connection-string-secret-id: "<<NAME-OR-ARN-OF-SECRETSMANAGER-SECRET>>"