title: How to connect to SQL Server using ASP.NET MVC web application?
body: <p>I want to connect to SQL Server from my ASP.NET MVC application in Visual Studio. I type the following connection string in the <code>web.config</code> file:</p>
  
  <pre><code>&lt;connectionStrings&gt;
     &lt;add name="EmploymentDbContext" 
          connectionString="Data Source=ASD-PC\SQLEXPRESS;Initial Catalog=EmploymentsHistory;Integrated Security=SSPI ;" 
          providerName="System.Data.SqlClient"/&gt;
  &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>My server name is <code>ASD-PC\SQLEXPRESS</code> and I use Windows Authentication to connect to SQL Server. </p>
  
  <p>When I run the ASP.NET MVC project the project runs with success but the database <code>EmploymentsHistory</code> isn't there. How to fix that?</p>