I have an entity A.

The relation is A 1 to many with B B many to 1 with C

basically, A and C have many to many relation.

Now i get A and then i ant to get a value in C .

so what are the best ways. when i do, EntityA a = new EntityA();

i get collection for a ad then a.b is another collection.

i cannot filter b just with PK, it is popping up many things. so i need to again access full B

EntityB b = new EntityB();

then filter , but it is very performance hitting when i dont want complete b .

I know i may be doing a big blunder as i am a newbie, please suggest if i can access data in any otheer way when many to many relations come.

Thanks a lot for your help

HI Santhosh,

I suppose you are using Adapter templateSet.

Please read the manual's section Using m:n relations.

If you are still stuck, please come back here so we can help you further.