Good morning, I am having a very strange issue with Umbraco. we have recently made a push to move our configuration out of app settings and into azure app configuration and key vault for secrets. I have set up a dev environment that has the usual local dev settings that everyone in my team can use. the connection string for Umbraco db is now stored there. when the conn string is in the old appsettings it works fine but when it's only from the azure provider it asks me to install Umbraco db.
usual conn string for local development
Server=.;Database=DbName;User Id=sa;Password=PasswordHere;MultipleActiveResultSets=true;TrustServerCertificate=True
debugging I can see the config provider fine. I can see it being used in the AddUmbraco() extension when I debug it (Downloaded the source code and pointed to it instead of the nuget to get the symbols etc). However when it goes into the AddBackOffice() extension it seems to be pulling in a completely different IConfiguration. I'm not sure where it's coming from and it only contains the appsettings.json, and not my azure one that i passed into the original builder. can anyone advice if there's some way to force it to use the configuration I provided?