How to connect Windows-Phone7 application to MySQL?

Question

0.00/5 (No votes)

See more:

, +

Hi, am developing Windows-Phone7 chat-application for my final year project in 'Visual Studio Express 2010 for Windows Phone'. I am asked to develop in MySQL as backend. I gotta know that you cannot connect Windows-Phone application to MySQL. Could anybody tell me the possibilities of connecting with MySQL? Should i use Web Services? And I wanta know which database is apt for windows phone7 to beginners.Could anybody expalin me please?

Posted 12-Jan-12 2:44am

prakash bala mca

Updated 12-Jan-12 2:49am

v3

Add a Solution

2 solutions

Solution 1

You should go for web services and the database I suggest is MS SQL Server.

If you are still keen on using MySQL , then you can use this REST client for communication between MySQL and WP7 app.http://restsharp.org/[^]

Posted 12-Jan-12 2:52am

bbirajdar

Updated 12-Jan-12 2:54am

v3

Comments

prakash bala mca 12-Jan-12 9:25am

Could you elloborately tell me pleas whats the difficulty in connecting WP7 with MYSQL? so that i can argue my guide to change my database to MSSQL server.Tnx for ur time.

bbirajdar 12-Jan-12 9:57am

Frankly speaking, I have not tried making WP7 work with MySQL. I just don't like the idea of a zebra marrying a giraffe. When you have all the development tools from one vendor, why should we go for mixing them. The problem that may arise from this cross pollination cannot be told in advance.It depends on the application. When you have a powerful MS SQL server, with WP7 SDK having capabilities to seamlessly communicate with, I suggest MS SQL. Some people faced problems with this http://p2p.wrox.com/classic-asp-databases/1223-mysql-ole-db-connection-string.html

prakash bala mca 12-Jan-12 11:35am

thank u :)

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abdullatif M. Abu Al Rub · Accepted Answer · 2012-01-12T03:16:00

Solution 2

You should use LINQ to connect databases to WP7...

download the following book it explains everything about databases with WP7:

https://www.facultyresourcecenter.com/curriculum/pfv.aspx?ID=8874&c1=en-us&c2=0&Login=[^]

don't forget to vote :D

Posted 12-Jan-12 3:16am

Abdullatif M. Abu Al Rub