title: Store the changes done to database in Entity Framework
body: <p>I want to store the changes done to database in a structure or something so that I can refer them anytime after the database context is over. I am using Entity Framework in C#  and underlying database in SQL Server. </p>
  
  <p>The information that I want to store is </p>
  
  <ul>
  <li>The executing database context</li>
  <li>The table name </li>
  <li>Previous value of updated column</li>
  <li>New value of updated column</li>
  <li>Id of row added or deleted. </li>
  <li>operation performed( update or delete or add ) </li>
  </ul>
  
  <p>Currently I am storing them in form of string. But the problem is, using this approach I can not reproduce the linq query so that I can revert the changes. </p>
  
  <p>How shall I proceed in this case. Thanks in advance. </p>