title: .mdf" failed with the operating system error 2(The system cannot find the file specified.)
body: <pre><code>    protected void register_Click(object sender, EventArgs e)
      {
          AddUser(userName.Text, password.Text, confirm.Text);
      }
  
      void AddUser(string name, string pass, string confirm)
      {
          User u = new User(name, pass, confirm);
  
          if (u.Valid)
          {
              using (var db  = new SiteContext())
              {
                  db.User.Add(u);
                  db.SaveChanges(); 
              }
          }
      }
  }
  
  public class User 
  {
      public int UserId { get; set; }
      public string UserName { get; set; }
      public string Password { get; set; }
      public bool Valid { get; set; }
  
      public User(string _name,string _password,string _confirm)
      {
          if (CheckPassword(_password, _confirm))
          {
              Password = _password;
              UserName = _name;
              Valid = true;
          }
          else
              Valid = false;
      }
  
      private bool CheckPassword(string _password, string _confirm)
      {
          if (_confirm.Equals(_confirm))
              return true;
          return false;
      }
  }
  
  public class SiteContext : DbContext 
  {
      public DbSet&lt;User&gt; User { get; set; }
  }
  </code></pre>
  
  <p>I am trying to create a new database using Entity Framework but I always getting that exception</p>
  
  <blockquote>
    <p>Directory lookup for the file "c:\users\oren\documents\visual studio 2012\Projects\ResturantSite\ResturantSite\App_Data\ResturantSite.SiteContext.mdf" failed with the operating system error 2(The system cannot find the file specified.).<br>
    CREATE DATABASE failed. Some file names listed could not be created. Check related errors</p>
    
    <p>Line 28:                 using (var db  = new SiteContext())<br>
    Line 29:                 {<br>
    Line 30:                     db.User.Add(u);<br>
    Line 31:                     db.SaveChanges();<br>
    Line 32:                 }  </p>
  </blockquote>
  
  <p>Line 30 throws the exception</p>
  
  <p>I hope somebody can help</p>