title: Logging / Tracking CRUD operations in MVC application
body: <p>I want to save all of the CRUD operations with the user's detail to the database and then monitor these info according to the following approach below. In my opinion, the second approach seems better so that it can be managed from one specific table and can also be used for the critical info. So, could you please clarify me by giving an applicable example on how to perform this best in both cases with a framework or a custom code that is suitable for MVC5 and MsSQL Server? Thanks in advance.</p>
  
  <p><strong>Approach I:</strong> By adding "CreatedBy", "CreatedOn", etc. columns to the related tables and add/update the info ("CreatedBy", "CreatedOn", etc.) on these tables whenever a records is added or updated. In that case only the last update info will be obtained from the database and the prior operations cannot be obtained.
  <br/>
  <br/>
  <strong>Approach II:</strong> By creating a new table in the database and add a new record for every CRUD operation containing "CreatedBy", "CreatedOn", "Controller", "Action", "Record Id", "Upadte Value", and the other necessary fields.
  <br/></p>