In researching bugs, I often need to quickly see what data actually exists in the SQL Server CE database on the handheld device. Due to the tedious nature of keying in SQL statements on the device itself, how can I quickly run SQL statements to determine what the results from my Windows CE app should be?
Connect the device via ActiveSync/WMDC, and connect to the database from SSMS 2008 R2, and you can Query from SSMS on your PC. If you use SQL Ce 2.0, you can use the Primeworks tools to access the database on the device, if it is 3.1, you can use SSMS 2005 SP2