Hoping the comminuty can help. I'm new to Umbraco and tried to get my first site running. I installed the templates into VS 2022 from the instructions at
https://docs.umbraco.com/umbraco-cms/v/13.latest-lts/fundamentals/setup/install/visual-studio. I created an app and tried to run it. Firstly I get an error saying that the /wwwroot/media folder didn't exist, so I created that. Then the site loaded. I changed the db type to Azure SQL and entered my credentials. The install started and a heap of database tables were created but is failed with the error "Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object name 'umbracoOpenIddictApplications'"
Not sure where to go from here as I can't even get the app to run 🤷♂️😒