Hello,
In my entity, there are several properties which I want to encrypt in the database. After loading the entity back from the database, the properties should be "automatically" decrypted, transparent for the UI and Business Layer.

I tried to use ILifecycle.OnLoad() to decrypt and ILifecycle.OnSave() / OnUpdate() to encrypt. Decrypting is not a problem and works fine.

However, if I encrypt the data using

LifecycleVeto ILifecycle.OnUpdate(ISession s) {
this.Password = CryptographyHelpers.Encrypt(this.Password); // "Password" is a string property in my entity
}


the encrypted string doesn't get persisted in the database. Instead, if I look at the database table, the Password column still has the cleartext value.

Is there any alternative approach? I'm not very experienced in using NHibernate so forgive if I overlook the obvious...

Thanks for any help
Urs

I've seen other systems where the password property is not mapped to the database but an "encrypted_password" property is. You should be able to assign the encrypted value to that (private) property on save/update. I haven't seen any that decrypt the password (all the ones I've seen use one-way encryption) but it seems you've got that handled anyway.

I have the same issue and according to the debugger, my breakpoints within Save and Update are not being hit. This is a problem with the ILifecycle interface, rather than encryption.

Is anyone familiar with the ILifecycle interface who may be able to tell us what we're doing wrong?

Use IInterceptor

http://forum.hibernate.org/viewtopic.php?p=2365882#2365882