Converting possible null value to a default in a time conversion inside of Linq

Question

Given the timezone offset value as a nullable int how would I go about converting that inside the linq query to the current time of the location?

 var data = (from c in dbContext.Contacts
                      select new
                        {
                            c.Id,
                            TheirTime = DateTime.UtcNow.AddHours(c.TimezoneOffset)
                     })

This returns a "LINQ to Entities does not recognize the method 'System.DateTime AddHours(Double)' method, and this method cannot be translated into a store expression." error.

You might want to check the answer to my question here (http://stackoverflow.com/questions/18901025/custom-extension-method-to-simplify-linq-to-sql-statement). — Ani, Jun 03 '14 at 17:15
Also http://stackoverflow.com/questions/10717177/how-to-query-and-calculate-dates-in-the-where-clause-of-a-linq-statement — Jon, Jun 03 '14 at 17:25

score 1 · Accepted Answer · answered Jun 03 '14 at 17:33

1

You can use EntityFunctions for this specific query:

var data = (from c in dbContext.Contacts
                      select new
                        {
                            c.Id,
                            TheirTime =EntityFunctions.AddHours(DateTime.UtcNow,c.TimezoneOffset)
                     })

answered Jun 03 '14 at 17:33

Bura Chuhadar

3,653
1
14
17

Thanks, wasn't familiar with those. But they have been deprecated and replaced with System.Data.Entity.DbFunctions – John S Jun 03 '14 at 18:35
@JohnS I didn't know your entity framework version. But thanks for the info. Cool stuff! – Bura Chuhadar Jun 03 '14 at 18:37

Converting possible null value to a default in a time conversion inside of Linq

1 Answers1