In SQL Server 2016 and above there is an encryption feature called Always Encrypted.
I would like to be able to use with Radzen. When try to pull the data with the encrypted column it does not work. I have set the Column Encryption Setting=enabled property in the connection stiring but that does not help.
I know it needs .net framework v4.6 or above. Since we are using Core it may not be able to.
I would like to use this feature, is it possible with Radzen?
We haven't tested that with Radzen and can't confirm if it works or not. Unfortunately I couldn't find any official documentation saying whether additional configuration is required or not.
It looks like it works and it's very simple.
On SQL Server, select the Encrypt Columns Wizard for a given column. Choose which columns you want to encrypt and whether it's a Determinstic or Randomized encryption and run the wizard.
In the Radzen application, change the connectionstring in appsettings.json to include the parameter Column Encryption Setting=enabled. You have to exclude this page so it doesn't get changed by Radzen.
Then run. It works beautifully!
Please let me know if there's any issue excluding the appsettings.json