LLBLGen Pro 3.5 Final - SelfServicing.
It does make sense. I would like to stick to using Entities and EntityCollections if at all possible. I did take a look at QueryFactory and I thought that logically this should have worked,
var qf = new QueryFactory();
var q = qf.Create()
.Select(Table2Fields.IdTable2)
.From(qf.Table1
.LeftJoin(Table1lEntity.Relations.Table2EntityUsingIdTable1)
.LeftJoin(Table2Entity.Relations.Table3EntityUsingIdTable3))
.Where(Table1Fields.IdTable1 == 1);
However the from clause doesn't seem right. I don't see any indication that it's using the desired source table.
Used q.ToString to get this:
...
FROM
RelationCollection:
EntityRelation:
Table1Entity.(IdTable1) 1:n Table2Entity.(IdTable1)
EntityRelation:
Table2Entity.(IdTable3) m:1 Table3Entity.(IdTable3)
...