build(efcore): use LocalDB for SQL testing #5

	name: EFCore Utilities

	on:
	workflow_dispatch:
	push:
	paths:
	- 'src/entityframeworkcore/**'

	env:
	solutionFolder: 'src/entityframeworkcore'
	buildConfiguration: 'Release'

	permissions:
	contents: read
	packages: write

	jobs:
	build:
	name: Build and Pack
	runs-on: windows-2022

	steps:
	- name: Checkout code
	uses: actions/checkout@v4

	- name: Install SQL LocalDB
	run: ${{ env.solutionFolder }}/InstallLocalDB.ps1
	shell: pwsh

	- name: Setup .NET
	uses: actions/setup-dotnet@v4
	with:
	dotnet-version: \|
	3.1.x
	5.0.x
	6.0.x
	7.0.x
	8.0.x

	- name: Set Build Number
	run: \|
	echo "BUILD_NUMBER=$((3000+${{ github.run_number }}))" >> "${{ github.env }}"

	- name: Restore dependencies
	run: dotnet restore ${{ env.solutionFolder }}

	- name: Build
	run: dotnet build ${{ env.solutionFolder }} --no-restore --configuration ${{ env.buildConfiguration }} /p:ContinuousIntegrationBuild=true /p:BuildNumber=${{ env.BUILD_NUMBER }}

	- name: Start SQL LocalDB
	run: sqllocaldb start mssqllocaldb

	- name: Test
	run: dotnet test ${{ env.solutionFolder }} --no-restore --no-build --configuration ${{ env.buildConfiguration }}

	- name: Pack
	run: dotnet pack ${{ env.solutionFolder }} --no-restore --no-build --configuration ${{ env.buildConfiguration }} --output ${{ github.workspace }}/artifacts /p:ContinuousIntegrationBuild=true /p:BuildNumber=${{ env.BUILD_NUMBER }}

	- name: Publish packages
	uses: actions/upload-artifact@v4
	with:
	name: nuget
	path: ${{ github.workspace }}/artifacts/*.nupkg

Provide feedback