Hy, im evaluating how to implement Audit trail in a multi-tier ASP.NET 3.5 Database driven Webapplication based on nettiers and SQL-Server 2008.

I read a lot about the subject, but im still not sure whats the easiest way to do it.

Is it possible at all to implement it (without refactoring everything) with the entity framework if the rest of the application never used the EF? (There is already an OR-Mapper used..)
Or do you guys think, that triggers would do the job just fine?

Ah, and a 2nd question: Do I get this right, that frameworks like log4net are just for logging debug-infos and not for audittrail?


thanx a lot for any input!


Andreas