I am currently creating pipelines to deploy the solution from DEV to Prod. I have setup the pipeline it gets the solution deploys it properly but i have two queries i am not sure is there any better ways to do it or am i missing something. Please refer below for my queries.
1) There is no inbuilt functionality for connection references so i deploy a new connection reference to prod using devops than i need to go to Prod and update connection reference from default solution this is the only working way i could find .
There are two dataverse tables connection and connection referneces. connection store all connection configured in environment and connection references will have all connection references created in different solutions. i tried using this two tables to update it but the problem is update a row connection reference is not working getting Attribute 'connectionreferencelogicalname' cannot be NULL it gives the error but no attribute connectionreferencelogicalname in update row action
2) in solutions we use environment variables and its obviously different for dev and prod so how can i update them with minimum effort from the users who use devops to deploy. Currently i could not find any better way user need to update environment variables manually in the DevOps repo.
I tried to restrict the pull request for environment variable folder but failed in doing so.There is no way to do it
Is there any better way to update the Values basically i don't want users to update each time they are deploying.
i cannot use pipeline future as it requires Managed Environment
Thanks in Advance
