PAS-427 | Redesign the signup page #1486

	name: migrations

	on:
	push:
	branches:
	- main
	pull_request:
	branches:
	- main
	release:
	types:
	- published
	workflow_dispatch:

	env:
	# Setting these variables allows .NET CLI to use rich color codes in console output
	TERM: xterm
	DOTNET_SYSTEM_CONSOLE_ALLOW_ANSI_COLOR_REDIRECTION: true
	# Skip boilerplate output
	DOTNET_SKIP_FIRST_TIME_EXPERIENCE: true
	DOTNET_NOLOGO: true
	DOTNET_CLI_TELEMETRY_OPTOUT: true

	jobs:
	script:
	strategy:
	matrix:
	app:
	- Api
	- AdminConsole
	include:
	- app: Api
	ef-context: DbGlobalMsSqlContext
	- app: AdminConsole
	ef-context: MssqlConsoleDbContext

	runs-on: ubuntu-latest
	permissions:
	contents: read

	steps:
	- name: Checkout
	uses: actions/checkout@a5ac7e51b41094c92402da3b24376905380afc29 # v4.1.6

	- name: Install .NET
	uses: actions/setup-dotnet@4d6c8fcf3c8f7a60068d26b594648e99df24cee3 # v4.0.0

	- name: Install Entity Framework toolkit
	run: dotnet tool install dotnet-ef --global

	- name: Generate script
	run: >
	dotnet ef migrations script
	--configuration Release
	--project src/${{ matrix.app }}
	--context ${{ matrix.ef-context }}
	--idempotent
	--output ${{ matrix.app }}.sql

	- name: Upload artifacts
	uses: actions/upload-artifact@65462800fd760344b1a7b4382951275a0abb4808 # v4.3.3
	with:
	name: ${{ matrix.app }}-${{ matrix.ef-context }}
	path: ${{ matrix.app }}.sql

	- name: Produce summary
	run: \|
	echo "### Idempotent migrations for ${{ matrix.app }} (${{ matrix.ef-context }})" >> $GITHUB_STEP_SUMMARY
	echo "\`\`\`sql" >> $GITHUB_STEP_SUMMARY
	cat ${{ matrix.app }}.sql >> $GITHUB_STEP_SUMMARY
	echo "\`\`\`" >> $GITHUB_STEP_SUMMARY

Provide feedback