update dotnet.yml #41

	name: .NET Core CI with Docker

	on:
	push:
	branches:
	- main
	pull_request:
	branches:
	- main

	jobs:
	build:
	runs-on: ubuntu-latest
	services:
	sql-server:
	image: mcr.microsoft.com/mssql/server:2022-CU13-ubuntu-22.04
	ports:
	- 1433:1433
	options: >-
	--env ACCEPT_EULA=Y
	--env SA_PASSWORD=YourStrong!Passw0rd
	--health-cmd="/opt/mssql-tools/bin/sqlcmd -U sa -P YourStrong!Passw0rd -Q 'SELECT 1'"
	--health-interval=10s
	--health-timeout=5s
	--health-retries=10
	redis:
	image: redis:latest
	ports:
	- 6379:6379
	options: --health-cmd "redis-cli ping \|\| exit 1"

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

	- name: Set up .NET Core
	uses: actions/setup-dotnet@v4
	with:
	dotnet-version: '8.0.x'

	- name: Run Format
	run: dotnet format ./CacheManager.sln

	- name: Restore dependencies
	run: dotnet restore

	- name: Build the project
	run: dotnet build --configuration Release

	- name: Run tests
	run: dotnet test --configuration Release --no-build

	- name: Set up CodeQL
	uses: github/codeql-action/setup@v3
	with:
	languages: 'csharp'

	- name: Perform CodeQL Analysis
	uses: github/codeql-action/analyze@v3
	with:
	category: 'security'

Provide feedback