Hi !

This is my model

I use GetMultion Entity_B_Child. When I tried to add relation to Entity_C_Link relations.Add(Entity_B_Child.Relations.Entity_C_LinkEntityUsingEntity_B_ChildId_A);

When the app run Entity_B_Child.GetMulti(filter, maxTotalRecordCount, defaultSort, relations, startIndex_1base, pageSize);

An exception has throwed : SD.LLBLGen.Pro.ORMSupportClasses.ORMRelationException: 'Relation at index 1 doesn't contain an entity already added to the FROM clause. Bad alias?'

Thanks for your help.

Update:

Model:

public CatCollection SearchEvents(Criteria criteria)
{
    var cats = new CatCollection();
    IRelationCollection relations = new RelationCollection();
    IPredicateExpression filter = new PredicateExpression();

    if (critere.Keywords.Any())
    {
        relations.Add(CatKeywordEntity.Relations.CatEntityUsingCatId);
        var filterKeyword = new FieldCompareRangePredicate(CatKeywordFields.KeywordId, critere.Keywords);
        filter.AddWithAnd(filterKeyword);
    }

    int pageNumber = criteria.PageIndex + 1;
    int pageSize = criteria.PageSize;

    int startIndex = (pageNumber > 1) ? checked((pageNumber - 1) * pageSize) : 0;
    int startIndex_1base = startIndex + 1;

    SortExpression defaultSort = new SortExpression(new SortClause(CatFields.Date, SortOperator.Descending));

    int maxTotalRecordCount = SetMaxRecordSize(pageSize);
    cats.GetMulti(filter, maxTotalRecordCount, defaultSort, relations, startIndex_1base, pageSize);
    int totalRecordCount = Math.Min(cats.GetDbCount(filter, relations), maxTotalRecordCount);

    return cats;
}

Items In relation collection :

[0] {CatKeyworkEntity.(CatId) m:1 CatEntity.(Id)} [1] {AnimalEntity.(Id) 1:1 CatEntity.(Id) (Hierarchy relation)}

Are A and B in an inheritance Hierarchy? Could you please post the complete fetch code?

Are A and B in an inheritance Hierarchy?

Yes

Could you please post the complete fetch code?

Yes, I updated threads.

Please post the SQL query executed. You can obtain the query using tracing, see https://www.llblgen.com/Documentation/5.0/LLBLGen%20Pro%20RTF/Using%20the%20generated%20code/gencode_troubleshootingdebugging.htm

Otis wrote:

Please post the SQL query executed. You can obtain the query using tracing, see https://www.llblgen.com/Documentation/5.0/LLBLGen%20Pro%20RTF/Using%20the%20generated%20code/gencode_troubleshootingdebugging.htm

Yes I has activated tracing. But any queries displayed...

I found a workaround with QuerySpec instead.

Ok, so we can close this thread? For completeness, what's the workaround you're using? (As queryspec creates the same relationcollection objects you're using)

Sorry for my answer so late.

I used this workaround :

var cats = new CatCollection();
var queryFactory = new QueryFactory();
EntityQuery<CatEntity> catQuery = queryFactory.Cat.As("CustomCats");
catQuery.From(QueryTarget.InnerJoin(queryFactory.CatKeyword)
                    .On(CatFields.Id == CatKeywordFields.CatId));
catQuery.Where(CatKeywordFields.Id.In(catKeywordIds));
cats.GetMulti(catQuery);

Before close this thread have a solution for the firts method or are you recommend to use my workaround ?

The original query should work fine (our tests succeed) so we don't know why it fails. Nevertheless, your queryspec variant is recommended so you should keep using the workaround. The As("CustomCats") isn't needed btw.

OK, thanks for your time. I keep the query spec solution.

I close this thread.