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?
Asked
Active
Viewed 1.0k times
7
marc_s
- 732,580
- 175
- 1,330
- 1,459
Mohammad Dayyan
- 21,578
- 41
- 164
- 232
-
1You know that SQL Compact is deprecated, right? Microsoft recommends using Express or LocalDB instead. – Aaron Bertrand Feb 04 '15 at 05:01
-
I don't wanna create a new project base on SQL Server Compact Edition. I have to read data from an `sdf` file that is old. – Mohammad Dayyan Feb 04 '15 at 05:10
1 Answers
12
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)
ErikEJ
- 40,951
- 5
- 75
- 115
-
2Open the Toolbox, go to About, and click Register DDEX, restart VS. In the Toolbox, connect to your database file. – ErikEJ Feb 04 '15 at 10:29
-
"SQL Server Compact Toolbox VS Extension" is not available in Visual Studio Express 2015 for Desktop. It is not supported. – GeoffCoope Sep 15 '15 at 13:57
-
1