title: Need to convert this query to linq or lambda
body: <p>This query pulls back two columns a userid column and a column of their total sales for the current month.</p>
  
  <p>I need to add a column that ranks them (it would be the exact same as the row #)</p>
  
  <p>And I need to convert this from SQL to LINQ or Lambda.</p>
  
  <pre><code>select pu.userID, SUM(o.OrderTotal) as OrderTotal from ProPit_User pu
  inner join SeperateDB.dbo.orders o on pu.salesrepid = o.salesrepid and o.DateCompleted &gt; '2014-05-01' and o.DateCompleted &lt; '2014-05-23'
  group by pu.userID
  order by SUM(o.OrderTotal) desc
  </code></pre>
  
  <p>Currently returns:</p>
  
  <pre><code>userID  OrderTotal
  340 68992.74
  318 49575.05
  228 42470.88
  278 38196.87
  291 36220.52
  351 34962.32
  422 31764.67
  178 31433.41
  430 30836.77
  212 30375.99
  </code></pre>