How to connect a desktop application and a SQL Server database located in the Azure cloud?

A

AcidBat2015-10-01 19:08:25

C++ / C#

AcidBat, 2015-10-01 19:08:25

There is a site that is deployed on Azure cloud hosting. This site works with a database (say, db.mdf), which is located in the App_Data folder, which in turn lies in the root folder of the site.
And there is (or rather, being developed) a desktop C # application that must somehow connect to the mdf database and be able to perform all the basic actions that are in the SQL language (selection, deletion, update, insert).
Is this possible in principle? If yes, what is the best way to implement it?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

V

Vyacheslav Zolotov, 2015-10-02
@AcidBat

It is possible, but there is a problem: you can only connect to the database if you enter the client's IP address in a special panel. Those. if you have 1-5 users, it will be possible to connect directly, and if more, it is better to make a WCF or REST API service. For example, I have Azure Mobile Services tied to SQL and all work through the Web API