Link to home
Start Free TrialLog in
Avatar of Easwaran Paramasivam
Easwaran ParamasivamFlag for India

asked on

How to implement Auditing in ASP.NET Application.

User performs some operation say for example Place an order, Delete an order and so on.
 
How to implement Auditing?

If you provide sample application that could be grateful. Thanks.
SOLUTION
Avatar of Padre_Corleone
Padre_Corleone
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Easwaran Paramasivam

ASKER

Thanks. How would you access logged in username in trigger.?
I recommend passing the user I'd when changing data back to the database. By the userid you can get the username incase you need to have a page that displays all the relevant information with actions.
But for triggers we could not pass parameters. Isn't it? How to tackle this situation?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I've seen the above article. That is nice.

They asked to store the username in a Session variable and read latter in Trigger. What about multiple users logged in the application at the same time? How to handle that case?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks.