For x64 system with SQL Compact, it is required that both the x86 and x64 runtimes are installed, see this KB for more info. So how can your installer detect if any of these versions are installed: by looking in the registry. Disclaimer: I am guessing some of this, as no documentation is currently available!
SQL Server Compact 3.5 SP2 beta is available for download for x86 and x64 (no Windows Mobile yet) here: and is also included with Visual Studio 2010 beta 2. I will try to update this blog entry as more information becomes available.
C: Program Files Microsoft SQL Server Compact Edition v3.5 dll Versions are 3.5.8080.0 I can make the database available, its pretty small. Here is the query if it helps.
Notice that the installation of 3.5 SP2 beta upgrades a 3.5 and 3.5 SP1 installation. Also, this is beta software, so use at your own risk! Firstly, 3.5 SP2 beta includes all the hotfixes, that has been released for 3.5 SP1, as listed by me. The SQL Compact 3.5 folder look like this after installation: Notice the “Private” folder, which contains a version of System.Data.SqlServerCe.Dll which should be used for private deployments, to prevent the “Assembly probing” issue described in. The problem is, that even if you are using a hotfixed version of SQL Compact in your application folder, assembly probing will load the GAC deployed version, which may or may not be hotfixed. This means that the deployment of a hotfix always must be done by an administrator, which may not always be possible. Ravi Tandon from the product team add the following comments about EF related fixes in the beta (from same thread): “In context of this thread this will alleviate these issues for you: 1.
Cts Electronics Ls100 Usb 60309 For Windows 10 3/12/2016 2/23/2017 cts_electronics_ls100_usb-60309.exe 56kb Lenovo 20AL009CUS, Toshiba SATELLITE C50D-A-10Z, Lenovo 20AL009CUS, Fujitsu LIFEBOOK E8310, Acer Aspire M7200, HP EC619AA-ABY a1130.dk, Packard Bell IMEDIA H7653, NEC PC-VN790FS, LG RD580-UAD18E, HP Presario 2500, Lenovo 3484 - DBG, MDGComputers Prism Vx7500VTi, HP HP Touchsmart 300-1120, NEC PC-MY26XHZE1, NEC EASYNOTE PB47Q01806,, and more. Cts Electronics Ls100 Usb 622.11.17 For Windows 10 64 bit 3/17/2014 9/10/2016 cts_electronics_ls100_usb-622.11.17.exe 59kb LG R480-KAP28E, Sony VPCEA47EC, Lenovo ThinkCentre M57e, HP VN465AA-UUW HPE-010sc, OEGStone DB75EN, NEC PC-VJ22MAUEHTXV, Panasonic CF-SX2JE4DS, Acer Aspire 18X5PTZ, Sony SVF1532C4E, Shuttle SB83V10,, and more. Cts electronics ls 100 usb driver.
Fixes the ntext error, or any EF queries that use String Parameters. (Hotifx -, earlier released has been rolled up) 2. Fixes the 'AS' error. (Same Hotifx had this fix too and has been rolled up) 3. This MSI will do the seamless upgrades. You just need to use this MSI for ClickOnce and any other scenarios.
We Apologize For The Interruption. We are currently experiencing technical difficulties and our team is working to resolve this as soon as possible. We apologize for the inconven. Filjm sumerki v perevode prituli.
No Uninstalls anymore. We also got some reports of bad performance with EF designers if the Schema get's a bit complex and big. We have made changes for that, which should make the performance better. As always, we are open for feedback, suggestions, comments. Thanks a lot for using our product and the continued support!
Cheers Ravi” The 3.5 SP2 beta adds a few new APIs in the ADO.NET provider: 1: A new property has been added to the SqlCeReplication object (merge replication agent): PostSyncCleanup – it is “documented”. 2: The SqlCeEngine.Repair methods RepairOptions have changed (documented ): DeleteCorruptedRows –> DeleteCorruptedRows RecoverCorruptedRows –> RecoverAllPossibleRows (RecoverCorruptedRows is obsolete) New Enum value: RecoverAllOrFail An entirely new class is now available, called SqlCeChangeTracking. It exposes methods to programmatically enable, query and disable change tracking, something that was only available to the Visual Studio “Local Data Cache” designer (for Sync Framework applications.) I am looking forward to more documentation on this API! Hope this helps, and looking forward to the final release of SQL Server Compact 3.5 SP2. UPDATE: Ravi Tandon has posted even more info UPDATE 2: The VS 2010 RC contains a newer build (3.5.8078.0), and includes a readme file, that documents a couple of issues: 1: A ClickOnce application that uses DbProviderFactory to load the SQL Server Compact 3.5 SP2 provider will not work in the following cases: A computer already has SQL Server Compact 3.5 SP2 and.NET FX 2.0, 3.0, or 3.5 installed, and the ClickOnce application installs.NET FX 4 and SQL Server Compact 3.5 SP2 on the computer. A computer already has SQL Server Compact 3.5 SP2 and.NET FX 4 and installed and the ClickOnce application installs.NET FX 2.0, 3.0, or 3.5 on the computer.