I want to write LINQ query from last 10 mins inserted records from table. How do I write it? Please help me.
Below is my SQL query:
SELECT AccountNumber, OrderID,RechargeDate
FROM OrderItem OI
WHERE RechargeStatus = 'SUCCESS'
AND AccountNumber ='" + AccountNumber + "' and DateADD(minute, -10,getdate() ) < RechargeDate AND OrderItemID <> " + OrderItemID + "";
Now, I want to rewrite the query above using LINQ.
You need to use Where
linq extension method.
db.OrderItems.Where(x=>x.RechargeStatus.Equals("SUCCESS") &&
x.AccountNumber == strAccountNumber &&
x.RechargeDate > DateTime.Now.AddMinutes(-10) &&
x.OrderItemID != OrderItemID )
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments