AdventureWorks OData Feed

Rating: No reviews yet
Downloads: 6932
Released: Sep 5, 2012
Updated: Oct 4, 2012 by DerrickVMSFT
Dev status: Stable Help Icon

Recommended Download

Application AdventureWorks OData
application, 6961K, uploaded Oct 4, 2012 - 6932 downloads

Release Notes

October 3, 2012
The AdventureWorks OData sample now shows how to implement Named Resource Streams to stream AdventureWorks product images.

September 19, 2012
  1. Changed the ProductCatalog key to ProductID.
  2. Removed the Documents resource since we will use ProductCatalog ThumbNailPhoto and LargePhoto to show multiple streams using Named Resource Streams.
The AdventureWorks OData service exposes resources based on specific SQL views. The SQL views are a limited subset of the AdventureWorks database that results in several consuming scenarios:
  • CompanySales
  • ManufacturingInstructions
  • ProductCatalog
  • TerritorySalesDrilldown
  • WorkOrderRouting
How to install the sample
You can consume the AdventureWorks OData feed from

You can also consume the AdventureWorks OData feed by running the sample service from a local ASP.NET Development Server.

To run the service on a local ASP.NET Development Server
  1. Install WCF Data Services 5.0 for OData V3 (WcfDataServices.exe ) located at
  2. Download the sample.
  3. Attach the AdventureWorks2012 database. The AdventureWorks2012 database can be downloaded from
  4. From Microsoft SQL Server Management Studio, run \AdventureWorks.OData.Service\SQL Scripts\Views.sql to create the OData feed SQL views.
  5. Open \AdventureWorks.OData.Service\AdventureWorks.OData.Service.sln in Visual Studio 2012.
  6. In Solution Explorer, select AdventureWorks.svc.
  7. Press F5 to run the service on http://localhost:1234/AdventureWorks.svc/.

Reviews for this release

No reviews yet for this release.