title: SQL Server CE and Visual Studio 2013
body: <p>So we now know that SQL Server CE is no longer supported with Visual Studio 2013. We can get some access to it via the SQL Server CE Toolbox add-in, but this does not fix the fact that a data provider is not included and thus we can no longer use SQL Server CE with Entity Framework etc. </p>
  
  <p>I haven't yet found an explanation from MS as to why this is now missing, but I've accepted it for now and am looking for ways to move on. </p>
  
  <p>My question is - what is the best migration path for this? I've been using data-first Entity Framework with SQL Server CE, and deploying small websites that use a small <code>.sdf</code> file for the database, and updates are simple to deploy - just copy the file over. SQL Server Express won't work this way. For desktop/WPF/winforms apps I imagine this is even more confusing, as the in-process SQL Server CE database was a great fit for small desktop applications.</p>