Consuming SQL Azure OData Service using OData Explorer

OData Explorer is free Sample Silverlight Application available in

To run this you should have Silverlight 4.0 Runtime installed

Step 1: Click on the above URL to browse the application online. To Access SQL Azure OData service, You need to install it as Out of Browser application or else you will get the following error while adding the service to workspace


To avoid this, right click and click “Install OData Explorer onto this computer…”


Once installed, you will see the below shortcut in your desktop, double click the short cut to run OData Explorer


Step 2: By default, it will prompt you to add a new OData Service to Workspace


Please provide workspace name and enter the SQL OData Service URI and then click “Ok”

Step 3: Once successfully added, you will see below screen showing the list of Data Collections available through the SQL Azure OData service


Step 4: To browse data you can click on any table and data will be loaded on the right pane


Step 5: To filter the data, you can use “Build Query” option and then select the field name and then specify criteria and filter value and click “Add Query Option” to add the filter



Click “Ok” and then click “Go” on workspace to apply the filter on the data


Step 6: To Edit the record, click on “Edit”


To modify the data, you can change the required values and click “Save Changes” and to delete the entire record use “Delete” option

This is not full fledged data management interface, but it provides quick access to your data with no need to write any code

Happy OData Exploring and Programming !!!


Author: Arunraj

I am a Microsoft Certified Technology Specialist (Database Developer). I work on SQL Server programming since SQL Server 7.0 specializes in SQL Server Programming and Performance Tuning and has 14 years of hands-on experience. I hold a Master Degree in Computer Applications. I am also part of NJSQL User Group and Northern New Jersey .Net User Group.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: