This project template aims to help you quickly get started with OData service development. It is based on WCF Data Services to create OData services.

It supports Json out of the box and has a SQL CE based data source to demonstrate the use of different query syntaxes in OData.

This project template gets installed under Visual C# section in Create New Project wizard. Alternatively you can just search for "odata"in the search bar of Create New Project wizard to get to it quickly. Look for "SampleODataApplication".

When you create a new project based on this template, you can just F5 and get it going. Following are some of the URLs you can try in the browser:

Get all employees in Atom format

http://localhost:9090/Employees

Get all employees in JSON format

http://localhost:9090/Employees?$format=json

Get employee with Id 2 in JSON format

http://localhost:9090/Employees(2)?$format=json

Get count of employees

http://localhost:9090/Employees/$count

Get FirstName of the employee with Id "1".

http://localhost:9090/Employees(1)/FirstName/$value

Get employees with less than 2 years of age in JSON format

http://localhost:9090/Employees?$filter=Age lt 25&$format=json

Get project details of employee with id "1"

http://localhost:9090/Employees(1)/Project?$format=json

Get employee and his project details

http://localhost:9090/Employees(1)?$format=json&$expand=Project

Get project name of employee with id "1"

http://localhost:9090/Employees(1)/Project/Name/$value

Above URLs cover a variety of different types of queries that are possible with OData. The above list of queries are not exhaustive but still can be a good starting point.