I've been trying to get SQL Compact 3.5 working in Visual Studio 2008. Since SQL Compact 3.5 ships with Visual Studio 2008, I thought that this wouldn't be a problem. All I needed to do was to create a new Windows Forms project and add a Local Database
