SQL Server Compact Edition has been deprecated, no new versions or updates are planned, so it might be better to seek an alternative.
If your demands are simple you can try
LiteDB[
^] which does not need to be installed as it is just a dll that you can distribute with your application.
If you want to stick with SQL Server CE take a look at:
GitHub - domgho/InnoDependencyInstaller: Modular Inno Setup Dependency Installer[
^]
It supports installing all kinds of prerequisites like .NET framework, SQL Server, C++ Redistributables etc.