title: What is the difference between those connection strings?
body: <p>I'm trying to use the visual studio - asp.net MVC login module, after some search I found that I only need to change the connection string to the SQL Server and it will create the database and the tables for me after Registration. the default connection string in the Web.config is:</p>
  
  <pre><code>&lt;connectionStrings&gt;
  &lt;add name="DefaultConnection" connectionString="Data Source=(LocalDb)\v11.0;AttachDbFilename=|DataDirectory|\aspnet-FullTest-20161219090404.mdf;Initial Catalog=aspnet-FullTest-20161219090404;Integrated Security=True"
    providerName="System.Data.SqlClient" /&gt;
  </code></pre>
  
  <p></p>
  
  <p>I don't understand that connection string and don't know what to change about it, also I know that when I connect to SQL Server, my connection string always looks like that:</p>
  
  <pre><code>&lt;add name="ProjectNameEntities" connectionString="metadata=res://*/Models.ProjectNameModel.csdl|res://*/Models.ProjectNameModel.ssdl|res://*/Models.ProjectNameModel.msl;provider=System.Data.SqlClient;provider connection string=&amp;quot;data source=.;initial catalog=DatabaseName;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework&amp;quot;" providerName="System.Data.EntityClient" /&gt;
  </code></pre>
  
  <p>So what is the difference between those connection strings? and please what I need to change in the connection string to work properly. I've tried:</p>
  
  <pre><code>&lt;add name="DefaultConnection" connectionString="metadata=res://*/Models.FullTestModel.csdl|res://*/Models.FullTestModel.ssdl|res://*/Models.FullTestModel.msl;provider=System.Data.SqlClient;provider connection string=&amp;quot;data source=.;initial catalog=FullTest;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework&amp;quot;" providerName="System.Data.EntityClient" /&gt;
  </code></pre>
  
  <p>And it is not Working. I need to understand the connection strings how they work properly.</p>
  
  <p>Thanks</p>