DataSet Class in Silverlight

Question

hello guys how r u all ?

my question is that, i am creating login form in silverlight with database connectivity, i am retriveing data from service with Dataset class but in silverlight page.xaml.cs there is no access for DataSet class which is in System.Data Namespace, so please tell me how can i access System.Data Namespace in page.xaml.cs Page in silverlight

please Reply Soon

Thanks.

Manas Patnaik · Answer

Hi Faisal Let me tell you there is no ADO.Net support for silverlight.Reason is simple Silverlight is a plug in based model which seats at client side and works with sandbox restrictions. The silverlight can communicate with server via services only although sockets option is there . Hope you got my point. Thanks

Priya Linge · Answer

Hi In silverlight there is no direct access to dataset objects like dataset etc.. but u can have System.Data.SqlClient and System.Linq You can access data through sql server or linq. We have silverlight Business application which contain the silverlight login form. Hope this will help you. Thanks.

Faisal Ansari · Answer

Thanks mamta for reply but its too confusing :) .... if you can send me any example about login form in silverlight with database connectivity using LINQ ???

Mamta M · Answer

Faisal There is no direct way to do this and the few ways that are there are not recommended as a good practice. Best option would be to go for a third party control which can function similar to a DataSet. For eg Component One (www.componentone.com) has a C1Data object that is similar to the Dataset. Iif you have an un-typed dataset on the WCF Service you can serialize the .NET Dataset using the WriteXML method then send the XML string over the WCF Service. On the Silverlight side you can use the C1Data object and read the XML which will parse it and then de-serialize it. Hope this helps.