title: Linq To SQL Group By and Sum
body: <p>Her is an image showing a the table i have, b the grid i need to display.
  opps cant post image. ill try to explain. My table have four colums.</p>
  
  <ol>
  <li>Project Number(String)</li>
  <li>ItemNumber(String)</li>
  <li>Location(String)</li>
  <li>Qty.(Real).</li>
  </ol>
  
  <p>My grid need to look like this.</p>
  
  <ol>
  <li>ProjectNumber</li>
  <li>ItemNumber</li>
  <li>QtyMain.</li>
  <li>QtyOther.</li>
  </ol>
  
  <p>I Need to write a linq query Grouping evry line so i will se 1 Line pr Project/ItemNumber combination summing qty into 2 differetn colums 1 showing to qty where location is main and 1 showing the qty where location is not (!=) main. Can linq do this for me, or how can thsi be done? </p>