A number of SQL Compact 3.5 hot fixes have been released recently and are publicly available at the Microsoft support site. The table below gives an overview of the hotfixes. Note that the hotfixes are cumulative, meaning that the latest hotfix contains all previous hotfixes. Some hotfixes are only applicable for a particular platform, however. All hotfixes apply to SQL Compact 3.5 SP1, version 3.5.5692.0.
The number column indicates the revision number, so 7 would be version 3.5.5692.7 and so on.
|1||958478||Error message when you run a "LINQ to Entities" query that uses a string parameter or a binary parameter against a SQL Server Compact 3.5 database: "The ntext and image data types cannot be used in WHERE, HAVING, GROUP BY, ON, or IN clauses"||x86, x64|
|2||959697||Error message when you try to open a database file from a CD in SQL Server Compact 3.5 with Service Pack 1: "Internal Error using read only database file"||x86|
|3||963060||An error message is logged, and the synchronization may take a long time to finish when you synchronize a merge replication that contains a SQL Server Compact 3.5 subscriber: "UpdateStatistics Start app=<UserAppName>.exe" |
UPDATE: More info about required code changes and new api here
|x86, wce4, wce4-ppc, wce5, wce5-ppc|
|5||967963||Some rows are deleted when you repair a database by using the Repair method together with the RepairOption.RecoverCorruptedRows option in SQL Server 2005 Compact Edition and in SQL Server Compact 3.5||wce5, wce5-ppc|
|7||968864||Error message when you run a query in SQL Server Compact 3.5: "The column name cannot be resolved to a table. Specify the table to which the column belongs"||x86, wce5-ppc, wce5-phone|
FIX: Non-convergence occurs when you synchronize a SQL Server Compact 3.5 client database with the server by using Sync Services for ADO.NET in a Hub-And-Spoke configuration
|Same fix as above|
|9||970269||FIX: Access violations occur when you run an application under heavy load conditions after you install the 64-bit version SQL Server Compact 3.5 Service Pack 1||x64|
|11||970414||FIX: Initial synchronization of a replication to SQL Server Compact 3.5 subscribers takes significant time to finish||wce4-ppc, wce5-ppc|
You do not receive error messages when you run a query in a managed application that returns columns of invalid values in SQL Server Compact 3.5
|12||971027||FIX: Error message when you upgrade a very large database to SQL Server Compact 3.5: "The database file is larger than the configured maximum database size. This setting takes effect on the first concurrent database connection only"||x86, x64|
|12||972002||FIX: Error message when you try to create an encrypted database in SQL Server Compact 3.5: "The operating system does not support encryption"||x86|
|13||972390||FIX: The application enters into an infinite loop when you run an application that uses Microsoft Synchronization Services for ADO.NET to synchronize a SQL Server Compact 3.5 database½||x86|
|14||974068||FIX: Error message when an application inserts a value into a foreign key column in SQL Server Compact 3.5: "No key matching the described characteristics could be found within the current range"||x86, x64|
Please let me know if there are errors or omissions.