Visual Studio 2013 has no SQL Server CE Data Provider

Question

I would like create an ADO.NET Entity Model from an existing SQL Server CE database. But when I want to Generate Database from Model, there is no list of SQLite provider. Only have the ones for SQL Server. I have installed the SQL Server Compact Toolbox and the sqlite-netFx45-setup-bundle-x86-2012-1.0.89.0.exe already. What is wrong! Did I miss something?

thanks, stevo

Answer 1

You're right, it's not there. If you'd like to regain the SQLServerCE functionality on your VS2013 you can install the SQL Server Compact Toolbox:

http://visualstudiogallery.msdn.microsoft.com/0e313dfd-be80-4afb-b5e9-6e74d369f7a1