title: Is Microsoft dropping support for SDF database files in Visual Studio?
body: <p>In Visual Studio 2013 there is no longer an option to create <code>.sdf</code> SQL Server Compact databases in WebPages (WebMatrix) websites. I am no longer able to view <code>.sdf</code> database files in Visual Studio either. I downloaded the latest version of WebMatrix to open my <code>.sdf</code> database but WebMatrix crashes when I open my website. When I create a new empty site and add existing files, it crashes.</p>
  
  <p>I searched for days for a way to view and edit my <code>.sdf</code> database and nothing is working. I can no longer get Navicat SQL Server app to open a database. I cannot get LinqPad to open an <code>.sdf</code> database file, I cannot get Compact Viewer to open or edit <code>.sdf</code> databases. I <strong>can</strong> <em>open</em> <code>.sdf</code> databases with <code>SqlCEToolbox40.exe</code> but it only shows top 200 rows <strong>and</strong> it won't let me edit the tables.</p>
  
  <p>Now I'm completely stumped. How do I view <strong>and</strong> edit a <code>.sdf</code> database file?</p>