Hi all,

In LinqToSql from Microsoft we've used the following statement to get the difference of two timestamps in seconds:

Where(s => SqlMethods.DateDiffSecond(s.LastUpdate, DateTime.Now) <= SessionTimeout)

How has the query to look likes with LLBLGEN Pro? Important is to filter on server side and not in memory.

Kind regards, Danny

You can use DateTime.AddSeconds() or .CompareTo() as follows:

I'm using AddYears() in the following example.

                var q = from o in metaData.Order
                        where o.OrderDate.Value.AddYears(14) > DateTime.Now
                        select o;

This Translates into Sql Server method DateAdd(), or DateDiff().

For more info please check Function mappings