Building a OData Service
Open Data Protocol is popularly known as OData. The definition from the OData.Org is as mentioned below “ Open Data Protocol (OData) is a Web protocol for querying and updating data that provides a way to unlock your data and free it from silos that exist in applications today. OData does this by applying and building upon Web technologies such as HTTP , Atom Publishing Protocol (AtomPub) and JSON to provide access to information from a variety of applications, services, and stores.” We will see how to build a simple OData Service which can be consumed my applications. To build OData Service, we need to ensure that the WCF Data Service is installed. If not, install the software as mentioned here http://msdn.microsoft.com/en-us/data/ee712906 . In this article we will use the “Product” and “Category” table in the NorthWind Database. In case you don’t have the NorthWind database, you can download the same from http://www.microsoft.com/download/en/details.aspx?id=2365