I'm trying to develop an application on the WT4100 (which runs Windows Compact 7), that needs to use an on-device database.
On previous Windows CE/Mobile we could use SQLCE v3.5
(C:\Program Files (x86)\Microsoft SQL Server Compact Edition\v3.5\Devices\wce500\armv4i)
I don't remember exactly if it was the "sqlce.wce5.armv4i.CAB" or the "sqlce.ppc.wce5.armv4i.CAB".
However, neither installs on CE7, and even when debugging/deploying from Visual Studio, it complains that :
File or assembly name 'System.Data.SqlServerCe, Version=126.96.36.199, Culture=neutral, PublicKeyToken=3BE235DF1C8D2AD3', or one of its dependencies, was not found.
Does anyone know how to get (any version of) SQLCE to work on Windows Compact 7?
It seems that most SQL CE functionality works with SQL CE 3.5 SP2.
In my case, I found that at least the use of "SqlCeEngine" will throw the above exception.
I can work around that, and with removing that particular piece of code, it all works.
So for me this issue is closed.