$expand not working. Associate/Child records not returned in result

[piyushparate1]

Hi I am facing some issue in $expand odata api.

https://stackoverflow.com/questions/50265218/expand-not-working-associate-child-records-not-returned-in-result

Could you please help.

Thanks.

[biaol-odata]

Hi @piyushparate1: $expand is a widely used system query, therefore likely the issue is due to client code.

From GetModel() and the csdl model generated, Customer entity type have navigation property "ShoppingCart", neither "Product" nor "Products". That is why the first two query doesn't expand the product. As for the third query, "/Customers?$expand=ShoppingCart": from you Get() method,

1. This duplicated line appears to be incorrect: p1.TrySetPropertyValue("cId", 22);
2. The "ShoppingCart" navigation property has ContainsTarget = true, and the corresponding datasource is populated by new object[] { p1, p2 } --- doing this way might cause type information lost.

I would suggest debugging this a little bit to make sure the data source is populate correctly; using ContainsTarget = false for shoppingCartNavigation. For further details, you can checkout this tutorial http://odata.github.io/odata.net/#02-03-define-entity-relations, which contains some samples.

[piyushparate1]

Thank you so much @biaol-odata, for your response. I am new in this, didnt knew that - only navigation property can use in url. #1 - After spending 4days on the same code snippet, I kind of missed that duplicate lines. I fixed that code. #2 - Updated the ContainsTarget property, as well as the way i am assigning child record.

Still it doesnt returning the child record. Do we need to add one more controller to handled child records?

My code is in https://github.com/piyushparate1/SampleODataUntyped