Make 'Sync' methods in ConnectionManagerAsync and ConnectionPoolAsync throw exceptions

[nathanwoctopusdeploy]

Background

Make 'Sync' methods in ConnectionManagerAsync and ConnectionPoolAsync throw exceptions

Related to https://github.com/OctopusDeploy/Issues/issues/8266

How to review this PR

Quality :heavy_check_mark:

Pre-requisites

• [ ] I have read How we use GitHub Issues for help deciding when and where it's appropriate to make an issue.
• [ ] I have considered informing or consulting the right people, according to the ownership map.
• [ ] I have considered appropriate testing for my change.

[nathanwoctopusdeploy]

[sc-56885]

[shortcut-integration[bot]]

This pull request has been linked to Shortcut Story #56885: Make 'Sync' methods in ConnectionManagerAsync and ConnectionPoolAsync throw exceptions.