What solution would you use to connect an on-premises database with an Azure-hosted app?

To connect an on-premises database with an Azure-hosted application, utilizing Hybrid Connection is the optimal choice. Hybrid Connection allows applications hosted in Azure, such as those running on Azure App Service, to securely access resources that reside on-premises, including databases and other services.

This solution is particularly beneficial because it establishes a secure connection between your Azure application and on-premises resources without requiring a full VPN setup. It operates over the HTTPS protocol, which simplifies firewall configurations and enables communication in scenarios where a traditional VPN may not be necessary.

Hybrid Connection provides a way to achieve connectivity with minimal overhead, reducing the complexity of integrating cloud applications with local servers for accessing databases or web services directly. This makes it easier for developers and administrators to manage and maintain the connection, ensuring that the application performs efficiently while securely accessing necessary on-premises data.

In contrast, other options like Hybrid Network or VPN Gateway can involve more extensive configurations and may not specifically suit the requirement of a simple, secure connection for Azure-hosted applications interacting with local databases. Point-to-Site VPN, while it establishes point-to-point connections, is typically meant for scenarios where individual users need access rather than integrating application services directly with an on-premises database.