Synchronise EF Core Database with Code

update-database.ps1

param (
  [Parameter(Mandatory=$true)][string]$project
  [Parameter(Mandatory=$true)][string]$context
  [string]$startupProject
)

Set-Location $PSScriptRoot

if (-Not ($startupProject))
{
  $startupProject = $project
}

# check current dotnet version
$dotnet_version = dotnet --version

# check whether global tools are supported
if([System.Version]$dotnet_version -ge [System.Version]"2.1.301")
{
	# get last migration
	$lastMigration = dotnet ef migrations list --project $project --startup-project $startupProject --context $context | Select-Object -Last 1
	
	dotnet ef database update $lastMigration --project $project --startup-project $startupProject --context $context
}
else
{
	Write-Output "Your version of .NET Core is $dotnet_version, version 2.1.301 or greater is required"
}