title: Lambda expression for Entity Framework query
body: <p>I'm stuck trying to map this sql:</p>
  
  <pre><code>select dt.Id, dateadd(dd,datediff(dd,0,dt.CreatedAt),0) as Ct, DId, Amount
  from dt, ad
  where dt.ADId = ad.ADId and ad.Id = '13B29A01-8BF0-4EC9-80CA-089BA341E93D'
  order by dateadd(dd,datediff(dd,0,dt.CreatedAt),0) desc, DId asc
  </code></pre>
  
  <p>Into an Entity Framework-compatible lambda query expression. I'd appreciate any help.   </p>