title: how to group by in LINQ and not select all columns
body: <p>I am trying to write a LINQ query which is complex for me now since I am a newbie to LINQ.</p>
  
  <p>I have a table like below...</p>
  
  <pre><code>UserId | CompanyId | ProblemDescription | CreatedTime      | TimeSpentMins
  -----------------------------------------------------------------------
  1      | 95        | Sysmtem is crashed | 2016-01-01 15:23 | 25
  1      | 95        | Total is incorrect | 2016-01-01 15:45 | 45
  </code></pre>
  
  <p>I want to write a LINQ query that will do the job below. CreatedTime has date and time but I want to group it by only date.</p>
  
  <pre><code>SELECT UserId, CompanyId,CreateTime Sum(TimeSpentMins)
  FROM TransactionLogs
  GROUP BY UserId, CompanyId, Convert(DATE,CreatedTime)
  </code></pre>
  
  <p>How can I write this LINQ? I wanted to put my code below but I got nothing :(</p>