Requires .NET 8 SDK
dotnet new sln -o MyApi
cd MyApi
dotnet new webapi -o MyApi
dotnet sln add ./MyApi/MyApi.csproj
dotnet new xunit -o MyApi.Tests
dotnet sln add ./MyApi.Tests/MyApi.Tests.csproj
dotnet add ./MyApi.Tests/MyApi.Tests.csproj reference ./MyApi/MyApi.csproj
rem Add database project for MS-SQL projects
rem https://github.com/microsoft/dacfx
rem SQL Server Data Tools (SSDT) must be installed!
rem https://visualstudio.microsoft.com/en/vs/features/ssdt/
dotnet new install "Microsoft.Build.Sql.Templates"
dotnet new sqlproj -o Database
dotnet sln add ./Database/Database.sqlproj
rem Add git and editor files to project root
dotnet new editorconfig
dotnet new gitignore
rem Add packages to the main project
cd MyApi
dotnet add package DotNetEnv
rem dotnet add package MySql.Data
dotnet add package System.Data.SqlClient
dotnet add package sqlkata
dotnet add package SqlKata.Execution
rem Optional
rem Swagger
dotnet add package Swashbuckle.AspNetCore