title: SQL Server 2008 R2 Encryption - with Entity Framework
body: <p>I'm looking to use database encryption on the database I connect to in my application via. Entity Framework.</p>
  
  <p>Is there an easy way / best practice to be able to get the unencrypted data &amp; write encrypted data back to the database. I don't particularly want to have to edit the edmx xml manually, but am struggling to find some resources that will tell me how to achieve this.</p>
  
  <p>I am planning to use Symmetric Key and the triple DES encryption algorithm.</p>