Hi,

Anyone with experience of working with SQL 2005 and encryption at the DB level using PKI, cert or symmetrical keys? Are there any implications when working with SQL encryption and LLBLGen?

Byron

I'd be interested in this too - I'd like to be able to store encrypted credit card information. Anyone have experience of this?

I have looked around these forums and not found much - I appreciate that any basic encryption will not be fool proof but it would be better than none!

If you want to store cc info encrypted, first encrypt the cc info, then store it in an entity field.

That's more efficient than using encryption on a db. Encryption on the DB level, thus encrypting and decrypting on the DB, isn't build in, you've to create that with DBFunctionCalls but it's cumbersome. What I'd do is encrypt/decrypt on the entity level, eventually adding a property in a partial class which encrypts/decrypts a value of an entity field using a certificate.