Click here to Skip to main content
15,896,912 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi everyone,

i need to add system.data.sqlclient in silverlight
but i can't find so. how i can add this.

thanks for any help
Posted
Updated 28-Sep-11 10:53am
v2

You do not want to expose your database objects on the internet, therefore the system.data.sqlclient is not supported on silverlight by design. Use web services to interact with the database if you have to...
 
Share this answer
 
Comments
Mostafa Elsadany 28-Sep-11 17:25pm    
thanks
for help
hi,
system.data.sqlclient is not supported on silverlight by design,
if you want any DB related things use Webservices,WCF etc..
 
Share this answer
 
Comments
Mostafa Elsadany 13-Oct-11 5:50am    
thanks for help
Silverlight is meant to run on client's browser (if its an in-browser app), which mostly deals with the rendering of the GUI. the System.Data namespace is meant to run on the server and hence is not allowed to be added to Silverlight projects. As others have suggested, WCF RIA services are the best ways to communicate with the data using Silverlight. They act as a middle-tier for your GUI and the backend data/business layers. Consider reading this: http://www.silverlight.net/learn/advanced-techniques/wcf-ria-services/get-started-with-wcf-ria-services[^].

Cheers
 
Share this answer
 
Comments
Mostafa Elsadany 13-Oct-11 5:50am    
thanks for help
but i can't insert to database from ria service i can update and get all data from database so there any way to insert and delete from ria
thanks for help bro
I.explore.code 15-Oct-11 19:04pm    
I think the link that I have provided will also answer this question of yours. Oh and I m sorry for the late response.

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900