Reputation: 3626
I am working in a web project using ASP.NET MVC3 and entity for database access.
I need to update database everyday automatically. To be more specific I need to check the database to see if the records are older than one month or more and set their status as old (there is a status and date created field in the table).
How can I do that?
Upvotes: 0
Views: 221
Reputation: 1906
If you must do it through .net code and cannot create a SQL server task, then you could create a executable that gets kicked off by a windows scheduled task. Or your executable could be a windows services that uses a timer. I don't understand why you would want to put that logic in a website.
Upvotes: 1