I'm currently trying to have Blockkk (
www.blockkk.com) as my database encryption. As I know from Blockkk, the decrypted session will only remain active within a single active session, and the SQL Statement below is required to execute in the context of the protected database.
Example :
OPEN SYMMETRIC KEY Blockkk DECRYPTION BY PASSWORD='YourEncryptionPassword'
I have few hundred lines of SQL Queries in my application already, therefore is kind of difficult for me to rewrite again. Is there any way that I could actually add the SQL Query in MM.NET, right after a connection is opened? Perhaps before the business object?
Kindly advise and appreciate for the help! Thanks in advance. =)