SQL CE 4.0 "Update Database from Model"

[sdb]

Hi,

is there any way to work with SQL Compact 4.0? Other than creating a 3.5 sdf an afterwards upgrade it to 4.0? I'm working with Entity Designer 4.6

Sam

[Shalex]

is there any way to work with SQL Compact 4.0?

You can work with SQL Compact 4.0 via Entity Developer if any ADO.NET provider which supports SQL Compact 4.0 is installed on your workstation (just select it when setting up data connection properties).

[sdb]

(just select it when setting up data connection properties).

Well, if it was that easy I wouldn't have asked

I'm working with VS 2012, CE 4.0 is installed and i can connect and work with a 4.0 database. Meanwhile I've updated to Entity Developer 4.7.

The trouble is, that I cannot select SQL CE 4.0 in Entity Developer and thus have to copy & paste sql scripts manually in order to execute them on my SQL CE 4.0 database. Any further idea?

[Helen]

We have reproduced the problem.
We will fix it and inform you when the corresponding build is available.

[Helen]

The bug with the exception being thrown when connecting to SQL Server Compact 4.0 is fixed (for Entity Framework and NHibernate models).

New build of Entity Developer 4.7.295 is available for download.
It can be downloaded from http://www.devart.com/entitydeveloper/download.html (trial version) or from Registered Users' Area (for users with valid subscription only) .

For more information, please refer to http://forums.devart.com/viewtopic.php?f=32&t=25200 .