How To Decrypt the Data at the Database level using the Same Key used in EF

[uppercuut]

No description provided.

[mmhafner]

Good question

[Xor-el]

if you wish to decrypt data already encrypted in the DB, you can try the approach suggested here.
I have no idea if it would work though.

However, if you need EFCore to do the decryption on the DB level, that won't happen as the encryption/decryption with this library works as a value converter and is done at the EFCore layer, not the DB one.
What this means is that filtering on an encrypted column using EFCore will always pull the data to the client side before decrypting and then filtering.