Hi

I am a MacOS user, and I suggest :

• using a normal C# editor (Jetbrains Rider, Visual Studio , VS Code but a but tricky)

• a custom Program.cs settings like this one .ConfigureAppConfiguration((ctx, builder) => { builder.AddJsonFile("appsettings.json", false, false) .AddJsonFile("appsettings.Development.json", optional: true, reloadOnChange: false) .AddJsonFile("appsettings.local.json", optional: true, reloadOnChange: false) .AddEnvironmentVariables(); });

• and your appsettings.local.json contains :

"ConnectionStrings": { "umbracoDbDSN": "Server=127.0.0.1;Database=Umbraco;user=SA;password='password';TrustServerCertificate=False;Encrypt=False"},

• using a docker-compose.yml that you start in Docker, with this kind of template :

version: '3.3' services: umbraco-db: container_name: umbraco-db image: mcr.microsoft.com/azure-sql-edge:latest volumes: - ./data:/var/opt/mssql/data:rw environment: ACCEPT_EULA: "1" MSSQL_SA_PASSWORD: "password" MSSQL_PID: "Developer" MSSQL_USER: "SA"

it should be working well.

please note that you need to create a Database (using Azure Data Studio for exemple) named Umbraco inside your brand new container.