LINQ to Entities does not recognize the method 'System.DateTime AddSeconds(Double)' method, and this method cannot be translated into

Question

I receive this error on

base {System.SystemException} = {"LINQ to Entities does not recognize the method 'System.DateTime AddSeconds(Double)' method, and this method cannot be translated into a store expression."}

on this code

      var eventToPushCustom = eventCustomRepository.FindAllEventsCustomByUniqueStudentReference(userDevice.UniqueStudentReference)
                                    .Where(x => x.DateTimeStart > currentDateTime && currentDateTime >= x.DateTimeStart.AddSeconds(x.ReminderTime))
                                    .Select(y => new EventPushNotification
                                    {
                                        Id = y.EventId,
                                        EventTitle = y.EventTitle,
                                        DateTimeStart = y.DateTimeStart,
                                        DateTimeEnd = y.DateTimeEnd,
                                        Location = y.Location,
                                        Description = y.Description,
                                        DeviceToken = y.UsersDevice.DeviceTokenNotification
                                    });

I believe the problem is in x.DateTimeStart.AddSeconds(x.ReminderTime)

The argument of .AddSeconds in my case must be "dynamic" ... Any idea how to solve it?

score 50 · Accepted Answer · answered Jan 29 '13 at 12:49

50

Use EntityFunctions.AddSeconds method to create date time on server side.

 .Where(x => x.DateTimeStart > currentDateTime && 
             currentDateTime >= EntityFunctions.AddSeconds(x.DateTimeStart, x.ReminderTime))

answered Jan 29 '13 at 12:49

Sergey Berezovskiy

232,247
41
429
459

28

Note that EntityFunctions is now obsolete. Use `DbFunctions` instead. – Tyler Forsythe Apr 24 '14 at 00:35
@TylerForsythe thanks for update! It's a fast-changing world :) – Sergey Berezovskiy Apr 24 '14 at 07:57
{"FUNCTION db.AddMinutes does not exist"} :( – Pažout Jan 20 '15 at 18:49
@Pažout are you using MySQL database? – Sergey Berezovskiy Jan 23 '15 at 07:45
@ Tyler Forsythe ,which version of entity framework is needed for using `DbFunctions` ? – Shaiju T Aug 30 '15 at 10:26

LINQ to Entities does not recognize the method 'System.DateTime AddSeconds(Double)' method, and this method cannot be translated into

1 Answers1

Linked

Related