Get Docker working for local development - SQL not working

[sadukie]

Problem

I was hoping I could avoid installing LocalDB by running the Docker version of this. However, I'm running into issues.

• As noted in Update Docker images to use SQL Server images #135, this is set to use Azure SQL Edge. However, I've tested this also with SQL Server's 2022-latest tag as well with the same results.

I'm getting this error:

SqlException: Cannot open database "Microsoft.eShopOnWeb.CatalogDb" requested by the login. The login failed. Login failed for user 'sa'.

This is what I see when I try to connect to the MVC app in the Docker Container:

The EF migrations can't be applied because the databases don't exist for the Catalog nor for Identity.

Additional Notes

We need to create the databases for the EF contexts. We also need to run the migrations for this to work for Docker.

[sadukie]

More notes...

• There are calls to .Database.Migrate() in the SeedAsync() calls. These should be creating the database if it doesn't exist but do not appear to be working in the Docker setup.
• I looked at bringing in .Database.EnsureCreated(), which did create the databases... but... EnsureCreated and Migrate don't work together.

[sadukie]

This appears to be working now. @Coop56 also confirmed it working locally as well. So updates have got this in a better spot.