title: Linq select into a new class without Group
body: <p>Will it be possible to write linq to put result into some other object without using group like below,</p>
  
  <pre><code>SELECT test.name, test.date, test.flag, cmd, root, result
  into [streamanalyticsoutput] from [streamanalyticsinput]
  </code></pre>
  
  <p>Here is the Linq query with Group,</p>
  
  <pre><code>var query2 = from c in _context.MCTargets
               group c by c.MarketingCampaignID into g
               select new 
               {
                   StartDate = d1,
                   EndDate = d2
               };
  </code></pre>