NHibernate and SQL Server 2008 encryption

How to per开发者_JS百科form SQL Server built-in encryption/decryption with NHibernate? I mean encryption of separate columns.

[EDIT] Sorry, missed your "SQL built-in" mention. This is not SQL built-in, this is NHibernate "integrated".

But could be an option of what you're trying to achieve.

This can be done by using a UserType.

You can find this explained in detail here: http://gustavoringel.blogspot.be/2009/02/encrypting-password-or-other-strings-in.html

And fully implemeted here: https://code.google.com/p/unhaddins/source/browse/uNhAddIns/uNhAddIns/UserTypes/EncryptedString.cs?r=65faefa249b695c97787f46f28e6c775a0601533