title: How can I calculate sum of column value in linq to sql query?
body: <p>I'm write this query:</p>
  
  <pre><code>var query2 = (from p in behzad.Compare_closed_numbers_in_CRM_and_Billing_system_detail_counters
                 where p.fileid == point.id
                 select new
                 {
                     p.count
                 }).ToArray();
  </code></pre>
  
  <p>in count column have any value,and I want to sum all of the count value. For example:
  <a href="https://i.stack.imgur.com/MQh7a.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MQh7a.png" alt="enter image description here"></a></p>
  
  <p>how can I implant that?thanks.</p>