How to Encrypt and Decrypt Connection Strings in .Net app.config and web.config Files

In this episode, we're going to take a look at how we can better secure our .Net configuration files for applications that have connection strings in order to talk to databases and other network resources. We can do this by encrypting the connection strings section of the app.config file. Once a section has been encrypted, you can't read it unless you decrypt it again. This video covers both encrypting and decrypting the connection string information.

Encrypting the connection information will make it unreadable. This adds some security to your deployment, as it can stop people from getting valuable credential information. It remains unreadable until someone decrypts it, but measures can be implemented to make this very difficult unless a user has certain permissions on a folder.

First, I'll show where the connection string information resides in the app.config (or web.config) file, and how we can access that information using the ConfigurationManager methods. Then, I'll demonstrate encrypting and decrypting the file. Finally, I will demonstrate how to use the app on a simple .Net application deployed in a particular folder, encrypting the connection information in it's configuration file.

  / mackenziedataanalytics  
  / seamacke  
  / seamacke  
  / psmackenzie  

Get Microsoft Office including Access:
https://click.linksynergy.com/fs-bin/...

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:
https://www.tubebuddy.com/seanmackenz...

  / seamacke  

For developers looking for a new role, check out:
https://www.toptal.com/qKaO2b/worlds-...

Want my team to do a project for you? Let's get to it!
https://buy.billzone.com/smdeprojects...

Need help on an ETL Project? Contact me today!

#dataengineering #encryptconnectionstring

   • How to Encrypt and Decrypt Connection Stri...