LLBL version 2.6 Final SQL 2005 SP2 VS 2008, .NET 3.5

I am trying to do a pretty basic query using a left join, with some predicate expressions defined on the left-joined table. Here is the SQL equivalent to what I'm trying to do:

SELECT *
FROM TableA
LEFT JOIN TableB
ON TableA.ID = TableB.TableA_ID
AND TableB.FilterColumn = 'value'
WHERE TableA.ID = 1

Here is my code:

            RelationPredicateBucket bucket = new RelationPredicateBucket();
            IPrefetchPath2 prefetch = new PrefetchPath2((int)EntityType.TableAEntity);

            EntityCollection<TableAEntity> aList = new EntityCollection<TableAEntity>();

            bucket.PredicateExpression.Add(TableAFields.Id == id);

            bucket.Relations.Add(TableAEntity.Relations.TableBEntityUsingTableAId, JoinHint.Left);
            bucket.PredicateExpression.Add(TableBFields.FilterColumn == value);
            prefetch.Add(TableAEntity.PrefetchPathTableB);

            using (DataAccessAdapter Adapter = new DataAccessAdapter())
            {
                Adapter.FetchEntityCollection(aList, bucket, prefetch);
            }

However, the resulting SQL is:

SELECT *
FROM TableA
LEFT JOIN TableB
ON TableA.ID = TableB.TableA_ID
WHERE TableA.ID = 1
AND TableB.FilterColumn = 'value'

Which negates the left join, since the TableB filter is in the WHERE clause instead of the LEFT JOIN.

I see and understand why it's doing this, I just can't figure out how to tell LLBL that I want my TableB filter to be included with the LEFT JOIN, instead of in the WHERE clause.

Thanks in advance.

Sorry, I found the answer after digging deeper on the forums. I searched several times before, but didn't search for the right terms.

I have to get the newly added relation, instantiate the CustomFilter, and set the filter there:

            IEntityRelation relation = bucket.Relations.Add(TableAEntity.Relations.TableBEntityUsingTableAId, JoinHint.Left);
            relation.CustomFilter = new PredicateExpression();
            relation.CustomFilter.Add(TableBFields.FilterColumn == value);
            prefetch.Add(TableAEntity.PrefetchPathTableB);