Page 1 of 1

SQL encryption (v2021)

Posted: Tue Feb 06, 2024 1:41 am
by ahmed7

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


Re: sql encryption

Posted: Tue Feb 06, 2024 7:18 am
by MichaelG

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.


Re: sql encryption

Posted: Tue Feb 06, 2024 3:02 pm
by ahmed7

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


Re: sql encryption

Posted: Wed Feb 07, 2024 7:23 am
by MichaelG

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


Re: sql encryption

Posted: Wed Feb 07, 2024 1:00 pm
by ahmed7

Its free extension?


Re: SQL encryption (v2021)

Posted: Thu Feb 08, 2024 6:32 am
by MichaelG

The FieldEncryption extension is for registered users only.