How to use addHours function with Linq?

master777 · April 4th, 2013, 09:56 AM

Hi, I am using the modified version of the content of the book and i use "Events" instead of "Genres" and the "Comments" as is. Although i have my DB engine resides in the USA hence we have 8 hours of time differences and basically i want to correct this time differences by adding "8hrs" to the comments "CreateDateTime" column when the user adds his/her comment. Since we use Linq and i don't how to achieve this! Or Can we use TimeZoneInfo convertTime function of conversion?? Any help will be appreciated. Thanks!
Here is my linq anonym type as follows,
where a.Authorized == true
select new
{
a.Id,
a.VenueName,
a.EventType,
a.Date,
a.StartTime,
a.EndTime,
a.Address,
a.Phone,
a.Reviews(This is my Comments where i stuck!!!)
};

Imar · April 4th, 2013, 02:40 PM

If you want to change it just when you display it, you can query the data first, and then loop over it. Depending on the resultset, you may need a double loop:

Code:

foreach (Event event in events)
{
  foreach(Review review on evemt.Reviews)
  {
         review.CreateDateTime = review.CreateDateTime.AddHours(8);
     }
}

Alternatively, you can do this when you insert the data, so the data is in a more consistent state in the database.

Hope this hepls,

Imar

master777 · April 4th, 2013, 06:16 PM

I have been searching for this approach for days! may be like 2 weeks. So Thank you ever so much! Excellent!!!