I am afraid that this is a limitation of our implementation of Data Services.
My suggestion will be to separate the procedure in Scenario 2
into 3 actions:
- Save the new RealEstate instance
- Save the new Hierarchy instance
- Link both object by updating the Hierarchy instance foreign key.
While this approach will work you should consider the fact that there will be 3 distinct transactions rather than single one as you intended.
OpenAccess ORM is now Telerik Data Access
. For more information on the new names, please, check out the Telerik Product Map