.Net CMS like Umbraco still use Windows CE heavily so it may not have a long future but it is still being used, and good enough for clients too tight to pay out for a proper license
I've not encountered issues using Visual Studio but most of my back end code is just ADO.Net hand written code, maybe all the gui stuff is starting to hate it ?
Accordin to Erik at the excellent 'Everything SQL Server Compact' blog, CE goes out of support in 2021
Everything SQL Server Compact: Comparison of SQL Server Compact, SQLite, SQL Server Express and LocalDB
Yes, the dataset designer in the latest VS is not compatible with CE and VS does not seem to recognise CE data connections when I open a 'legacy' project in the latest community edition VS. Not good omens.
