2

I want to try using code first to connect to an existing SQL Server Compact Edition database, as described here. The tutorial however shows how to connect to a SQL Server or LocalDb.

The main problem is that I cannot add SQL Server Compact data connections from within Server Explorer:

enter image description here

The EF Powertools use this dialog to connect to the database to be reverse engineered.

I have tried re-installing SQL Server Compact 4 SP1, but that has not helped. Is there any way to install support for SQL Server CE 4 in Visual Studio 2013, or to otherwise generate code first classes from a .sdf database file without using powertools?

Spontifixus
  • 6,570
  • 9
  • 45
  • 63
Gio2k
  • 384
  • 3
  • 13

1 Answers1

1

I'm not sure there is a way to integrate it in VS 2013 at the moment but I came accross an article that may help.

Is/will there be support for SQL Server Compact in Visual Studio 2013?

It looks like there is a toolbox that can be used to set up your connection strings and design / modify your tables and so fourth. I've even found that you can create LINQ to SQL. You may also convert Primary Database files to Compact edition DB files as well.

Here is a direct link...

SQL Server Compact Toolbox

Cody Hicks
  • 420
  • 9
  • 24