Hi Friends,
I want to use my sql database within my silverlight application. Now my question is that, is the LINQ to SQL only way to working with sql in silverlight or I can use something else.....?
Thank You....
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Priya LingePosted Sep 7, 2011, 3:39 AM
You can use Linq to sql as well as sql server in silverlight application, which is used at service side.
Using service we can access data in silverlight aplication.
Silverlight application doesnot support the AD.net object like DataTable, DataSet, DataColumn.
Hope this will help you.
Thanks.
Prabhu RajaPosted Sep 7, 2011, 12:26 AM
We cannot use the LINQ to SQL class in the Silverlight directly, and Silverlight cannot use the ADO.Net as well. In my opinion, if you want to connect database in Silverlight, you should create a Web service, and then call the web service in Silverlight, the .Net web service can use LINQ to SQL and ADO.Net.
For your information:
http://www.silverlight.net/QuickStarts/Remote/UsingJSON.aspx
http://www.w3schools.com/ngws/ngws_webservices.asp
http://msdn2.microsoft.com/en-us/library/aa446547.aspx
http://aspnet.4guysfromrolla.com/articles/062602-1.aspx
----------------------------------------------------------------------
If this helps You then mark it as "Correct Answer"