Lection 54, Adding Docker Containers, Docker Compose, Volumes

1. Right mouse click on the Project "D:\projects\dotnet\IdSrv4Quickstart\src\FirstIdSrvAspNetIdentity" - Add - Docker Support

2. Right mouse click on the Project - Add - Orchestration - docker-compose. A new project will be created

3. Change the connection string to use MS SQL from a container
{
"ConnectionStrings": {
"DefaultConnection": "Server=db;Database=master;User=sa;Password=PaSs1234;"
}
}
4. Add to docker-compose.yml
...
depends_on:
- db
db:
image: "mcr.microsoft.com/mssql/server"
environment:
SA_PASSWORD: "PaSsword1234"
ACCEPT_EULA: "Y"

5. You can access the containers e.g.: PS docker exec -it idsrv4quickstart_db_1 /bin/bash

6. Use cli to manage MS SQL server:
/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P "PaSs1234"

SELECT name FROM master.sys.databases
GO

SELECT * FROM INFORMATION_SCHEMA.TABLES;
GO

7. To make MS SQL work with volumes:
Add to
...
db:
volumes:
- type: volume
source: firstidsrvaspnetidentitydbsys
target: /var/opt/mssql
- type: volume
source: firstidsrvaspnetidentitydbusr
target: /var/opt/sqlserver
...
volumes:
firstidsrvaspnetidentitydbsys:
firstidsrvaspnetidentitydbusr:

References:
Visual Studio Container Tools with ASP.NET Core: https://docs.microsoft.com/en-us/aspnet/core/host-and-deploy/docker/visual-studio-tools-for-docker?view=aspnetcore-3.1

Tutorial: Containerize a .NET Core app: https://docs.microsoft.com/en-us/dotnet/core/docker/build-container?tabs=windows

Dockerize an ASP.NET Core application: https://docs.docker.com/engine/examples/dotnetcore/

Configure SQL Server container images on Docker: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-docker?view=sql-server-ver15

Quickstart: Run SQL Server container images with Docker: https://studio.youtube.com/channel/UCUfKsDCgAIPaIOa7ihdEtow/videos/upload?d=ud&filter=%5B%5D&sort=%7B%22columnType%22%3A%22date%22%2C%22sortOrder%22%3A%22DESCENDING%22%7D

SQL Server 2017 Docker Container And Web API In .Net Core: https://www.c-sharpcorner.com/article/sql-server-2017-docker-container-and-web-api-in-net-core/

Quickstart: Compose and ASP.NET Core with SQL Server: https://docs.docker.com/compose/aspnet-mssql-compose/

Overview of Docker Compose: https://docs.docker.com/compose/

Quickstart: Run SQL Server container images with Docker: https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-ver15&pivots=cs1-powershell

Using docker named volumes to persist databases in SQL Server: https://dbafromthecold.com/2019/03/21/using-docker-named-volumes-to-persist-databases-in-sql-server/