Hi,

I would like to generate the following query:

select A.field, B.field
from A inner join B on B.pkfield = 1234567

I'm trying to build a custom relation for this. But without succes.

IEntityRelation rel = new EntityRelation(RelationType.ManyToOne);
rel.StartEntityIsPkSide = false;
rel.CustomFilterReplacesOnClause = true;
rel.CustomFilter = new PredicateExpression(BondFields.ID == bondID);

It looks like a relation HAS to have a fieldpair. I get the following exception:

System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index at System.Collections.ArrayList.get_Item(Int32 index) at SD.LLBLGen.Pro.ORMSupportClasses.EntityRelation.GetPKEntityFieldCore(Int32 index) at SD.LLBLGen.Pro.ORMSupportClasses.EntityRelation.GetUsedEntityTypeNamesAndAliases(MultiValueHashtable& entityNamesPerAlias) at SD.LLBLGen.Pro.ORMSupportClasses.RelationCollection.GetUsedEntityTypeNamesAndAliases(MultiValueHashtable& entityNamesPerAlias) at SD.LLBLGen.Pro.ORMSupportClasses.DbSpecificCreatorBase.ProduceAliasScopeData(IRelationCollection relations) at SD.LLBLGen.Pro.ORMSupportClasses.RelationCollection.set_DatabaseSpecificCreator(IDbSpecificCreator value) at SD.LLBLGen.Pro.DQE.Oracle.DynamicQueryEngine.CreateSelectDQ(IEntityFieldCore[] selectList, IFieldPersistenceInfo[] fieldsPersistenceInfo, IDbConnection connectionToUse, IPredicate selectFilter, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relationsToWalk, Boolean allowDuplicates, IGroupByCollection groupByClause, Boolean relationsSpecified, Boolean sortClausesSpecified) at SD.LLBLGen.Pro.ORMSupportClasses.DynamicQueryEngineBase.CreateSelectDQ(IEntityFieldCore[] selectList, IFieldPersistenceInfo[] fieldsPersistenceInfo, IDbConnection connectionToUse, IPredicate selectFilter, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relationsToWalk, Boolean allowDuplicates, IGroupByCollection groupByClause) at SD.LLBLGen.Pro.DQE.Oracle.DynamicQueryEngine.CreatePagingSelectDQ(IEntityFieldCore[] selectList, IFieldPersistenceInfo[] fieldsPersistenceInfo, IDbConnection connectionToUse, IPredicate selectFilter, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relationsToWalk, Boolean allowDuplicates, IGroupByCollection groupByClause, Int32 pageNumber, Int32 pageSize) at SD.LLBLGen.Pro.ORMSupportClasses.DynamicQueryEngineBase.CreateSelectDQ(IEntityFieldCore[] selectList, IFieldPersistenceInfo[] fieldsPersistenceInfo, IDbConnection connectionToUse, IPredicate selectFilter, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relationsToWalk, Boolean allowDuplicates, IGroupByCollection groupByClause, Int32 pageNumber, Int32 pageSize) at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.CreateSelectDQ(IEntityFields2 fieldsToFetch, IFieldPersistenceInfo[] persistenceInfoObjects, IPredicateExpression filter, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relationsToWalk, Boolean allowDuplicates, IGroupByCollection groupByClause, Int32 pageNumber, Int32 pageSize) at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchTypedList(IEntityFields2 fieldCollectionToFetch, DataTable dataTableToFill, IRelationPredicateBucket filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, Boolean allowDuplicates, IGroupByCollection groupByClause, Int32 pageNumber, Int32 pageSize) at Piramide.Brs.LLBL.DatabaseAccess.Oracle10g.DataAccessAdapter.FetchTypedList(IEntityFields2 fieldCollectionToFetch, DataTable dataTableToFill, IRelationPredicateBucket filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, Boolean allowDuplicates, IGroupByCollection groupByClause, Int32 pageNumber, Int32 pageSize) at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchTypedList(IEntityFields2 fieldCollectionToFetch, DataTable dataTableToFill, IRelationPredicateBucket filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, Boolean allowDuplicates, IGroupByCollection groupByClause)

How can this be done in LLBL?

T.i.a.

Harmen

Hi Harmen,

You should initiate the Relation this way:

IEntityRelation rel = new EntityRelation(AFields.Field, BFields.field, RelationType.ManyToOne);
rel.CustomFilterReplacesOnClause = true;
rel.CustomFilter = new PredicateExpression(BondFields.ID == bondID);

Thanks.