Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Anyone implemented auditing?
Message
From
12/07/2006 22:20:18
 
 
To
All
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Title:
Anyone implemented auditing?
Miscellaneous
Thread ID:
01135910
Message ID:
01135910
Views:
58
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!
Next
Reply
Map
View

Click here to load this message in the networking platform