Is it possible to add a pedicate to a PredicateExpression that is not based on existing fields?

For example, I want to add the following clause to my query:

select ... where (getdate() <= <dateCondition>)

Is it possible to create this condition based on getdate() (instead of an existing field) in llblGen ver 2.0?

Yeah sure. Would be something like:

DataAccessAdapter adapter = new DataAccessAdapter();
RelationPredicateBucket bucket = new RelationPredicateBucket();

IExpression GetDateExp = new DbFunctionCall("GETDATE", null);

// just create any field, won't matter, our expression will dominate.
EntityField2 field = OrdersFields.OrderDate.SetExpression(GetDateExp);

bucket.PredicateExpression.Add(new FieldCompareValuePredicate(field, null, ComparisonOperator.LessEqual, dateCondition));

adapter.FetchEntityCollection(Orders, bucket);

It worked. thanks...

Walaa wrote:

Yeah sure. Would be something like:

DataAccessAdapter adapter = new DataAccessAdapter();
RelationPredicateBucket bucket = new RelationPredicateBucket();

IExpression GetDateExp = new DbFunctionCall("GETDATE", null);

// just create any field, won't matter, our expression will dominate.
EntityField2 field = OrdersFields.OrderDate.SetExpression(GetDateExp);

bucket.PredicateExpression.Add(new FieldCompareValuePredicate(field, null, ComparisonOperator.LessEqual, dateCondition));

adapter.FetchEntityCollection(Orders, bucket);