In such case, a WCF service can be developed and hosted on premises. This WCF service will have CRUD operations specifically against the on premises database. Then Service bus relay option can be used for invoking on premises WCF service from Azure hosted web application to access the database. Use of WCF and service bus relay will avoid the option of VPN connectivity using Azure VNETs offerings.
Azure Migration
This section highlights real world migration interview questions for IaaS or PaaS migration from on premises to Azure.
On premises application running few windows services, console applications to handle certain tasks. What should be the approach for migration of such applications to Azure?
There are 3 ways by which we can achieve background process migration to Azure --
Azure Virtual Machine
Worker role
Azure Web Jobs