1# Apply EF Core database migrations to Azure SQL using Managed Identity authentication.
2#
3# USAGE: Copy this file to scripts/apply-migrations.ps1 in your project root and add
4#        a postprovision hook in azure.yaml:
5#
6#   hooks:
7#     postprovision:
8#       posix:
9#         shell: sh
10#         run: ./scripts/apply-migrations.sh
11#       windows:
12#         shell: pwsh
13#         run: ./scripts/apply-migrations.ps1
14#
15# ENVIRONMENT VARIABLES (sourced from azd env):
16#   SQL_SERVER    - SQL server name (without .database.windows.net)
17#   SQL_DATABASE  - Database name
18#
19# PREREQUISITES:
20#   - dotnet-ef tool (installed automatically if missing)
21#   - A valid managed identity or Entra-authenticated session
22#
23# CONFIGURATION:
24#   Set $AppProjectPath below to the path of your application project (.csproj directory)
25 
26$ErrorActionPreference = 'Stop'
27 
28$AppProjectPath = "src/api"  # Adjust to your project directory
29 
30# Load azd environment variables
31azd env get-values | ForEach-Object {
32    $name, $value = $_.Split('=', 2)
33    Set-Item "env:$name" $value.Trim('"')
34}
35 
36# Install dotnet-ef if not already installed (no-op when already present)
37$globalTools = dotnet tool list --global 2>$null
38if ($LASTEXITCODE -ne 0) {
39    throw "Failed to list globally installed .NET tools."
40}
41if (-not ($globalTools | Select-String -Pattern '^\s*dotnet-ef\s')) {
42    dotnet tool install --global dotnet-ef
43    if ($LASTEXITCODE -ne 0) {
44        throw "Failed to install dotnet-ef."
45    }
46}
47$env:PATH += ";$env:USERPROFILE\.dotnet\tools"
48 
49$ConnectionString = "Server=tcp:$($env:SQL_SERVER).database.windows.net,1433;Database=$($env:SQL_DATABASE);Authentication=Active Directory Default;Encrypt=True;"
50 
51Write-Host "Applying EF Core migrations..."
52Set-Location $AppProjectPath
53dotnet ef database update --connection $ConnectionString
54Write-Host "Migrations applied successfully."
55