I've just enabled InstallShield LE within Visual Studio 2010 and am putting together a setup project. I would like to specify SQL Server CE 4.0 as a required prerequisite such that InstallShield will take care of the complexities of 64 bit vs 32 bit and different OS's without me having to check for registry keys or anything like that.
Why is SQL Server CE not included? It is touted as Microsoft's desktop data solution and InstallShield LE is touted as the replacement for Visual Studio setup projects, so shouldn't it be standard?
I can see a SQL Server CE prq file in InstallShield's Requirements folder (along with numerous others) but it does not show up in Visual Studio. Is there a way to enable it?
Why not just include the required files as content: http://erikej.blogspot.com/2011/02/using-sql-server-compact-40-with.html