How do I connect Windows Phone to an SQL Server?

Asked

Viewed 1,056 times

2

I’d like to know how to access and receive data from a server from Windows Phone. Put simply: I have a PC and want to access a document directly from the smartphone.

5 answers

2

2

Mobile applications cannot communicate directly with relational databases. For any data/persistence integration into an external source. A web backend is required that allows interaction via API.

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

2

If the requirement is to connect to SQL Server with nothing else, it is always possible create a SOAP endpoint.

  • Even if this link is a good suggestion, this answer will not be valid if one day the link fails. Also, it’s important for the community to have content right here. It would be better to include more details in your reply; Could you do that? A summary of the content of the link would help a lot! Learn more about this subject in our Community FAQ: Answers that only contain links are good?

  • @Felipeavelar, is a link to the official SQL Server documentation. If the link fails to work, it is because the functionality ceased to exist long ago.

  • But if someone uses an outdated version, they may need it documented...

  • @Lucky, now I don’t understand.

  • Like, if someone ever uses a discontinued version (and doesn’t have that link anymore), but still needs the information...

  • 1

    I’m sorry, @Filipeavelar, but I still don’t understand your complaint. This isn’t the forum for reporting SQL Server documentation failures.

  • I agree. Answers with little more than a link can be good answers: and this is one of them. Paulo chose to use a SOAP endpoint. Explain as use it does not fit in a single answer'. Now it is up to the OP to research more information - and there will be' better place than the official documentation?

Show 2 more comments

1

An observation on the other comments:

Windows Phone does not allow connecting to a database remote!

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

How to use Sqlite on Windows Phone: http://developer.nokia.com/community/wiki/How_to_use_SQLite_in_Windows_Phone

1

In this case, the Windows Phone app can make an HTTP call to a Web API. On the server, you can make a project Web API. Microsoft has many features about Web API, how it works, and how to make one. An excellent source is their own website (in English), http://www.asp.net/web-api

Browser other questions tagged

You are not signed in. Login or sign up in order to post.