In
the previous post, you saw how to create an OData
feed and pre-filter
the data. In this post, we will see how to shape
the data. A sample project is attached at
the bottom of this post. Pre-filtering and shaping OData feeds using WCF Data Services and
the Entity Framework - Part 1 Shaping
the feed The Product
feed we created earlier returns too much information about our products. Let’s change this so that only
the following properties are returned – ProductID, ProductName, QuantityPerUnit, UnitPrice, UnitsInStock. We also want to return only Products that are not discontinued. Splitting
the Entity To shape our data according to
the requirements above, we are going to split our Product Entity into two and expose one through
the feed.
The exposed entity will contain only
the properties listed above. We will use
the other Entity in our Query Interceptor to pre-filter
the data so that discontinued products are not returned. Go to
the design surface for
the Entity Model and make a copy of
the Product entity. A “Product1” Entity gets created. Rename Product1 to ProductDetail. Right click on
the Product entity and select “Add Association” Make a one to one association between Product and ProductDetails. Keep only
the properties we wish to expose on
the Product entity and delete all other properties on it (see diagram below). You delete a property on an Entity by right clicking on
the property and selecting “delete”. Keep
the ProductID on
the ProductDetail. Delete any other property on
the ProductDetail entity that is already present in
the Product entity. Your design surface should look like below: Mapping Entity to Database Tables Right click on “ProductDetail” and go to “Table Mapping” Add a mapping to
the “Products” table in
the Mapping Details. After mapping ProductDetail, you should see
the following. Add a referential constraint. Lets add a referential constraint which is similar to a referential integrity constraint in SQL. Double click on
the Association between
the Entities and add
the constraint with “Principal” set to “Product”. Let us review what we did so far. We made a copy of
the Product entity and called it ProductDetail We created a one to one association between these entities Excluding
the ProductID, we made sure properties were not duplicated between these entities We added a ProductDetail entity to Products table mapping (Entity to Database). We added a referential constraint between
the entities. Lets build our project. We get
the following error: ”'NortwindODataFeed.Product' does not contain a definition for 'Discontinued' and no extension method 'Discontinued' accepting a first argument of type 'NortwindODataFeed.Product' could be found …"
The reason for this error is because our Product Entity no longer has a “Discontinued” property. We “moved” it to
the ProductDetail entity since we want our Product Entity to contain only properties that will be exposed by our
feed. Since we have a one to one association between
the entities, we can easily rewrite our Query Interceptor like so: [QueryInterceptor("Products")]
public Expression<Func<Product, bool>> OnReadProducts()
{
return o => o.ProductDetail.Discontinued == false;
}
Similarly, all “hidden” properties of
the Product table are available to us internally (through
the ProductDetail Entity) for any additional logic we wish to implement.
Compile
the project and view
the feed. We see that
the feed returns only
the properties that were part of
the requirement.
To see
the data in JSON format, you have to create a request with
the following request header
Accept: application/json, text/javascript, */* (easy to do in jQuery)
The result should look like this:
{
"d" : {
"results": [
{
"__metadata": {
"uri": "http://localhost.:2576/DataService.svc/Products(1)", "type": "NorthwindModel.Product"
}, "ProductID": 1, "ProductName": "Chai", "QuantityPerUnit": "10 boxes x 20 bags", "UnitPrice": "18.0000", "UnitsInStock": 39
}, {
"__metadata": {
"uri": "http://localhost.:2576/DataService.svc/Products(2)", "type": "NorthwindModel.Product"
}, "ProductID": 2, "ProductName": "Chang", "QuantityPerUnit": "24 - 12 oz bottles", "UnitPrice": "19.0000", "UnitsInStock": 17
}, {
...
...
If anyone has
the $format operation working, please post a comment. It was not working for me at
the time of writing this.
We have successfully pre-filtered our data to expose only products that have not been discontinued and shaped our data so that only certain properties of
the Entity are exposed. Note that there are several other ways you could implement this like creating a QueryView, Stored Procedure or DefiningQuery.
You have seen how easy it is to create an OData
feed, shape
the data and pre-filter it by hardly writing any code of your own.
For more details on OData, Google it with your favorite search engine :-) Also check out
the one of
the most passionate persons I have ever met, Pablo Castro –
the Architect of Aristoria WCF Data Services. Watch his MIX 2010 presentation titled “OData: There's a
Feed for That” here.
Download Sample Project for VS 2010 RTM
NortwindODataFeed.zip
