I produced a home windows application and that i needed a database for this. When i first used SQL Server Express edition inside it. I Quickly found know that it's not quite a transportable database. That's, SQL Server Express edition ought to be already set up in the pc where I guess to make use of my application. I found know will be able to use SQL CE rather and transformed into it. I discovered somewhere that I must do is simply copy the sqlceme30.dll within the application. Labored fine during my developement system. However when I copy the applying to a different system and open the applying, it throws the mistake

 System.IO.FileNotFoundException: Could not load file or assembly 'System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

Can One use SQL CE during my application? I truly don't wish to do the installation in most the machines I personally use my application. Or maybe not, which other db I'm able to use without intalling? Access?

Be sure that your reference is placed to Copy Local. Right click the reference, and click on qualities. They alter the Copy Local property to true. Which will be sure that the dll is incorporated within the publish.