Game Store

Starting SQL Server Docker Container

$sa_password = "SA PASSWORD HERE"
docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=$sa_password" -e "MSSQL_PID=Evaluation" -p 1433:1433  --name sqlpreview --hostname sqlpreview -d -v sqlvolume:/var/opt/mssql --rm --name mssql mcr.microsoft.com/mssql/server:2022-preview-ubuntu-22.04

Setting the connection string in Secret Manager

$sa_password = "SA PASSWORD HERE"
dotnet user-secrets set "ConnectionStrings:GameStoreContext" "Server=localhost; Database=GameStore; User Id=YOUR_USERNAME; Password=YOUR_PASSWORD; TrustServerCertificate=True"