Is Always Encrypted supported in LLBLGen version 4.2 connecting to SQL 2017?
I ran a test by adding "Column Encryption Setting=enabled" to my connection string and encrypting a column on the database. The column is decrypted through SSMS but when attempting to access the data I get the following error:
System.Data.SqlClient.SqlException
HResult=0x80131904
Message=Operand type clash: nvarchar(255) encrypted with (encryption_type = 'DETERMINISTIC', encryption_algorithm_name = 'AEAD_AES_256_CBC_HMAC_SHA_256', column_encryption_key_name = 'CEK_Auto1', column_encryption_key_database_name = 'xxx') is incompatible with nvarchar
Statement(s) could not be prepared.
Source=.Net SqlClient Data Provider
StackTrace:
<Cannot evaluate the exception stack trace>
The post at https://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=24102 suggests that there should be compatibility as only the connection string needs to change.