Just noticed the following article on MSDN.
DataSet Server CE: Database Connectivity for Windows Mobile-Based Devices
http://msdn.microsoft.com/mobility/default.aspx?pull=/library/en-us/dnppcgen/html/dataset_server_ce.asp
If you have lamented the lack of SQL CE on SmartPhone devices then this article is for you. It demonstrates a custom architecture that does a lot of what SQL CE can do with DataSets!
Just goes to show you there is always a workaround.