How access the SQL server data directly from a silverlight web part?

Question

Hi,

What is the best practice for accessing the SQL server data directly from a silverlight web part in sharepoint 2010. Can you please provide the links for the sample implementations if any?

Thank you.

---

Facimus

Answer 1

What SQL server data are you trying to access directly? LOB system data? If you are trying to access SharePoint data then you should use the object model or look into creating a BDC model using Business Connectivity Services.

Answer 2

Hi,

I am talkin about querying and getting SQL server data directly in a silverlight web part. I dont want to access sharepoint data or use BCS services for LOB data.

thank you

 

---

Facimus

Answer 3

System.Data.SQLClient is not part of the SilverLight Runtime. You will have to create and call a service (or similar) to get the data from the SQL Server.

If you would like to access data from the content database you could use the Client OM.

 

 

Answer 4

Build a WCF WebService on the server that allows you to get what you want using System.Data.SQLClient.  E.g. you can create a service that takes a query and returns an XML node array of the results.

In the method, filter out any query commands you want to block, implement an authentication system, etc whatever you want to do to make it secure.  Then you can consume that WCF Service in the silverlight APP using .Net Framework,

You might even want to develop specific methods that are designed to do something more specific.

E.g., instead of building a webservice that lets you query the whole DB, Create methods to query specific tables.

 

E.g.

MyCompany.WCFClient client = new MyCompany.WCFClient;

int[] productIDs = client.Tables.Product.GetProductIDs(); //REturns an array of integers where each integer is the ID of a product in the product table.

foreach (int productID in productIDs)

{

    //client.Tables.Product.GetProductInfo(productID);

}

Then consume your services in SilverLight.

A quick google results in a video on consuming WCF Services in silverlight.

http://www.silverlight.net/learn/videos/all/how-to-consume-wcf-and-aspnet-web-services-in-silverlight/

---

My Blog: http://www.thesug.org/Blogs/ryan_mann1/default.aspx Website: Under Construction