SQL CE targets occasionally connected applications and applications.
It includes both 32-bit and 64-bit native support. We recommend that you test hotfixes before you deploy them in a production environment. Prior to the introduction of the desktop platform, it was known as SQL Server for Windows CE and SQL Server Mobile Edition. Cumulative update package 7 for SQL Server Compact 3.5 Service Pack 2 contains hotfixes for issues that were fixed after the release of Microsoft SQL Server Compact 3.5 Service Pack 2 (SP2). IF you want to review or change any your installation settings, click Back. Microsoft SQL Server Compact (SQL CE) is a compact relational database produced by Microsoft for applications that run on mobile devices and desktops.
The nuget package EntityFramework.SqlServerCompact seems to only reference Sql Compact 4 in all its versions. Microsoft SQL Server Compact 3.5 SP2 ENU Ready to Install the Program Setup is ready to begin installation. There is also a table here that allows you to determine which Transact-SQL commands, features, and data types are supported by SQL Server Compact 3.5 (which are the same a 4.0 with very few exceptions), compared with SQL Server 20. This makes sense and points me to the realization that what I need is a provider for Entity Framework 6 for Sql Server CE 3.5 SP2. In order to use this feature, you should use SQL Server Compact 3.5 SP2 version. SQL Server Compact 4.0 does not support data replication with SQL Server using Sync Framework, merge replication or remote data access (RDA).
Procedural T-SQL – Select Case, If, features SQL Server Compact 3.5 SP2 is the appropriate version for using the following features. Runs on Windows Mobile / Windows Phone platform Privately installed, embedded, with the application