Consider adding Azure Private Dns Zone resolver functionality for http and non-http Service Discovery

Problem:

To use private azure resources in Aspire [from outside of Azure,i.e. on-prem], it's necessary to use a VPN (unavoidable) and additions to your local hosts file (avoidable -- see below.) The latter requires elevation/local admin also.

Solution:

Implement an abstraction that can resolve non-http and http resources using the following SDK within Aspire:

https://learn.microsoft.com/en-us/dotnet/api/overview/azure/resourcemanager.dnsresolver-readme?view=azure-dotnet