Encrypt column data with LINQ

asp.net, c#, linq, linq-to-sql, sql-server

Solution

You could add a partial class with a property encapsulating this logic like:

public partial class DbTableItem
{
  public String UnencryptedPass
  {
    get
    {
       return  Crypter.Decrypt(this.Pass);
    }

    set
    {
       this.Pass = Crypter.Encrypt(value)
    }
  }
}

Hope it helps : )

Problem

I was wondering if there is easy solution to this or I'm stuck with following: When updating DB: ``` dti.Pass = Crypter.Encrypt(dti.Pass); _db.SubmitChanges(); ``` When selecting from DB: ``` Data.DbTableItem dti = _db.Single(a=>a.Id == id); dti.Pass = Crypter.Decrypt(dti.Pass); ``` Meaning - I am not really into writing repetitive code and this seems like logical thing to be supported by LINQ; so I'm wondering if it is.

Original source