How to encrypt a Oracle password in app.config in C# app
Posted on 2011-02-24
I am working on a .NET console application using C#. In order for the console app to open a connection to the oracle database, the following conection string was setup in the "app.config" file of the console app.
<add name="ABCReceiveData.Properties.Settings.TTT1" connectionString="Data Source=ttt1;Persist Security Info=True;User ID=johndoe;Password=xxxxj$;Unicode=True"
With the above approach the password is saved in clear text in the config file, I do not want that .. I like to encrypt it. I do not know how .. appreciate if someone shares a sample on how to do it.