How to connect Windows Phone to a SQL Server?

Question

How to connect Windows Phone to a SQL Server?

Navigation

#1 by (2 votes)
#2 by (2 votes)
#3 by (2 votes)
#4 by (1 votes)
#5 by (1 votes)

2

I would like to know how to access and receive data from a server from Windows Phone. Simply put: I have a PC and I want to access a document directly from my smartphone.

c# windows-phone

asked by anonymous 25.02.2014 / 15:56

5 answers

Dropdown animated with jQuery Change scrollbar placement in a div

score 2 · Answer 1

Windows Phone was not specifically designed to connect to an instance of SQL Server because Microsoft does not allow it. The correct thing would be to connect to a website that has a Web API implemented in it.

In any case, you have a version of Google Drive for Windows Phone for document access:

link

score 2 · Answer 2

Mobile applications can not communicate directly with relational databases. For any data integration / persistence in an external source. A web backend is required to allow interaction via the API.

There are some cloud storage services that provide free usage levels, such as Parse and Firebase .

score 2 · Answer 3

2

If the requirement is to connect to SQL Server without anything else, you can always create a SOAP endpoint .

26.02.2014 / 12:20

score 1 · Answer 4

In this case, the Windows Phone application can make an HTTP call to a Web API. On the server, you can do a Web API project. Microsoft has many features about Web API, how it works, and how to make one. An excellent source is their own website, link

score 1 · Answer 5

An observation regarding the other comments:

Windows Phone does not allow connection to a remote database!

However, it is perfectly possible to connect to a local database (eg SQLite). In fact, this is the predominant method in both Windows Phone and other mobile platforms (Android, iOS, WinRT).

How to use SQLite in Windows Phone: link