How to call SQL Stored Procedures in SilverLight Application

Last Reply on Aug 29, 2012 11:42 PM By Mudassar

Posted on Aug 28, 2012 05:25 AM

Can any one give me a code to perform the operation in the database using silverlight.

Thanks.

 

Posted on Aug 28, 2012 05:25 AM

Refer

http://www.codeproject.com/Articles/345910/Performing-Select-Insert-Update-and-Delete-with-ea


Posted on Aug 29, 2012 11:42 PM

OK. After research I found that in Silverlight you need to use Enitity Model only without that not possible.

If you need to use ADO.Net, create a WCF service with a method to call Stored Procedure.

Then you can call that WCF service with ADO.Net

http://www.codeproject.com/Articles/37393/4-Simple-Steps-to-Consume-WCF-Service-using-Silver

http://www.codeproject.com/Articles/262164/Using-WCF-Service-with-Silverlight