In my project, i want to implement a mechanism for time bound records. For example, lets say the customer creates a transactions with:
TransactionID, From, To, etc, CreationDate
And i want to delete these records, 5 days after creation date.
It would be great to get some ideas to use in production for this.
I am using Entity Framework, Code-First model. I want to know how to proceed about this issue. Does it have to be a Scheduled Job in SSMS? or is there a better way to handle these situations in code?
Any ideas are appreciated.