John S
John S

Reputation: 8331

Encrypted & unencrypted connection strings in web.config?

Is it possible to have both encypted and unencrypted connection strings in the same web.config?

Upvotes: 2

Views: 491

Answers (1)

GunnerL3510
GunnerL3510

Reputation: 715

I don't believe that you can encrypt an individual connection string as part of the ConnectionStrings section. This is because ConfigurationElement objects (ConnectionStringSetting derives from) has an ElementInformation Property which does not have a Protect method. A ConfigurationSection has a SectionInformation Property which does have a Protect method, ConnectionStringsSection inherits from ConfigurationSection.

So, with that said, you can encrypt a ConnectionStringsSection, but not a ConnectionStringSetting.

However, all is not lost. You do have the ability to create your sections/elements to maintain your non-encrypted (or encrytped depending on which way you want to go) connection strings. You just won't be able access them using the WebConfigurationManager's ConnectionStrings Property.

Upvotes: 4

Related Questions