SQL Ce 4.0 Local Cache Agent?! EF Support?

Question

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 asyncone 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?

Answer 1

Hi Christian Loth,

To synchronize data between SQL Server Compact 4.0 and SQL Server, you may have a look at Remote Data Access (RDA). For more information, please pay attention to ErikEJ’s blog about this topic: Snapshot Synchronization with SQL Server Compact 4.0.

---

Stephanie Lv

TechNet Community Support

Answer 2

Vote this http://data.uservoice.com/forums/72025-entity-framework-feature-suggestions/suggestions/2792403-sql-ce-4-0-local-cache-agent

Thanks

Answer 3

You can make Sync Framework work with 4.0, see this blog post: http://jtabadero.wordpress.com/2012/04/20/sync-framework-and-sql-compact-4-yes-you-can/

---

Please mark as answer, if this was it. Visit my SQL Server Compact blog