Hossain Muctadir
Hossain Muctadir

Reputation: 3626

Database Update periodically in an MVC3 project

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

Answers (1)

Ryand.Johnson
Ryand.Johnson

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

Related Questions