Ideas, Tips, Tools, Framework for implementing Audit [closed]

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

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.