I'm building my first VB.net desktop app that uses the SqlServerCE database for my backend and I need to figure out how to bundle the libraries with the app so that end users to not have to download or install SqlServerCE on their machine to make it work. Currently, I zip the executable and the database file from the debug directory and send it to my test user. When he opens the app it works fine until he tries to login, which is when the app tries to connect to the database. He is greeted with the exception:
"Could not load file or assembly 'System.Data.SqlServerCe, Version=220.127.116.11, etc' the system cannot find the file specified."
Any thoughts on the subject are greatly appreciated,