Wikis - Page Details

First published by ruimachado (cMicrosoft Partne)
When: 27 Aug 2012 4:53 AM
Last revision by Ed Price - MSFT (aMicrosof)
When: 14 Jul 2013 10:39 PM
Revisions: 7
Comments: 5

Options

Can You Improve This Article?

Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.

Consuming OData Based Rest Service in C#

Nowadays comunication between applications is an active topic with daily usage and a large amount of pratical appliances. While developing an app in witch I had to consume an OData I found out that combining Linq with my code made this operation pretty easy.

The algorithm to consume OData starts with adding a service reference to Visual Studio:

After adding the service reference in which you define the uri to the service, we start building our code.

In your code the algorithm is the following:

Define the Uri to your OData Service
Define the context of your odata, which contains all entities exposed by the service.
Query the context using Linq
Print the result

Easy and simple.

Example code

 
public static void Main(string[] args){

        Uri serviceUri= new Uri("http://example.host.odataservice.net/service.svc", UriKind.Absolute);

        ODataService.ServiceEntities context = new ODataService.ServiceEntities (serviceUri);

        context.Credentials = new System.Net.NetworkCredential(Username,Password);

         var query = from ServiceObject in context.YourEntity

                     select ServiceObject ;

        foreach (var myObject in query)

        {

            Console.WriteLine("\n Field1: {0} | Field2: {1}",

            myObject .Field1, myObject .Field2);

        }

}