So I’m making an appointment scheduler. I want my system to send the user an e-mail when the upcoming event is tomorrow. I’m storing every appointment in an SQL database.
I don’t know how to check continuously if the date is within a day instead of only checking it once I load the View that lists these appointments.
>Solution :
I suggest you use existing scheduling engines such as Hangfire, Quartz.NET or similar
That way you can make recurring job that triggers once a day, checks for appointments and then send an email.