Hi,

Im trying to turn this SQL into an LLBLGen Expression / SkillEntity:

SELECT S.* FROM [dbo].[Skill] S INNER JOIN [dbo].[Queue] Q ON S.ID=Q.SkillID WHERE Q.[TimeStamp] = ( SELECT MAX(Q2.[TimeStamp]) FROM [dbo].[Skill] S2 INNER JOIN [dbo].[Queue] Q2 ON S2.ID=Q2.SkillID )

I don't know how to perform the subquery, is it possible at all?

Yeah I think it's possible if turned into the following:

SELECT S.* 
FROM [dbo].[Skill] S
INNER JOIN [dbo].[Queue] Q ON S.ID=Q.SkillID
WHERE 
    Q.[TimeStamp] IN (
     SELECT MAX(Q2.[TimeStamp]) 
     FROM [dbo].[Skill] S2
     INNER JOIN [dbo].[Queue] Q2 ON S2.ID=Q2.SkillID
    )

Note the IN keyord rather than the '='.

Then you can construct the IN predicate using FieldCompareSetPredicate, and set the AggregateFunctionToApply property of the passed EntityField parameter to AggregateFunction.Max

Walaa wrote:

Then you can construct the IN predicate using FieldCompareSetPredicate, and set the AggregateFunctionToApply property of the passed EntityField parameter to AggregateFunction.Max

Cool, I didn't know you could do that with an EntityField... Thanks! (for the fast reply as well)