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.

CodePudding user response：

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.