Always Encrypted - SQL Server

1

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?

Thanks

John W

2

Hi John,

It seems that this feature isn't supported in .NET Core yet.

3

From the thread it appears others are fond of Always Encrypted as well.

Nice feature and it is too bad .Net Core does not support it. Maybe someday.

4

Hi, it looks like Always Encrypted is now supported by .Net Core, just confirming that this means we are now able to use it through Radzen as well?

5

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.

6

Ok thanks. I may take a crack at this if I get the time,cause it would definitely be a bonus to be able to present to my clients.

7

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

1 Like