I am new to SQL CE 2008 and I am having trouble programmatically connecting to the .sdf database and selecting/updating/inserting/deleting the data. I have tried various tutorials and examples on MSDN, Google and EE and haven't been able to get any of the suggested methods to work properly. Could someone please help me by providing an example of programmatically connecting to the database and then manipulating some data eg. update some records etc.
Thank you in anticipation.