Otp Verification with in 5 minutes

Jun 6 2019 1:48 AM

I need to check the otp generated time. When user entered otp it will expire with in 5 minutes. I need a query in entity framework or linuq

I wirte like below but i am not getting result, I thought it wrong can any help me

query

-------

var login = _context.MobileOtp.FirstOrDefault(i => i.MobileNumber == mobileNumber && (i.CreateDate.Minute - DateTime.Now.Minute) <= 5 && i.Otp == otp);

Please ASAP

Answers (2)

How to access Stored Procedure in MVC core using linq

Join two tables