encrypting appSettings in a external file using aspnet_regii

Question

I am trying to encrypting appSettings in a external file using aspnet_regiis -pef. Does anyone how how to do this.

 

My main web config file :

<appSettings file="ExternalAppSettings.config">

<add key="test1" value="val1" />

<add key="test2" value="val2" />

</appSettings>

 

 

external file ExternalAppSettings.config

 

<appSettings>

<add key="pwd1" value="test1" />

<add key="pwd2" value="test2" />

</appSettings>

 

I want to encrypt only appsetting in ExternalAppSettings.config how to do this ?

Answer 1

Hi,

I don't think it is possible to achieve what you are looking with a single select query.

You won't get distinct from every columns while selecting multiple columns. Because distinct keyword considers whether a single row is distinct or not. Not a column. Please have a look at below link -

http://dba.stackexchange.com/questions/102677/select-distinct-on-multiple-columns

Answer 2

your logic is true

could you post the screenshots of the table with data