I have a scenario where my Azure App Service is connecting to Azure SQL Managed Instance. There are more than one DB inside the Instance.
How do I connect to a particular DB so that I can fetch table's values? I see that the connection string in the portal doesn't have any parameter particularly referring to a DB.
Can I manually add 'Initial Catalog = mydbname ' to the connection string? Will it work?