gistfile1.cs

foreach (var campDetail in camp.AdvertCampaignDetails)
                    {
                        DateTime check_date = DateTime.Now.AddDays(-i);
                        inter += _db.AdvertCampaignDetailInteractions
                                .Where(c => c.AdvertID == campDetail.AdvertID &&  EntityFunctions.TruncateTime(c.StartDatetime) == check_date.Date)
                                .Count();
                        elapsedTime += _db.AdvertCampaignDetailInteractions
                                .Where(c => c.AdvertID == campDetail.AdvertID && EntityFunctions.TruncateTime(c.StartDatetime) == check_date.Date && c.TimeElapsed!=null)
                                .Sum(c => c.TimeElapsed.GetValueOrDefault(0));
                        height += _db.AdvertCampaignDetailInteractions
                                .Where(c => c.AdvertID == campDetail.AdvertID && EntityFunctions.TruncateTime(c.StartDatetime) == check_date.Date)
                                .Sum(c=>c.Height);                        
                    }