title: SELECT and SUM in Entity Framework
body: <p>I want to sum all the columns and where context between dates, basically I want to convert the below SQL query to EF: </p>
  
  <pre><code>select meterCategory, sum(cost) maxCost
  from [dbo].[UsageData]
  where date between '2019-06-25' and '2019-06-25' and 
        cost &gt;= 1
  group by meterCategory
  order by maxCost desc
  </code></pre>