I've setup our local dev environment to use CI (through PowerShell) and each developer has their own db, this works well.
I'm not looking to setup a dev build on Azure app service, using YAML pipeline to build and deploy, and wanted to get suggestions on best approach to setting up/running CI.
My current thoughts are,
Extract and run CI in the pipeline, but I'm setting connection strings in the app settings, so they're not in the pipeline (although I could do a web transform), also our SQL db is restricted to the web app and our office, so not sure how I would allow Agent VM access
Use an azure function although no real idea how it will connect to the file system etc..
Execute CI FileSystemRepositoryManager.RestoreAll on admin start up, but not sure on implications, as recommended to run externally
I've ended up using the post deployment script to run CI on the Azure service, and it appears to work well
Please, sign in to be able to submit a new answer.