SQL CE provider with both local cache agent and database generated identities support
Is there a possibility in the near future provide a SQL Server Compact 4.0 DB to synchronize with SQL Server, unfortunately, offers some of the SyncFramework for this version at no SyncCeProvider .... and the opportunity to work with a local cache async one is also forbidden, because it is supported only in version 3.5.
Unfortunately, I am clueless and if needed an alternative offered by the DB once support for the Entity Framework and the Local Cache Agent.
The version of SQL Compact 3.5 would work but unfortunately I have the problem that the auto-increment columns are not generated ..... too bad someone has an alternative suggestion?
The new SQL CE legacy provider added to EF6 can both work with store generated identities and with the SQL CE 3.5 that supports synchronization with SQL Server.
AdminDiego Vega (Admin, DataFx) commented
While we cannot add support for Sync Framework to SQL CE 4.0, ErikEJ is right: the SQL CE 3.5 provider that he contributed to EF 6 should address the scenario. I am renaming the idea to reflect what I think the actual goal is and will mark the idea as completed. Thanks Erik!
The new SqlServerCompact.Legacy provider Works with ef6 and supports server generated keys