hi
i need to get all login action history after user login and store it into database. this login history will be recorded only for data manipulatin events like insert, delete and modify. for example if user add customer then besides the save function i write a function to store action of addcustomer in database.i am following n-layer architecture and project is not small.
my trouble is that should i write a function and call it wherever necessary in project to write action details or should i write trigger for my each table which when data change write record in particular table.
please guide.

thanks......

__________________
thanks......

Probably the best way to do this would be to set up a custom event, which would only take one line to fire whenever needed. You can log custom events using ASP.NET Health Monitoring.

A full explanation is way beyond the scope of a forum post, but there is a detailed explanation in the following Wrox book:

http://www.wrox.com/WileyCDA/WroxTit...764584642.html


_________________________________

Visit my blog at http://leedumond.com