Always Encrypted column - LINQ query Equals not working

Question

I have encrypted SSN column using Always Encrypted feature in SQL server 2016. When I try to get the encrypted column in LINQ I always get error. I tried equals and contains but got the same error.

Query = Query.Where(t => t.SSN == InputSSN);

The data types char(9) encrypted with (encryption_type = 'DETERMINISTIC', encryption_algorithm_name = 'AEAD_AES_256_CBC_HMAC_SHA_256',..are incompatible in the equal to operator. Statement(s) could not be prepared.

SSN,InputSSN - string in DB - SSN CHar(9) Latin1_General_BIN2

have you added Column Encryption Setting=Enabled to you connection string? — Liviu Boboia, Apr 04 '17 at 06:28

Windows10 · Accepted Answer · 2017-04-04T19:29:35.403

0

have changed the datatype in table and it worked.

edited Apr 04 '17 at 19:29

answered Apr 04 '17 at 14:49

Windows10

51
9

1

Curious what did you change the datatype from -> to? – Lukie May 23 '17 at 08:18

Always Encrypted column - LINQ query Equals not working

1 Answers1

Linked