Hi,

I have to retrieve the predicate form entityRelation.

I mean if I have an EntityRelation joining table T1 to T2 on T1.a = T2.b, How can I get this map (T1.a = T2.b) from it later?

There are some methods in IEntityRelation which return PK fields or FK fields, but I couldn't find which PK field has been mapped to which FK field.

could u please help me? Thanx Nazanin

I think you should use their order. i.e. first FK is mapped to first PK..... etc.

Walaa is right, the order is identical, so PK field at index x is related to FK field at index x.

Walaa wrote:

I think you should use their order. i.e. first FK is mapped to first PK..... etc.

But it's not a good method!!!

Any way! thanx alot!

Nazanin wrote:

Walaa wrote:

I think you should use their order. i.e. first FK is mapped to first PK..... etc.

But it's not a good method!!!

Any way! thanx alot!

Not a good method? the fields are stored in sets, so the index is crucial. Sure, we could have stored them in 'pairs', but this was easier

But, what about Predicate? For example, how can I know what ComparisonOperator had been used? You know, we can have T1 join T2 on T1.x > T2.x or T1 join T2 on T1.X != T2.x

I mean, with having just a pair, how can I know what the relation really was???

It's confusing!!

AFAIK, in database relations only equals are used: FK = PK.

Walaa wrote:

AFAIK, in database relations only equals are used: FK = PK.

So we cannot have any other comparison (like in theory) in entityRelation.

Thanx alot