CODEWITHSUNDEEP
.netlinq.net-3.5
aboutme
aboutme

Reputation: 245

Linq and comparing two date columns

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)

Upvotes: 0

Views: 330

Answers (1)

Usman Masood
Usman Masood

Reputation: 1987

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.

Upvotes: 1

Related Questions