Hi, I'm hoping to write LLBLGen code that is equivalent to SQL like:

SELECT c.Description AS consDesc, l.Description AS likeDesc, c.ConsequenceIndex * l.LikelihoodIndex AS riskValue FROM ISO20KAuditFinding f INNER JOIN ISO20KRiskAssessmentConsequence c ON f.RiskAssessmentConsequenceID = c.RiskAssessmentConsequenceID INNER JOIN ISO20KRiskAssessmentLikelihood l ON f.RiskAssessmentLikelihoodID = l.RiskAssessmentLikelihoodID WHERE (c.ConsequenceIndex * l.LikelihoodIndex > 10)

The bit i'm struggling with is the where clause, I assume I have to somehow compare something to :

Expression sumExp = new Expression(EntityFieldFactory.Create(Iso20KRiskAssessmentConsequenceFieldIndex.ConsequenceIndex), ExOp.Mul, EntityFieldFactory.Create(Iso20KRiskAssessmentLikelihoodFieldIndex.LikelihoodIndex));

I can see how to compare this value to a field, but not to a constant or a variable.

Thanks, Matt

Hello,

What version of llblgen do you use?

you can create a predicate using this type of code for the v2:

IPredicate filter = ((Iso20KRiskAssessmentConsequenceFields.Consequence * Iso20KRiskAssessmentLikelihoodFields.Likelihood) >10)

and then apply this filter to your request.