I have set up column encryption(Always Encrypted) at my sql server side. I have a C++ client and am trying to insert values into the encrypted database columns. I am able to do so, if I used parameters in my query string just as how we can do from SSMS when column encryption flags are set. After going through some documentation, I get the feeling that using parameterised query is not required from a client application and that whatever normal query was existing should work as it is. Most of the client samples however seem to be that of c# implementations that use ADO.net
I have two queries:
- Do I need to use parameterised query string from my C++ client?
- Is non parameterised query only supported in c# clients (assuming this feature has some dependency with .Net).