title: WPF Application with SQL Server Express database deployment in production environment
body: <p>I have a WPF application where I use Entity Framework for interacting with the database that is on SQL Server Express on my machine. I'm reasoning on small projects where data will not be huge and then I don't want to install SQL Server Express on client's machine for two reasons:</p>
  
  <ol>
  <li>installation takes a long time   </li>
  <li>these projects must be executable on computers with low hardware specs (installation of SQL Server takes too much time)</li>
  </ol>
  
  <p>I tried installing LocalDB on client machine, created default instance and started</p>
  
  <p>The problems are two:</p>
  
  <ol>
  <li><p>how to reconfigure <code>app.config</code> file making Entity Framework connecting to database? (in development environment connection string is SQL Server style)  </p></li>
  <li><p>where to put database files? (user's profile root?)</p></li>
  </ol>
  
  <p>Am I following the correct way? I know only two way to do this, installing SQL Server Express or using LocalDB the may be a third way?</p>