title: LocalDB location
body: <p>I'm using LocalDB and Entity Framework code-first for a new project. I want to change the location where the database is created/saved. However, every time I do, I get one of any number of exceptions. If I try adding <code>AttachDBFilename=|DataDirectory|\database.mdf</code>, I get an exception stating:</p>
  
  <blockquote>
    <p>The underlying provider failed on Open.</p>
  </blockquote>
  
  <p>As well as:</p>
  
  <blockquote>
    <p>Cannot attach the file 'C:\Projects\database.mdf' as database 'Schema.MyProject'.</p>
  </blockquote>
  
  <p>Eventually, when I run this program on another computer, I'm looking to create/save the database in the AppData folder. How can this be done?</p>