title: ASP.NET MVC how to connect to SQL Server and create new database?
body: <p>I'm learning this tutorial: <a href="http://www.codeproject.com/Articles/986730/Learn-MVC-Project-in-days-Day" rel="nofollow noreferrer">http://www.codeproject.com/Articles/986730/Learn-MVC-Project-in-days-Day</a></p>
  
  <p>I have problem with day 3 in first step - Step 1 – Create Database. I don't know how do this.</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>Ok, I added this DB, this is the tree in SQL Server Object Explorer
  <a href="https://i.stack.imgur.com/tJL8h.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tJL8h.png" alt="enter image description here"></a>
  I have an error:</p>
  
  <blockquote>
    <p>An exception of type 'System.Data.SqlClient.SqlException' occurred in EntityFramework.dll but was not handled in user code</p>
  </blockquote>
  
  <p>in return</p>
  
  <pre><code>public List&lt;Employee&gt; GetEmployees()
      {
          SalesERPDAL salesDal = new SalesERPDAL();
          return salesDal.Employees.ToList();
      }
  </code></pre>
  
  <p>This is my connectionString</p>
  
  <pre><code>&lt;connectionStrings&gt;
      &lt;add connectionString="Data Source=(LocalDb);Initial Catalog=SalesERPDB;Integrated Security=True"
              name="SalesERPDAL"
              providerName="System.Data.SqlClient"/&gt;
  &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>I added DB in App_Data project folder</p>