Ideas, Tips, Tools, Framework for implementing Audit

Question

I'm looking for Ideas, Tips, Existing Frameworks (based on .NET), Tools and also your experience on what's the best way to implement a good Audit Trail.

Our typical Applications are nothing fancy ASP.NET MVC 3- Security Layer - Business Layer - Data Access Layer - Database (SQL Server 2008)

My only requirement is that it has to be easy to implement and stored somehow in the Database.

Answer 1

I've found some nice tools like OmniAudit etc, but not actually exactly was i was looking for. So i've decided to write my own Audit Trail Tool to generate and maintain Triggers.

Answer 2

For auditing user actions, I had used Log4Net. While for auditing CRUD operations, triggers were used.

Here you could find some resource articles(Article1, Article2) on implementing Audit log.

Answer 3

if you're using entity framework, please refer to: http://www.codeproject.com/KB/database/ImplAudingTrailUsingEFP1.aspx