title: DateCreated or Modified Column - Entity Framework or using triggers on SQL Server
body: <p>After I read one question in attached link, I got a sense of how to set DateCreated and DateModified columns in Entity Framework and use it in my application.  In the old SQL way though, the trigger way is more popular because is more secure from DBA point of view.  </p>
  
  <p>So any advice on which way is the best practice? should it be set in entity framework for the purpose of application integrity? or should use trigger as it make more sense from data security point of view? Or is there a way to compose trigger in entity framework? Thanks. </p>
  
  <p><a href="https://stackoverflow.com/questions/8772566/ef-codefirst-rails-style-created-and-modified-columns?answertab=active#tab-top">EF CodeFirst: Rails-style created and modified columns</a></p>
  
  <p>BTW, even though it doesn't matter much, I am building this app using ASP.NET MVC C#. </p>