I have to join two tables in LLBL but in database there is no relationship exists between these two tables (otherwise I could have simply used RelationCollection). Any idea how can I do this join between these two tables in LLBL?

Just to be clear none of these two fields are primary keys.

Yes, you can create an instance of EntityRelation, and pass the fields and joinHint to the constructor.

In v2.6 we made this easier with the 'DynamicRelation' class, which is in the generated code

ok, so when I add this relation using DynamicRelation, I get following error

Relation at index 2 doesn't contain an entity already added to the FROM clause. Bad alias?

Any idea what I may be doing wrong?

imakimak wrote:

ok, so when I add this relation using DynamicRelation, I get following error

Relation at index 2 doesn't contain an entity already added to the FROM clause. Bad alias?

Any idea what I may be doing wrong?

A code snippet would help out alot

Actually I figured it out. It was my bad with the aliasing thing in the DynamicRelation constructor. Thanks for your help anyways