title: Encrypted columns with Entity Framework
body: <p>Anyone figured out a good way to pull encrypted values from db through entity framework 4?</p>
  
  <p>I got a MySql db with some columns encrypted with des_encrypt and need to be able to get those values as easy as possible, and also of course, update and insert them.</p>
  
  <p>I think it's quite strange there doesn't seem to be in built support for this in EF. Even our own built ORM-system have support for this. We just add a comment "encrypted" for each field thats encrypted and the ORM tool will add des_decrypt(column) and des_encrypt(column) in the queries.</p>
  
  <p>Anyone?</p>