User2119691303 posted
Its used in pretty much the same way as in everything else in my experience - we currently use SQL CE on a mobile application and the only difference to using it compared to say a web service using SQL Server is the namespace and the class names to
use - AFAIK all of the major functionality is there - but be careful about following bad practices such as leaving the connection open as you only have one connection to the DB in versions prior to 2005 and its VERY easy to run out of process memory.
This link has more info on the newest variant: