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
Re: SQL encryption (v2021)
Posted: Thu Feb 08, 2024 6:32 am
by MichaelG
The FieldEncryption extension is for registered users only.