CODEWITHSUNDEEP
sql-serversql-server-2008entity-frameworkentity-framework-4sql-server-ce
danbord
danbord

Reputation: 4096

SQL Server Compact 4.0 Provider is not in list for EF

My WPF application uses Entity Framework 4.0 with a SQL Server CE database. And I need to have SQL Server CE 4.0 to allow the @@IDENTITY columns to be server generated.

So I just installed SQL Server Compact 4.0 on my system, but I cannot create a SQL Server CE 4.0 database since its not in the list when I choose a data source from VS2010.

enter image description here

I wonder why because in the Windows programs list SQL Server CE 4.0 is there :

enter image description here

Any idea?

Upvotes: 1

Views: 1235

Answers (1)

Erik Philips
Erik Philips

Reputation: 54638

You need to install the Visual Studio Tools for SQL Server Compact 4

Then you get:

enter image description here

Upvotes: 3

Related Questions