Installation

I - DotNET SDK (version 8.0.203) Reference

• GitHub Installation guide: Reference

II - MS SQL Server 2022 16.x (on docker container, linux version) Reference

• Note that newest MSSQL version run with MSSQL_SA_PASSWORD keyword replace for SA_PASSWORD
• Disable sa account for production security best practice
• Container restart policy: --restart=unless-stopped
• For Apple chip: --platform linux/amd64

• Shell script:

  docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=Aa@123456" \
  -p 1433:1433 --name sql2022 --hostname sql2022 \
  -d \
  --restart=unless-stopped \
  --platform linux/amd64 \
  mcr.microsoft.com/mssql/server:2022-latest

III - Project setup

• Shell script:

  dotnet new webapi
  dotnet add package Serilog
  dotnet add package Serilog.AspNetCore
  dotnet add package Serilog.Extensions.Logging
  dotnet add package Serilog.Settings.Configuration
  dotnet add package Serilog.Sinks.Seq
  dotnet add package Serilog.Sinks.Console
  dotnet add package Serilog.Sinks.File
  dotnet add package Microsoft.EntityFrameworkCore.Tool
  dotnet add package Microsoft.EntityFrameworkCore.Design
  dotnet add package Microsoft.EntityFrameworkCore.SqlServer
  dotnet add package Microsoft.AspNetCore.Identity.EntityFrameworkCore
  dotnet add package Microsoft.AspNetCore.Authentication.JwtBearer