Using MySQL database on Windows Phone 7?

Question

I am trying to write a Windows Phone 7 application that needs to connect to a remote data source, in this case it is a MySQL database on a Linux server. I cannot move this to MSSQL and not build any Windows-based solution (for example, WCF web service on the server).

Is there a way to use my MySQL database from my Windows Phone 7 application? MySQL builds don't seem to work on the phone. If not, then what is the best way to use this database from your phone?

Answer 1

You can create yourself a service that will send you json or xml. it can be easily created using mono, python, Ruby, php or any other technology that is convenient for you.

You can build it in a relaxed manner where all you have to do is call the URLs in an HTTP GET to get the data that you process using services.

and use HTTP POST to post changes to your service.

you can make calls from this service from WP7 and consume data.

WP7 does not support sockets at the moment. Thus, your best bet is to transfer your payload through HTTP.

As I mentioned earlier, if you have access to the configuration of computers. You can run Mono, which is not too far from .Net in terms of language and functionality.

Next, from your phone, you can use the Rx library to make these Async calls and respond to your application.