I am currently overriding my entity's OnSave event as follows:

 protected override void OnSave()

            try
            {
                IEntityField field = this.Fields[(int)CreditCardFieldIndex.Pan];
                field.SetExpression(new DbFunctionCall("ENCRYPTBYCERT", new object[] { "XXX", field.CurrentValue }));
            }
            catch (Exception e)
            {
                EventLogger.LogError(e,"CreditCardEntity OnSave failed");
            }
            base.OnSave();
        } 

XXX represents the valid certificate id,

With no success, the generated SQL does not include the EncryptByCert function

We're using the LLBLGEN 2.6 runtimes, self-servicing.

Thank you

Sorry, I realized that the first parameter is also a function call, so the code should look like this:

        protected override void OnSave()
        {
            try
            {
                IEntityField field = Fields[(int)CreditCardFieldIndex.Pan];
                DbFunctionCall certId = new DbFunctionCall("CERT_ID", new object[] { "XXX" });
                field.SetExpression(new DbFunctionCall("ENCRYPTBYCERT", new object[] { certId, field.CurrentValue.ToString()  }));
            }
            catch (Exception e)
            {
                EventLogger.LogError(e,"CreditCardEntity OnSave failed");
            }
            base.OnSave();
        } 
     }

but still nothing in the generated sql ...

Thanks,

There's currently a thread going on about encryption/decryption of columns. See: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=14929