Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Anyone implemented auditing?
Message
De
12/07/2006 22:20:18
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Titre:
Anyone implemented auditing?
Divers
Thread ID:
01135910
Message ID:
01135910
Vues:
59
Yikes, a new requirement.

Each table needs columns:
LastUpdatedBy (both domain users and web users (username in db))
LastUpdatedDate

Anyone implemented something like this, gathering user info in a business object save override?

[Edited]
With more thinking, it seems that the best place to set UpdatedBy stuff is in business rule code...
Add a current user property to business object...
Pass current user name to business object constructor...

[Edited]
Then again, Stephen Russell, in a 2004 post, checks for altered records in the dataset...
http://www.levelextreme.com/wconnect/wc.dll?2,15,887603
Same as Carl Olson in
http://www.levelextreme.com/wconnect/wc.dll?2,15,896730

Still, I think (not sure) that the business rule gets called once per edit, rather more efficient than looping through all the datarows. Still thinking.

Suggestions?

Thanks!
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform