We have an existing on-premise SQL server database. We are trying to build a ASP.NET core web app and deploy on Azure as App Service. Along with it we will also have a new Azure SQL database singleton.
How can I query our on-premise SQL server database table from Azure SQL database through a stored procedure?
Should we use Azure SQL managed instance instead of Azure SQL database singleton for this?
Thanks In Advance!