title: How to get last 10 mins records using linq?
body: <p>I want to write LINQ query from last 10 mins inserted records from table. How do I write it? Please help me.</p>
  
  <p>Below is my SQL query:</p>
  
  <pre><code>SELECT AccountNumber, OrderID,RechargeDate 
  FROM    OrderItem OI
  WHERE RechargeStatus = 'SUCCESS' 
    AND AccountNumber ='" + AccountNumber + "' and DateADD(minute, -10,getdate() ) &lt; RechargeDate  AND OrderItemID &lt;&gt; " + OrderItemID + "";
  </code></pre>
  
  <p>Now, I want to rewrite the query above using LINQ.</p>