Linq and comparing two date columns

Question

I get a notsupportedexception when i run the following linq query. Any ideas how to resove it

        var declines = from d in _Db.DeclinedSettlementSet
                       where d.STATUS == Status.REPORTED               
                        && d.ADD_DATE < d.EDIT_DATE.AddDays(-3)

Answer 1

from SP1 Microsoft has removed for client side function support from expression trees, this has been done to improve peroformance. in simple worlds any client side function can't be included in like in your case its .AddDays(n). regarding Jon's answer i think it won't work either as still TimeSpan is also a client side function.