title: How to use DateAdd function in Linq?
body: <p>I have an events that users can post and related comments can be added for each events, although i have my db engine resides in the server in Us but i am living in east Europe(Cy) and we have like 7-8 hours time differences. I am using Linq anonymous type for both Events and Comments so i like to know how to use DateAdd function to correct the time differences in the Datetime of comments especially. </p>
  
  <p>Here is the example of my linq expression;</p>
  
  <pre><code>var myEvents = from a in myEntities.AddEvents
                 where a.Authorized == true
                 orderby a.Id descending
                 select new
                 {
                     a.Id,
                     a.VenueName,
                     a.EventType,
                     a.Date,
                     a.StartTime,
                     a.EndTime,
                     a.Address,
                     a.Phone,
                     a.Reviews (This is for "Comments" and where i stuck!)
                 };
  </code></pre>
  
  <p>Any ideas appreciated! Thanks</p>