Using a Silverlight WCF-Service in SharePoint

Question

Hi,

I have a Silverlight Application, which accesses a sql database using a WCF-Service. It is working fine, when I debugg it in Visual Studio (in Browser)

Now I have implemented this App in a SharePoint. The App itself is loading fine, but the access to the database is not working.
What is the problem there? Does SharePoint deny the access?

I would be grateful for any help

Answer 1

Please try the following threads.

http://social.msdn.microsoft.com/Forums/en/wcf/thread/165acac5-8150-4017-a4dd-8a78ecd36b46

http://social.technet.microsoft.com/Forums/da/sharepoint2010programming/thread/5b0a0536-9332-4b92-863f-b4466ce873cc

Also refer the sample provided in the below link.

http://code.msdn.microsoft.com/sharepoint/SharePoint-2010-Calling-f017b47f

http://mstecharchitect.blogspot.in/2010/03/calling-wcf-service-hosted-in.html

Thanks.

Answer 2

How are you accessing the database from WCF service ?

I don't know anything about your code of WCF service. I'd recommed you to instrument/trace WCF service.

http://www.codeproject.com/Articles/65425/4-Steps-to-Enable-Instrumentation-in-WCF

http://msdn.microsoft.com/en-us/library/ms733025.aspx

---

Sundar Narasiman

Answer 3

Thanks for you answers.

I resolved the issue by adding a clienaccesspolicy.xml to the service.

Answer 4

Unfortunately it is just working for me on my local machine.

But when other people are using the Silverlight-App on the Sharepoint it is not working, because WCF Service ist located on http://localhost according to Visual Studio.

What shall I do to make it work for everybody

Thanks

Answer 5

Please follow the below blogs.

http://mstecharchitect.blogspot.in/2010/03/hosting-wcf-service-inside-sharepoint.html

http://mstecharchitect.blogspot.in/2010/03/calling-wcf-service-hosted-in.html

Thanks.

Answer 6

Unfortunately it is just working for me on my local machine.

But when other people are using the Silverlight-App on the Sharepoint it is not working, because WCF Service ist located on http://localhost according to Visual Studio.

What shall I do to make it work for everybody

Thanks

Hi,

For the URL, replace the 'localhost' with the computer name where the service sits.

Regards

---

I find it distasteful to beg for 'Mark as Answer' and 'Mark as helpful'. It's supposed to be about helping people, not about getting the high score.

Answer 7

Hi, 

For the URL, replace the 'localhost' with the computer name where the service sits.

Regards

What do you mean with "where the service sits"? The service is integrated in the SilverilghtApp..

Answer 8

Hi,

The service needs to be deployed to a server, the silverlight app (xap file) is deployed to sharepoint. So deploy your service to a test service, update the url to point to the deployed service. This will allow other users to connect to your service using the silverlight app.

Regards

---

I find it distasteful to beg for 'Mark as Answer' and 'Mark as helpful'. It's supposed to be about helping people, not about getting the high score.

Answer 9

The service needs to be deployed to a server, the silverlight app (xap file) is deployed to sharepoint. So deploy your service to a test service, update the url to point to the deployed service. This will allow other users to connect to your service using the silverlight app.

Hi, thanks for your quick response.

I am sorry when I ask again and again, but I am really new in all of this, so I don't get everything  ;)

What exactly do you mean by deploying my service to a test service?

Thanks in advance

Answer 10

In essence what you do is create a 'web site' on the server in IIS manager, then in visual studio you publish the service to a folder on your local machine using file copy, then copy those files to the web site's folder on the server. You can then access that service, for example by using the URL: http://yourserver:portnumber/MyWCFService.svc

Here's a link to msdn where they explain in more details: http://msdn.microsoft.com/en-us/library/aa751792.aspx

---

I find it distasteful to beg for 'Mark as Answer' and 'Mark as helpful'. It's supposed to be about helping people, not about getting the high score.

Answer 11

This would be the first time I work with IIS Manager^^

On what Server shall I create a "web site"? I do not have a Server.... 

I'm a bit confused here^^

Answer 12

Hi,

You can setup your own pc to run as a 'server' by setting up IIS on your pc. Here's a link to set up IIS on windows 7. 

http://www.howtogeek.com/?post_type=post&p=187

This is so that other people can access the service if they run silverlight. One question, where is your sharepoint setup? 

Regards

---

I find it distasteful to beg for 'Mark as Answer' and 'Mark as helpful'. It's supposed to be about helping people, not about getting the high score.

Answer 13

One question, where is your sharepoint setup? 

It is an company sharePoint, so I guess it is setup somewhere in the company intranet..

Answer 14

Is there a development server? Deploy the web service there, otherwise, deploy to your local computer where you're doing the development.

---

I find it distasteful to beg for 'Mark as Answer' and 'Mark as helpful'. It's supposed to be about helping people, not about getting the high score.

Answer 15

Unfortunately it is not allowed to deploy a web service on the sharepoint due to our firm policy.

Answer 16

If you are not allowed to deploy a web service then this silverlight/wcf service combination will not work for you.  In order for this to work the wcf service needs to sit on a server somewhere, if not a sharepoint server, perhaps there's a different server.

Otherwise you'll have to look at dropping silverlight, and rather use a normal sharepoint web part, which can communicate to a database directly.

Regards

---

I find it distasteful to beg for 'Mark as Answer' and 'Mark as helpful'. It's supposed to be about helping people, not about getting the high score.

Answer 17

There is no chance to use a wcf-service which is not deployed on a server?

Answer 18

There is no chance to use a wcf-service which is not deployed on a server?

Think about it, the service needs to sit somewhere... It needs to be on a server, otherwise how will you access it!

---

I find it distasteful to beg for 'Mark as Answer' and 'Mark as helpful'. It's supposed to be about helping people, not about getting the high score.

Answer 19

Okay, new status^^: it is now possible to implement a WCF-Service in the SharePoint.

But how can I do this?^^ I read some tutorials in the internet. Everytime it says to create a new SharePoint project in Visual Studio. Unfortunatelly I don't have a SharePoint Server installed on my pc, so I can't do that.
Is there another way to implement the WCF-Servie on the SharePoint and then access this Service with the SilverlightApp ?

Thanks

Answer 20

Hey,

You can create a normal WCF service and deploy it as a sub site in the SharePoint server under IIS.

PS has this been resolved?

Regards

---

I find it distasteful to beg for 'Mark as Answer' and 'Mark as helpful'. It's supposed to be about helping people, not about getting the high score.