title: User Secrets in .NET 4.7 connectionstrings format
body: <p>I have been digging for hours and keep coming up with information about .NET Core, yet hardly anything about .NET 4.7 full framework.  I figured out how to add User Secrets to the main project of my Web API solution. I get the basic secrets.xml file where I need to to either store my database username and password or my connection string. Every post I find talks about the changes you need to make to web.config. However nothing shows what to do with my connection string, how to format it, in the secrets.xml file.  I could create a name/value pair but that does not seem to do anything, my app cannot connect to the database.</p>
  
  <p>I have this in my Web.config:</p>
  
  <pre><code>  &lt;configBuilders&gt;
      &lt;builders&gt;
      &lt;add name="Secrets" userSecretsId="5c65f7eb-a7e1-46cc-bff4-a526678005f2" type="Microsoft.Configuration.ConfigurationBuilders.UserSecretsConfigBuilder, Microsoft.Configuration.ConfigurationBuilders.UserSecrets, Version=1.0.0.0, Culture=neutral" /&gt;&lt;/builders&gt;
    &lt;/configBuilders&gt;
  
    &lt;connectionStrings configBuilders="Secrets"&gt;
      &lt;add name="ShopAPDbConnectionString" connectionString="" providerName="System.Data.SqlClient" /&gt;
    &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>My secrets.xml looks like this:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="utf-8"?&gt;
  &lt;root&gt;
    &lt;secrets ver="1.0"&gt;
      &lt;secret name="ShopAPDbConnectionString" value="Server=SQLDEV01;Database=ShopAP; Integrated Security=True;" /&gt;
    &lt;/secrets&gt;
  &lt;/root&gt;
  </code></pre>
  
  <p>How do I properly format and get this to work?</p>