>>I'm unhappy with most of the choices right now.
>>
>>SQL Lite was not upgraded for 4.0 last I saw.
>>CE 3.5 No support for Identity Columns.
>>CE 4.0 Supports Identity Columns but EF cannot generate entities from the database.
>
>Are you sure? I could swear I just tried that and the EF wizard created the entities perfectly including relationships and cascading deletes.....
Have to admit, I haven't tried it:
I got that impression from this and didn't bother to go any further.
http://blogs.msdn.com/b/sqlservercompact/archive/2011/03/15/sql-server-compact-4-0-tooling-support-in-visual-studio-2010-sp1-and-visual-web-developer-express-2010-sp1.aspxVisual Studio Designers that do not work with SQL Server Compact 4.0
The following wizards do not work with Compact 4.0 in the Windows project system. Developers can manually add reference to the ADO.NET provider for Compact 4.0 (System.Data.SqlServerCe) to develop programs for Compact 4.0 in the Windows projects:
- The Data Source Configuration Wizard that is used to configure datasets.
- The Configure Data Configuration wizard that is used to setup the syncing of data and schema with SQL Server using Sync FX
- The Entity Data Model wizard that is used to generate entities from a Compact database.