Hi there

Can you please tell what's wrong with the code snippet given below I am getting this error "Object reference not set to an instance of an object."

 OrderCollection oOrderCollection = new OrderCollection();
            ResultsetFields oResultsetFields = new ResultsetFields(2);
            RelationCollection oRelationCollection = new RelationCollection();
            IPredicateExpression oPredicateExpression = new PredicateExpression();
            PredicateExpression oPredicateExpressionParent = new PredicateExpression();
            IPrefetchPath oPrefetchPath = new PrefetchPath(EntityType.OrderEntity);
            ISortExpression oSortExpression = new SortExpression();

            EntityField installmentAmount = new EntityField("InstallmentAmount", OrderFields.Amount * 1, AggregateFunction.Sum, typeof(decimal));
            oResultsetFields.DefineField(OrderFields.ParentOrder, 0);
            oResultsetFields.DefineField(installmentAmount, 1);

            oPredicateExpression.Add(OrderFields.ParentOrder != DBNull.Value);
            oPredicateExpression.AddWithAnd(OrderFields.ClientId == clientId);
            oPredicateExpression.AddWithAnd(OrderFields.OrderStatus != OrdersEnum.OrderStatus.Cancelled);

            GroupByCollection oGroupByCollection = new GroupByCollection(oResultsetFields[0]);
            DerivedTableDefinition oDerivedTableDefinition = new DerivedTableDefinition(oResultsetFields, "Installments", oPredicateExpression, oGroupByCollection);
            IDynamicRelation oDynamicRelation = new DynamicRelation(oDerivedTableDefinition, JoinHint.Inner, EntityType.OrderEntity, "O", ((new EntityField(OrderFieldIndex.ParentOrder.ToString(), "Installments", typeof(int)) == OrderFields.Id.SetObjectAlias("O"))));
            oRelationCollection.Add(oDynamicRelation);
            oRelationCollection.SelectListAlias = "O";

            oPredicateExpressionParent.Add(new EntityField2("InstallmentAmount", "Installments", typeof(decimal)) != OrderFields.Amount.SetObjectAlias("O"));
            oPredicateExpressionParent.AddWithAnd(OrderFields.ClientId.SetObjectAlias("O") == clientId);
            oPrefetchPath.Add(OrderEntity.PrefetchPathOrders, 0, oPredicateExpression);

            oOrderCollection.GetMulti(oPredicateExpressionParent, oRelationCollection);

and the stack trace of the error is as follows:

at SD.LLBLGen.Pro.ORMSupportClasses.DbSpecificCreatorBase.CreateParameter(IEntityFieldCore field, IFieldPersistenceInfo persistenceInfo, ParameterDirection direction, Object valueToSet) at SD.LLBLGen.Pro.ORMSupportClasses.FieldCompareValuePredicate.ToQueryText(Boolean inHavingClause) at SD.LLBLGen.Pro.ORMSupportClasses.PredicateExpression.ToQueryText(Boolean inHavingClause) at SD.LLBLGen.Pro.ORMSupportClasses.PredicateExpression.ToQueryText(Boolean inHavingClause) at SD.LLBLGen.Pro.ORMSupportClasses.DynamicQueryEngineBase.AppendWhereClause(IPredicate filter, QueryFragments destination, IQuery query) at SD.LLBLGen.Pro.DQE.SqlServer.DynamicQueryEngine.CreateSelectDQ(IEntityFieldCore[] selectList, IFieldPersistenceInfo[] fieldsPersistenceInfo, IRetrievalQuery query, 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, DbConnection connectionToUse, IPredicate selectFilter, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relationsToWalk, Boolean allowDuplicates, IGroupByCollection groupByClause) at SD.LLBLGen.Pro.DQE.SqlServer.DynamicQueryEngine.CreatePagingSelectDQ(IEntityFieldCore[] selectList, IFieldPersistenceInfo[] fieldsPersistenceInfo, DbConnection connectionToUse, IPredicate selectFilter, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relationsToWalk, Boolean allowDuplicates, IGroupByCollection groupByClause, Int32 pageNumber, Int32 pageSize) at SD.LLBLGen.Pro.ORMSupportClasses.DaoBase.PerformGetMultiAction(ITransaction containingTransaction, IEntityCollection collectionToFill, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IPredicate selectFilter, IRelationCollection relations, IPrefetchPath prefetchPathToUse, ExcludeIncludeFieldsList excludedIncludedFields, Int32 pageNumber, Int32 pageSize) at SD.LLBLGen.Pro.ORMSupportClasses.EntityCollectionBase1.GetMulti(IPredicate selectFilter, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relations, IPrefetchPath prefetchPathToUse, ExcludeIncludeFieldsList excludedIncludedFields, Int32 pageNumber, Int32 pageSize) at SD.LLBLGen.Pro.ORMSupportClasses.EntityCollectionBase1.GetMulti(IPredicate selectFilter, IRelationCollection relations)

Runtime library version (build number), please.

SD.LLBLGen.Pro.DQE.SqlServer.NET20.dll - 3.1.11.0221 SD.LLBLGen.Pro.LinqSupportClasses.NET35.dll - 3.1.11.0426 SD.LLBLGen.Pro.ORMSupportClasses.NET20.dll - 3.1.11.0427

oPredicateExpressionParent.Add(new EntityField2...

EntityField2 is used in the Adapter template set, not in SelfServicing, please use EntityField instead.

Thanks buddy it worked for me , but let inform you in the examples in the Documentation the second example is wrong for self service, I myself added entityfield2 by seeieng the example from there the link is here : http://www.llblgen.com/documentation/2.6/Using%20the%20generated%20code/gencode_derivedtabledynamicrelation.htm

Please correct that one.

chirag.vashisht wrote:

Thanks buddy it worked for me , but let inform you in the examples in the Documentation the second example is wrong for self service, I myself added entityfield2 by seeieng the example from there the link is here : http://www.llblgen.com/documentation/2.6/Using%20the%20generated%20code/gencode_derivedtabledynamicrelation.htm

Please correct that one.

You are right, there is a typo in the line:

IPredicate filter = (new EntityField2("Total", "OrderDetailTotals", typeof(int)) > 5000);

it should be

IPredicate filter = (new EntityField("Total", "OrderDetailTotals", typeof(int)) > 5000);

We will look into it.

Fixed.