title: LINQ COUNT on multiple columns
body: <p>If I have a table with a title column and 3 bit columns (f1, f2, f3) that contain either 1 or NULL, how would I write the LINQ to return the title with the count of each bit column that contains 1? I'm looking for the equivalent of this SQL query:</p>
  
  <pre><code>SELECT title, COUNT(f1), COUNT(f2), COUNT(f3) FROM myTable GROUP BY title
  </code></pre>
  
  <p>I'm looking for the "best" way to do it. The version I came up with dips into the table 4 times when you look at the underlying SQL, so it's too slow.</p>