dotnet-mssql on Mac M1 support missing

[jguadagno]

The current template dotnet-mssql does not work on a Mac with the M1 processor. You can install azure-sql-edge but the mssql-tools do not support that image.

[samruddhikhandale]

Hi 👋

I tried to reproduce & couldn't successfully create the container on M1 Mac with Dev containers.
Are you seeing errors like as follows?

Creating dotnet-msql_devcontainer_app_1 ... error

ERROR: for dotnet-msql_devcontainer_app_1  Cannot start service app: Container c13b1cb30bd52194145c4b8ab4b2610d314814d0cc9467aed5a91db946231d91 is restarting, wait until the container is running
[2023-01-23T23:24:13.969Z] 
ERROR: for app  Cannot start service app: Container c13b1cb30bd52194145c4b8ab4b2610d314814d0cc9467aed5a91db946231d91 is restarting, wait until the container is running
ERROR: Encountered errors while bringing up the project.

[jguadagno]

That might be the error. The first problem is the mcr.microsoft.com/mssql/server:2019-latest image does not work on a Mac with a M1 chips, this can be fixed by using the azure-sql-edge. However, I can not get the mssql-tools working after I change the image type.

[jguadagno]

I spend most of this morning trying to find a solution but nothing so far.