Hi , I have a question please

I have 2 tables and one intermediate table . the tables are as follows

1. TestCaseSuite
2. TestConfiguration
3. TestSuiteConfiguration

Tables 1 and 2 are master tables and table 3 is the intermediate table.

I would like to get all the values (TestSuiteCOnfiguration) related to a Particular TestCaseSuiteId.

Could you please let me know how to do that .. I know i will have to use relations.. but I cant figure my way out..

Please see the attached image for more information ...

Thanks and Regards Gagan

(removed picture, not a valid jpg -- Otis)

You don't really need relations. You use relations when you want to filter/sort on related entities. In this case you want to fetch TestSuiteConfiguration filtered by it TestCaseSuiteId and attach its related objects, so you just need to use PrefetchPaths.

Give it a try a come back here if you need further help.