CreateAssociation
Creates an association between two entities based on a navigation property. Set the IncludeNavigationProperties connection property to true in order to use this stored procedure.
Input
| Name | Type | Required | Description |
| FromId | String | False | The ID of the entity you are creating an associations for. |
| UrlId | String | False | An alternative to specifying the FromId. This is the complete URL to the resource for which the association is being created. It is required to be specified in the case that the navigation property is an abstract, or to specify more specific child types where the navigation property entity type is used as a basetype. |
| FromTable | String | True | The table where the entity comes from that you are creating an association for. For example, if the FromId was from a table called Customers, set this parameter to: Customers. |
| ToNavigationProperty | String | True | The navigation property you are creating an association on. It can be obtained from ListNavigationProperties. |
| ToId | String | False | The ID of the navigation entity. This will come from the table associated with the navigation property. |
| ToUrlId | String | False | An alternative to specifying the ToId. This is the complete URL to the resource to be associated. It is required to be specified in the case that the navigation property is an abstract, or to specify more specific child types where the navigation property entity type is used as a basetype. |