Adding SQL Server Compact Edition data source to Visual Studio?

Question

I want to add a SQL Server Compact edition in my project in Visual Studio 2013.4, but I don't have the data source in my list:

Also, I don't have System.Data.Sqlce in my assemblies.

How can I add SQL Server Compact data source to my Visual Studio?

Answer 1

1: Install the relevant runtime MSI (3.5 SP2 or 4.0) http://www.microsoft.com/en-us/download/details.aspx?id=5783 http://www.microsoft.com/en-us/download/details.aspx?id=30709

2: Install the SQL Server Compact Toolbox VS Extension, and browse to the database file, it will also add the connection to Server Explorer (if you really need that)