LINQ to Entities with AddMonth method

user_384753 0
Viewed 14474

This is my code:

 return Newsletterctx.Subscribers.Count(o =>
     o.Validated == false &&
     o.ValidationEmailSent == true &&
     o.SubscriptionDateTime.AddMonths(1) < DateTime.Now);

I get this error:

LINQ to Entities does not recognize the method 'System.DateTime AddMonths(Int32)' method, and this method cannot be translated into a store expression.

entity-framework c#
4 Answers

Now, EntityFramework, Version=6 above, you can jus use System.Data.Entity.DbFunctions

return Newsletterctx.Subscribers.Count(o =>
 o.Validated == false &&
 o.ValidationEmailSent == true &&
  DbFunctions.AddMonths(o.SubscriptionDateTime,1) < DateTime.Now);

However, in this case, use the temp variable testDate that answered by Fredrik Mörk uses less resources.

user_17802550
Related