SQL encryption (v2021)

ahmed7 · Post by **ahmed7** » Tue Feb 06, 2024 1:41 am

hello
I use v21 , my problem is when make sql server column encryption , so the column which encrypted it before be like this (System.Byte[]) in application .
So is there any way to fix that and show the origin data?
Thanks

MichaelG · Post by **MichaelG** » Tue Feb 06, 2024 7:18 am

If you encrypt by the database, you should also decrypt by the database. You can change SqlSelect in the Page_Load server event to change the SELECT SQL.

ahmed7 · Post by **ahmed7** » Tue Feb 06, 2024 3:02 pm

how cam do that please?

I found way that used with normal application which created by visual studio , they used (Column Encrypted Setting = Enabled) in appsettings.json file.
and did try it with my application which created by asp.net maker but not work.

please help me

MichaelG · Post by **MichaelG** » Wed Feb 07, 2024 7:23 am

You'd better use the FieldEncryption extension for ASP.NET Maker if you are a registered user.

ahmed7 · Post by **ahmed7** » Wed Feb 07, 2024 1:00 pm

Its free extension?

MichaelG · Post by **MichaelG** » Thu Feb 08, 2024 6:32 am

The FieldEncryption extension is for registered users only.