I can't get an IPredicateExpression that is identical to the following sql where clause right.

Does anyone have an example of similar code I can study?

    (fieldA = 10) 

AND ( (getdate() BETWEEN FieldBegin AND FieldEnd) OR (FieldBegin >= getdate()) ) AND (FieldB = 55) AND (FieldC = 34)

I guess you need to use a DbFunctionCall for the GetDate variable in combination with a FieldCompareExpressionPredicate.

Regards, Danny

Can you post what you have got so far, and the SQL it generated...?

Matt

Something like this (in VB.NET) :

        Dim filter As New PredicateExpression
        Dim fld As New EntityField2("currDate", New DbFunctionCall("getdate()", Nothing))

        filter.Add(New FieldCompareExpressionPredicate(AccountFields.CreatedOn, Nothing, ComparisonOperator.GreaterThan, New DbFunctionCall("getdate()", Nothing)))
        filter.AddWithOr(New FieldBetweenPredicate(fld, Nothing, AccountFields.CreatedOn, AccountFields.ModifiedOn))

Regards, Danny