>>>>>>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.aspx>>>>
>>>>Visual 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.
>>>
>>>Ah. I was working in a ASP.NET/Silverlight environment. Is it that (for some reason) the exclusions only apply to Winforms projects:
>>>"The following wizards do not work with Compact 4.0 in the
Windows project system"
>>>
>>>UPDATE : That said, I tried creating a WinForms project. When adding an 'ADO.NET Entity Model' the existing CE connection showed up as an option and, using that, the EDMX was created normally.......
>>
>>Can you run the update model from database wizard?
>
>Seems so. I added a table to the DB using SSMS then ran the 'Update from Database' which allowed me to add the new table to the EntitySets......
Cool, thanks for checking that for me, I'll have to download it and try it.
