title: Multi sums into  one anonymous type with linq?
body: <p>I have this simple datatable : </p>
  
  <pre><code> type (string)   |       cnt (int)     
  _____________________________________
  aaa                         1
  aaa                         2
  aaa                         10
  bbb                         1
  bbb                         1
  </code></pre>
  
  <p>I want to produce <strong>1</strong> anonymous type  like this : </p>
  
  <pre><code>{
  sumAAA= 13 , sumBBB=2  //13=1+2+10....
  }
  </code></pre>
  
  <p>something like : (psuedo code ) </p>
  
  <pre><code>var obj= dt.AsEnumerable().Select(f=&gt; new { sumAAA =f.sumOfCntOfAaa , sumBBB =f.sumOfCntOfBbb });
  </code></pre>
  
  <p>any help ?</p>
  
  <p>edit , this will help you</p>
  
  <pre><code>   DataTable dt = new DataTable("myTable");
      dt.Columns.Add("cnt", typeof (int));
      dt.Columns.Add("type", typeof (string));
      DataRow row = dt.NewRow();
      row["cnt"] = 1;
      row["type"] = "aaa";
      dt.Rows.Add(row);
      row = dt.NewRow();
      row["cnt"] = 2;
      row["type"] = "aaa";
      dt.Rows.Add(row);
      row = dt.NewRow();
      row["cnt"] = 10;
      row["type"] = "aaa";
      dt.Rows.Add(row);
      row = dt.NewRow();
      row["cnt"] = 1;
      row["type"] = "bbb";
      dt.Rows.Add(row);
      row = dt.NewRow();
      row["cnt"] = 1;
      row["type"] = "bbb";
      dt.Rows.Add(row);
  </code></pre>