Building and escaping connection strings for appsettings.json

Connection strings might contain secrets (= passwords) with a lot of special characters that need to be escaped correctly.

In addition, connection strings have to be stored in correctly escaped JSON values inside appsettings.json.

To make life easier we provide the Connection String Helper tool:

• Select a SQL Engine

• Copy & paste an unescaped Connection String into the Connection String text field

• Enter a password in the Password field

• Click Apply Password

• Connection String text field contains now an updated and correctly escaped Password

• Escaped JSON text field contains now a ConnectionString-escaped and JSON-escaped value for pasting into appsettings.json