Logging DML operations in ASP NET MVC project

Question

There are several ways to log dml activities like as insert, update, and delete in an asp.net mvc project. I'm not sure if using aspects in code, triggers, or CDC in the database server is more useful, or if there are other, more logical options.