OData QueryFeed workflow activity

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

Recommended Download

Source Code Microsoft.Samples.SqlServer.OData.zip
source code, 2957K, uploaded Oct 4, 2012 - 13705 downloads

Other Available Downloads

Documentation Introduction to QueryFeed Activity.docx
documentation, 1276K, uploaded Sep 13, 2012 - 3461 downloads
Documentation AdventureWorks OData-Named Resource Streams.docx
documentation, 860K, uploaded Oct 4, 2012 - 2694 downloads

Release Notes

New
Added the ability to select Named Resource Streams (product images) within a business workflow to the QueryFeed activity, and render a stream in a Word document.

The AdventureWorks QueryFeed OData sample illustrates an end to end OData workflow with Office scenario. Starting with SQL Server views, the sample shows how to expose selective AdventureWorks views as an OData service. The AdventureWorks product catalog contains two product images: LargePhoto and ThumbNailPhoto. By implementing WCF Data Services 5.0 Named Resource Streams, the sample shows how to stream LargePhoto and ThumbNailPhoto into a Word document. You can select named resources in the QueryFeed workflow activity and select the default named resource that the client host will render in the TablePartPublisher workflow activity.

The OData QueryFeed sample activity shows how to create a workflow activity that consumes an OData resource, and renders entity properties in a Microsoft Excel 2010 worksheet or Microsoft Word 2010 document. Using the sample QueryFeed activity, you can consume any OData resource. The sample activity uses LINQ to project OData metadata into activity designer expression items. By setting activity expressions, a fully qualified OData query string is constructed consisting of Resource, Filter, OrderBy, and Select parameters. Executing the activity returns OData entity properties.

Requirements
  1. Visual Studio .NET 2010 SP1
  2. .NET Framework 4.0
  3. WCF Data Services 5.0 for OData V3 located at http://www.microsoft.com/en-us/download/details.aspx?id=29306
  4. Open XML SDK located at http://www.microsoft.com/en-us/download/details.aspx?id=5124
  5. Microsoft Excel 2010 or above
  6. Microsoft Word 2010 or above (optional)

How to install the sample
  1. Install WCF Data Services 5.0 for OData V3 (WcfDataServices.exe ) located at http://www.microsoft.com/en-us/download/details.aspx?id=29306.
  2. Install OpenXMLSDKv2.msi located at http://www.microsoft.com/en-us/download/details.aspx?id=5124.
  3. Open \Microsoft.Samples.SqlServer.OData\Microsoft.Samples.SqlServer.Workflows.OData.sln in Visual Studio 2012.
  4. Build the solution.
  5. For this iteration of the sample, you will need to install the activity designer assembly into the GAC.

How to install the activity designer assemblies into the GAC

From the Visual Studio Command Prompt, enter:
gacutil /i {FullPath}\Microsoft.Samples.SqlServer.Activities.dll

For Example:
gacutil /i C:\Projects\Microsoft.Samples.SqlServer.OData\Common\Activities\bin\Debug\Microsoft.Samples.SqlServer.Activities.dll

How to remove Microsoft.Samples.SqlServer.Activities from the GAC

From the Visual Studio Command Prompt, enter:
gacutil /u Microsoft.Samples.SqlServer.Activities

Note
A future release should resolve the need to install Microsoft.Samples.SqlServer.Activities.dll into the GAC.

Reviews for this release

No reviews yet for this release.