Accessing A MySQL Database In Silverlight (C#)

Question

I am trying to access a MySQL database in a Silverlight application. I have tried to reference to System.Data.Services to access the SQLClient class, but it says:

You can't add a reference to System.Data.Services.dll as it was not built against the Silverlight runtime. Silverlight projects will only work with Silverlight assemblies.

I have also tried to add a reference to MySQL.Data, but received the same error.

I have read online that I will need to use a WebService, but I do not know how to make one.

I am using Visual Studio Ultimate 2010, I am targeting PHP and MySQL servers, not ASP, and would appreciate any help.

Adi · Accepted Answer · 2011-03-25 23:08:48Z

3

Alem, Silverlight is a client-side technology.

It will only work in browsers. You cannot just make direct call to a database from your Silverlight app.

First off, this would be a major security issue you don't want to deal so fortunately you are not even allowed to.

Use webservices, or even better: WCF services. Try this link: http://chakkaradeep.wordpress.com/2008/05/31/silverlight-and-wcf/

Hope this helps.

answered Mar 25, 2011 at 23:08

Adi

5,2416 gold badges48 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Saad · Accepted Answer · 2011-03-25 23:11:20Z

0

you can access sql through php: http://www.silverlightshow.net/news/PHP-MySQL-and-Silverlight-The-Complete-Tutorial.aspx

answered Mar 25, 2011 at 23:11

Saad

29k16 gold badges51 silver badges71 bronze badges

1 Comment

Saad Over a year ago

@Alem yay! (plz select the ans as correct then - check next the message)

Collectives™ on Stack Overflow

Accessing A MySQL Database In Silverlight (C#)

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related