asp.net 2.0 llblgenpro 2 self-servicing

Hello,

I'm wondering if LLBLGen Pro can do the following query. I can't find to_date function in the documentation.

select * from example
where to_date(date) > sysdate

Thanks!

IPredicateExpression filter = new PredicateExpression(); filter.Add(YourEntity.ToDate >= DateTime.Now);

To call to_date, you should be using DBFunctionCall, check the following section in the manual: "Using the generated code -> Calling a database function"

To get sysdate, check the following thread: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=6873

Thank You