NB I’m using VS on the same machine as the SQL Server instance so didn’t need to do any of the certificate exporting.
I’m confident updates could be easily done via .NET as well.
Lots of question remain however, such as…
What happens when you move the database via backup/restore?
If I run the .NET code on another machine will it work?
Do we need to export keys from here to there to get stuff to work?
I took your idea and bought CapeSoft CryptoNite, follow the sample JustOneField.tps in FILE AND FIELD ENCRYPTION program, it works. But how to search the indexed ebcryption field? Even the “get” command does not work. Do you know why? Thank you!
I think the idea is that the data is encrypted, so you will not be able to search on encrypted data.
If you have to do a search, maybe read the values into an In-Memory table - decrypting them before adding it into the memory table and then do search in the memory table. But this will only be viable if you have a smallish number of records.
Thank you to answer my question.
But the instruction of the capesoft Cryptonite said:
" Tables To Encrypt
A list containing the tables which contain encrypted fields.
Fields in the table which will be encrypted. Note that encrypting fields which are used in Keys can lead to problems. Since keys are used to sort data in the table, if you encrypt key fields then the key is sorted by encrypted value, not actual value. This means that you cannot do a SET/NEXT loop through a table using a encrypted field, and Browses cannot use column-sorting on encrypted fields. You can still do a GET on encrypted keys."