First published on MSDN on Aug 27, 2015
Entity Framework 6 was not designed from the start to work with the Always Encrypted feature of SQL Server 2016. However, a lot of effort...
Updated Mar 23, 2019
Version 2.0
Blog Post
I'm trying to get this to work and having some trouble. I've provisioned the master key and encryption key. I've added the Column Encryption Setting to my connection string, But when I try to Add to the table I get the following exception:
SqlException: Operand type clash: nvarchar(max) 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 = 'TestAlwaysEncryptDb') is incompatible with nvarchar(128) 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 = 'TestAlwaysEncryptDb')
Statement(s) could not be prepared.
I've tried downloading the zip of the source code, but it doesn't even include the migration to enable encryption. Please advise.