Hi support team,

I am using LLBLGen 2.6 and would like to know if there is a way for a simple cross join. I'm having 2 tables with 2 fields each and would like to get these cross joined together (using selfservicing two class scenario), but unfortunately I can't find any help in the documentation.

P.S. The 2 tables have no field in common, so I cannot do it via normal relations.

Thanks in advance for your help!

Sorry - this is not supported. Joins always have to be on a field.

Matt

This is supported, sorry to correct Matt.

Cross-joins are supported by specifying the Joinhint.Cross when adding the relation to the relationcollection. There's an overload which allows you to specify a joinhint. In 2.6, you can create a DynamicRelation object between two entities, and you can leave the predicate (on clause) null, and then add it to the relationcollection to get a cross join.

Thanks guys for the quick response. It is just a little bit weird for me that there is no easier way of doing this. Anyway, thanks for the help and I have to test this ... right now

Levente wrote:

Thanks guys for the quick response. It is just a little bit weird for me that there is no easier way of doing this. Anyway, thanks for the help and I have to test this ... right now

well, if you have a relation generated between two entities, it's easy, just add that one to the relationcollection and specify JoinHint.Cross in the Add overload. As you said there's no relation between the two entities, you have to create a dynamic relation. (or use linq )

Otis wrote:

This is supported, sorry to correct Matt.

Cross-joins are supported by specifying the Joinhint.Cross when adding the relation to the relationcollection. There's an overload which allows you to specify a joinhint. In 2.6, you can create a DynamicRelation object between two entities, and you can leave the predicate (on clause) null, and then add it to the relationcollection to get a cross join.

Worked like a charm! Thanks guys.