Column contains null data in asp.net mvc
<p>I am getting the data for the current month. For site.ID=4 there is no data in the backend. I am getting the column contains no data exception. How can I resolve this issue?</p>

<pre><code>List&lt;ManHourReport&gt; manHoursReports = new List&lt;ManHourReport&gt;();
var sites = context.JocSites.Where(j =&gt; j.JOCid == jocID).ToList();
    foreach (var site in sites)
    {
       double manPowermonthly = context.ManHoursWorked.
              Where(s =&gt; s.SiteID == site.ID &amp;&amp; s.Date.Month==DateTime.Now.Month).
              Sum(m =&gt; m.NumOfLabourForJOC); // here for the site.ID=4, there is no data in the backend. I am getting the error.
       double manHoursMonthly = context.ManHoursWorked.
              Where(s =&gt; s.SiteID == site.ID &amp;&amp; s.Date.Month == DateTime.Now.Month).
              Sum(m =&gt; m.NumOfWorkingHoursJOC);
       double manHoursYearly = context.ManHoursWorked.
              Where(s =&gt; s.SiteID == site.ID &amp;&amp; s.Date.Year == DateTime.Now.Year).
              Sum(m =&gt; m.NumOfWorkingHoursJOC);
                manHoursReports.Add(new ManHourReport()
                {
                    SiteManPower = manPowermonthly,
                    SiteManHourMonthly = manHoursMonthly,
                    SiteManHourYearly = manHoursYearly
                });
    }
</code></pre>