Unknown Database error when running initial migration
Connection string is: "Server=127.0.0.1;Database=MyDatabase;Uid=username;Pwd=secret;"
Entity Framework Core 7
My SQL version 8.0.32
Initial migration is scaffolded using `add-migration`.
However `update-database` fails with error: "Unknown Database MyDatabase"
I know the connection string is correct and the database is accessible because I just conducted exactly the same POC for the Pomelo library as part of the evaluation I'm working on, and it worked first time.
I also tried using the workaround, but it didn't help:
MySqlEntityProviderConfig config = MySqlEntityProviderConfig.Instance;
config.Workarounds.IgnoreSchemaName = true;