Click here to Skip to main content
13,863,682 members
Click here to Skip to main content
Add your own
alternative version


117 bookmarked
Posted 21 Jun 2009
Licenced CPOL

7 Simple Steps to Connect SQL Server using WCF from SilverLight

, 12 Aug 2010
Rate this:
Please Sign up or sign in to vote.
In this article, we will look at how we can do database operations using SilverLight.

Update: Silverlight FAQs - Part 3 link and video added to this article.

7 Simple Steps to Connect SQL Server using WCF from SilverLight


Video demonstration One Way, Two Way and One Time Bindings using Silver light


Introduction and Goal

In this article, we will look at how we can do database operations using Silverlight. We will first try to understand why we cannot call ADO.NET directly from a Silverlight application and then we will browse through 7 steps which we need to follow to do database operation from Silverlight.

I have collected around 400 FAQ questions and answers in WCF, WPF, WWF, SharePoint, design patterns, UML, etc. Feel free to download these FAQ PDFs from my site.

Silverlight does not have ADO.NET

Below are the different ingredients which constitute Silverlight plugin. One of the important points to be noted is that it does not consist of ADO.NET. In other words, you cannot directly call ADO.NET code from a Silverlight application. Now the other point to be noted is that it has the WCF component. In other words, you can call a WCF service.

In other words, you can create a WCF service which does database operations and Silverlight application will make calls to the same. One more important point to be noted is to not return ADO.NET objects like dataset, etc. because Silverlight will not be able to understand the same.

Below are 7 important steps which we need to follow to consume a database WCF service in Silverlight.

Step 1: Create the Service and Data Service Contract

Below is a simple customer table which has 3 fields ‘CustomerId’ which is an identity column, ‘CustomerCode’ which holds the customer code and ‘CustomerName’ which has the name of the customer. We will fire a simple select query using WCF and then display the data on the Silverlight grid.

Field Datatype
CustomerId int
CustomerCode nvarchar(50)
CustomerName nvarchar(50)

As per the customer table specified above, we need to first define the WCF data contract. Below is the customer WCF data contract.

    public class clsCustomer
        private string _strCustomer;
        private string _strCustomerCode;

        public string Customer
            get { return _strCustomer; }
            set { _strCustomer = value; }

        public string CustomerCode
            get { return _strCustomerCode; }
            set { _strCustomerCode = value; }

We also need to define a WCF service contract which will be implemented by WCF concrete classes.

    public interface IServiceCustomer
        clsCustomer getCustomer(int intCustomer);

Step 2: Code the WCF Service

Now that we have defined the data contract and service contract, it’s time to implement the service contract. We have implemented the ‘getCustomer’ function which will return the ‘clsCustomer’ datacontract. ‘getCustomer’ function makes a simple ADO.NET connection and retrieves the customer information using the ‘Select’ SQL query.

public class ServiceCustomer : IServiceCustomer
        public clsCustomer getCustomer(int intCustomer)
            SqlConnection objConnection = new SqlConnection();
            DataSet ObjDataset = new DataSet();
            SqlDataAdapter objAdapater = new SqlDataAdapter();
            SqlCommand objCommand = new SqlCommand
		("Select * from Customer where CustomerId=" + intCustomer.ToString());
            objConnection.ConnectionString = 
            objCommand.Connection = objConnection;
            objAdapater.SelectCommand = objCommand;
            clsCustomer objCustomer = new clsCustomer();
            objCustomer.CustomerCode = ObjDataset.Tables[0].Rows[0][0].ToString();
            objCustomer.Customer = ObjDataset.Tables[0].Rows[0][1].ToString();
            return objCustomer;

Step 3: Copy the CrossDomain.xml and ClientAccessPolicy.XML File

This WCF service is going to be called from an outside domain, so we need to enable the cross domain policy in the WCF service by creating ‘CrossDomain.xml’ and ‘ClientAccessPolicy.xml’. Below are both the code snippets. The first code snippet is for cross domain and the second for client access policy.

<?xml version="1.0"?>
    <!DOCTYPE cross-domain-policy SYSTEM 

      <allow-http-request-headers-from domain="*" headers="*"/>
<?xml version="1.0" encoding="utf-8" ?>
          <allow-from http-request-headers="*">
            <domain uri="*"/>
            <resource include-subpaths="true" path="/"/>

Step 4: Change the WCF Bindings to ‘basicHttpBinding’

Silverlight consumes and generates proxy for only basicHttpBinding, so we need to change the endpoint bindings accordingly.

<endpoint address="" binding="basicHttpBinding" 


Step 5: Add Service Reference

We need to consume the service reference in Silverlight application using ‘Add service reference’ menu. So right click the Silverlight project and select add service reference.

Step 6: Define the Grid for Customer Name and Customer Code

Now on the Silverlight side, we will create a ‘Grid’ which has two columns, one for ‘CustomerCode’ and the other for ‘CustomerName’. We have also specified the bindings using ‘Binding path’ in the text block.

<Grid x:Name="LayoutRoot" Background="White">
                <RowDefinition Height="20"></RowDefinition>
                <RowDefinition Height="20"></RowDefinition>
            <TextBlock x:Name="LblCustomerCode" Grid.Column="0" 

		Grid.Row="0" Text="Customer Code"></TextBlock>
            <TextBlock x:Name="TxtCustomerCode" Grid.Column="1" 

		Grid.Row="0" Text="{Binding Path=CustomerCode}"></TextBlock>
            <TextBlock x:Name="LblCustomerName" Grid.Column="0" 

		Grid.Row="1" Text="Customer Name"></TextBlock>
            <TextBlock x:Name="TxtCustomerName" Grid.Column="1" 

		Grid.Row="1" Text="{Binding Path=Customer}"></TextBlock>

Step 7: Bind the WCF Service with the GRID

Now that our grid is created, it's time to bind the WCF service with the grid. So go to the code behind of the XAML file and create the WCF service object. There are two important points to be noted when we call WCF service using from Silverlight:

  • We need to call the WCF asynchronously, so we have called getCustomerAsynch. Please note this function is created by WCF service to make asynchronous calls to the method / function.
  • Once the function completes its work on the WCF service, it sends back the message to the Silverlight client. So we need to have some kind of delegate method which can facilitate this communication. You can see that we have created a getCustomerCompleted method which captures the arguments and ties the results with the grid datacontext.
public partial class Page : UserControl
    public Page()
        ServiceCustomerClient obj = new ServiceCustomerClient();
        obj.getCustomerCompleted += new EventHandler<getCustomerCompletedEventArgs>
    void DisplayResults(object sender, getCustomerCompletedEventArgs e)
        LayoutRoot.DataContext = e.Result;

You can now run the project and see how the Silverlight client consumes and displays the data.

Other Silverlight FAQs

  • Silverlight FAQ Part 1: This tutorial has 21 basic FAQs which will help you understand WPF, XAML, help you build your first Silverlight application and also explains the overall Silverlight architecture.
  • Silverlight FAQ Part 2 (Animations and Transformations): This tutorial has 10 FAQ questions which starts with Silverlight animation fundamentals and then shows a simple animated rectangle. The article then moves ahead and talks about 4 different ways of transforming the objects.
  • Silverlight FAQ Part 3: This article discusses 12 FAQs which revolve around bindings, layouts, consuming WCF services and how to connect to database through Silverlight.


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


About the Author

You may also be interested in...


Comments and Discussions

GeneralMy vote of 5 Pin
Ashish Jain(Be Jovial)16-Jul-15 10:06
memberAshish Jain(Be Jovial)16-Jul-15 10:06 
QuestionCommunication Exception Pin
Member 94829105-Dec-13 22:36
memberMember 94829105-Dec-13 22:36 
AnswerRe: Communication Exception Pin
Jose Miguel Perez Mendez11-Dec-13 9:24
groupJose Miguel Perez Mendez11-Dec-13 9:24 
QuestionConfigurationManager not there Pin
Member 98820664-Mar-13 4:48
memberMember 98820664-Mar-13 4:48 
Questionproblem with reference Pin
Abbath13496-Dec-12 5:44
memberAbbath13496-Dec-12 5:44 
GeneralMy vote of 5 Pin
YBP_RSA17-Oct-12 20:00
memberYBP_RSA17-Oct-12 20:00 
QuestionCan't find the type SqlConnection Pin
dpolancom28-Jul-12 16:49
memberdpolancom28-Jul-12 16:49 
AnswerRe: Can't find the type SqlConnection Pin
Abhijat Chauhan14-Aug-13 1:52
memberAbhijat Chauhan14-Aug-13 1:52 
QuestionMy vote of 5 Pin
DotNetXenon9-Sep-11 9:32
memberDotNetXenon9-Sep-11 9:32 
GeneralMy vote of 5 Pin
s.faizaan76-Aug-11 1:18
members.faizaan76-Aug-11 1:18 
QuestionRetrieve data from Multiple tables? Pin
priyanka angotra8-Sep-10 4:16
memberpriyanka angotra8-Sep-10 4:16 
Questionwhat am i missing? Pin
Karlian7122-Jul-10 1:59
memberKarlian7122-Jul-10 1:59 
AnswerRe: what am i missing? Pin
Glen Banta20-Aug-10 4:51
memberGlen Banta20-Aug-10 4:51 
AnswerRe: what am i missing? Pin
Abhijat Chauhan14-Aug-13 1:54
memberAbhijat Chauhan14-Aug-13 1:54 
GeneralMy vote of 1 Pin
liviu12109-Jul-10 5:29
memberliviu12109-Jul-10 5:29 
GeneralRe: My vote of 1 Pin
Glen Banta20-Aug-10 4:50
memberGlen Banta20-Aug-10 4:50 
GeneralRe: My vote of 1 Pin
Abhijat Chauhan14-Aug-13 1:56
memberAbhijat Chauhan14-Aug-13 1:56 
GeneralUPdate on launching the WCF.svc file Pin
kazim bhai28-Dec-09 19:45
memberkazim bhai28-Dec-09 19:45 
GeneralThanks Pin
kazim bhai24-Dec-09 15:09
memberkazim bhai24-Dec-09 15:09 
GeneralMy vote of 2 Pin
jszczur8-Oct-09 23:44
memberjszczur8-Oct-09 23:44 
Generalyour article has helped me! Pin
791671153-Jul-09 18:35
member791671153-Jul-09 18:35 
GeneralMy vote of 1 Pin
zlezj22-Jun-09 1:20
memberzlezj22-Jun-09 1:20 
GeneralRe: My vote of 1 PinPopular
Shivprasad koirala22-Jun-09 2:00
memberShivprasad koirala22-Jun-09 2:00 
GeneralRe: My vote of 1 Pin
Himanshu Thawait30-Jun-09 3:37
memberHimanshu Thawait30-Jun-09 3:37 
GeneralRe: My vote of 1 Pin
blackjack21508-Oct-09 23:08
memberblackjack21508-Oct-09 23:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Cookies | Terms of Use | Mobile
Web01 | 2.8.190214.1 | Last Updated 13 Aug 2010
Article Copyright 2009 by Shivprasad koirala
Everything else Copyright © CodeProject, 1999-2019
Layout: fixed | fluid