Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
Hi,
 
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.
 
Thank you.
Posted 29-Jun-12 3:22am

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

I would go for a scheduled job (Create a Job[^]) for ease of use and maintainability.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 449
1 Maciej Los 274
2 CPallini 160
3 Sergey Alexandrovich Kryukov 152
4 Richard MacCutchan 130
0 OriginalGriff 5,474
1 Sergey Alexandrovich Kryukov 4,713
2 Peter Leow 2,944
3 DamithSL 2,465
4 Maciej Los 2,434


Advertise | Privacy | Mobile
Web02 | 2.8.140718.1 | Last Updated 29 Jun 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid