how to add relation ship in Kentico(one to Many)

Hi MohammadJavad,

When you mention "tables" - what Kentico entities do you mean? It could be custom table, module custom class, form or page type. All work slightly different. But in the documentation you can find the way how to store one-to-many relationships for module custom classes in this article, and many-to-many in this article.

thanks for the Answer

what I mean is the table when we define the page type page type Product (table A) , Page type Feature(table B) I want to link the product to the feature(Table B) using the ProductID

Ok, for page types you can use page relationships (if you need both accessing products from feature and features from product) or pages field data type which is based on relationships under the hood (this will work well if you only need getting features for a product). The only drawback of using relationships for your case is that relationships are not extendable, i.e. you cannot introduce your custom fields into relationship. So that the relationship will store in your case only ProductID and FeatureID.

Other option would be creating your own custom class to store this relation but it will require quite a lot of custom steps to do:

• create module custom class to store relationships with your required custom fields
• create a form control to select related features and products in admin
• write some code to retrieve related features and products

I would recommend my Relationships Extended module as it allows you to create interfaces to do these custom mapping.

https://github.com/KenticoDevTrev/RelationshipsExtended

https://github.com/KenticoDevTrev/RelationshipsExtended/wiki/Relationships-Extended-Overview

With this you can configure a "Related Table B" UI element and point it to your table, set your relationship fields (ProductID to ProductID), etc.

Thank you dear Dmitry. I've done noted steps; At this time I don't know how can I write code to get that child fields. As a matter of fact, like Entity Frame work in .Net (Navigation Property) for example Product.Feature.featureName How can I retrieve their fields in kentico model after noted steps by code?

Dear Trevor, Thanks for your help. How can I use it in my code ? Do you have a sample about it to use RelationshipsExtended ; after I Installed it in my projects? Thanks a lot.

Read the documentation I linked and it provides samples.