When developing mobile applications using Compact Framework and storing data to the local device database it is very handy to be able to debug and test sql queries direct on the device. This post will walk you through how to connect to the device DB, look at the tables in the device DB and run SQL queries on the device DB.
Run your application from Visual Studio, your device or emulator must be connected and cradled. (I’m running on Vista so I am using Windows Mobile Device Center).
You need to install Microsoft SQL server (I’m using the 2005 version) and run the Microsoft SQL server management studio.
Create a new connection with the following attributes: Continue reading »