SQL CE 4.0 "Update Database from Model"

Discussion of open issues, suggestions and bugs regarding Entity Developer - ORM modeling and code generation tool
Post Reply
sdb
Posts: 4
Joined: Sun 14 Oct 2012 12:16

SQL CE 4.0 "Update Database from Model"

Post by sdb » Sun 14 Oct 2012 12:21

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
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Re: SQL CE 4.0 "Update Database from Model"

Post by Shalex » Thu 18 Oct 2012 16:32

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).

sdb
Posts: 4
Joined: Sun 14 Oct 2012 12:16

Re: SQL CE 4.0 "Update Database from Model"

Post by sdb » Fri 19 Oct 2012 05:25

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?

Helen
Devart Team
Posts: 127
Joined: Wed 07 Sep 2011 11:54

Re: SQL CE 4.0 "Update Database from Model"

Post by Helen » Fri 19 Oct 2012 10:01

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

Helen
Devart Team
Posts: 127
Joined: Wed 07 Sep 2011 11:54

Re: SQL CE 4.0 "Update Database from Model"

Post by Helen » Mon 05 Nov 2012 09:47

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 .

Post Reply