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,887603Same as Carl Olson in
http://www.levelextreme.com/wconnect/wc.dll?2,15,896730Still, 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!