Page 1 of 1

SQL CE 4.0 "Update Database from Model"

Posted: Sun 14 Oct 2012 12:21
by 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

Re: SQL CE 4.0 "Update Database from Model"

Posted: Thu 18 Oct 2012 16:32
by Shalex
sdb wrote: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).

Re: SQL CE 4.0 "Update Database from Model"

Posted: Fri 19 Oct 2012 05:25
by sdb
sdb wrote:(just select it when setting up data connection properties).
Well, if it was that easy I wouldn't have asked :shock:

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?

Re: SQL CE 4.0 "Update Database from Model"

Posted: Fri 19 Oct 2012 10:01
by Helen
We have reproduced the problem.
We will fix it and inform you when the corresponding build is available.

Re: SQL CE 4.0 "Update Database from Model"

Posted: Mon 05 Nov 2012 09:47
by 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 .