title: Sum 2 Columns in Linq
body: <p>I am trying to sum two columns that i have in LINQ. The following is my LINQ statement</p>
  
  <pre><code>var SigmaGood =  from n in db.tbl_dppITHr
                   where n.ProductionHour &gt;= SelectedDateDayShiftStart
                   where n.ProductionHour &lt;= SelectedDateEnd
                   select n.part1 + n.part2
  
  ViewData["GoodTotal"] = SigmaGood.Sum();
  </code></pre>
  
  <p>I am trying to get a total for part1 + part2;</p>
  
  <p>When i try and test the result i dont get any value back i get a blank.</p>
  
  <p>Anyone any ideas what i am doing incorrect?</p>
  
  <p><img src="https://i.stack.imgur.com/vArCI.jpg" alt="enter image description here"></p>