title: Rewrite sql to linq, probably piece of cake, but can't get my head around it
body: <p>I need to rewrite this sql statement in Linq.</p>
  
  <pre><code>select hand,count(hand) as Hands, deviceid from individualhands
  where deviceid = '977aed93-d1f1-4f7a-a6fa-6bc3ea7d863b'
  group by hand, deviceid
  </code></pre>
  
  <p>Can anybody help? :)</p>