Comparing DateTime object in Linq

Question

I'm trying to create a linq query to get all date 1 year back (expecting 365 values)

 using (var context = new Context1())
 {
      var query = (from c in context.Daily25Data
                   where c.Date > DateTime.Now.AddYears(-1)
                   select c).ToList();

                   Console.WriteLine(query);
 }

tried to use the above code but get exception

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

RB. · Accepted Answer · 2016-03-30 15:17:49Z

4

You can just pull the value out into a variable before you execute your query:

var oneYearEarlier = DateTime.Now.AddYears(-1);

var query = (from c in context.Daily25Data
             where c.Date > oneYearEarlier
             select c).ToList();

answered Mar 30, 2016 at 15:17

RB.

37.4k13 gold badges103 silver badges137 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ocuenca · Accepted Answer · 2016-03-30 15:21:49Z

2

Agreed with the @RB answer. You can also use DbFunctions.AddYears static method:

var query = (from c in context.Daily25Data
               where c.Date > DbFunctions.AddYears(DateTime.Now,-1)
               select c).ToList();

answered Mar 30, 2016 at 15:21

ocuenca

39.5k12 gold badges95 silver badges107 bronze badges

Collectives™ on Stack Overflow

Comparing DateTime object in Linq

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related