I recently had to create a small application that uses a database. I opted for SQL CE 4.0 because it uses the same T-SQL syntax as MS SQL, it’s portable and you can very easily use it with Entity Framework.
When the time came to deploy my application and create a Setup file, I hit the wall. Before I’ve created the setup file I tried copying my app files to another computer which had preinstalled SQL CE 4.0 dependencies. When I tried to start my application i got “the specified store provider cannot be found in the configuration” error.