Greg Keogh - are you game to abandon SQLLite and try this new incarnation of SQL Compact?
Ian, I'm still on the fence with SQLite. I tore my pants on the barbed-wire of typelessness and DateTime as strings, but I haven't jumped off completely yet. I may return to SQLite over the coming months when I have time and a specific pressing need to get it working. In the meantime my SQL CE 3.5 apps are working nicely. A quick flip through the 4.0 features show nothing startling, except perhaps the improved concurrency (which I don't really need anyway). We're evaluating EF4 at the moment, and the improved integration between it and CE 4.0 is a nice prospect as well. I'll upgrade to CE 4.0 after it's released. Cheers, Greg
