>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. =)
I may be overreaching my skill level here, since I have not worked with any encryption program, but have you looked at ExecSProc and ExecSProcScalar? They are methods on the MM biz object.