Could not load file or assembly 'System.Data.SqlServerCe'

Question

I have a .Net Framework 3 Winforms application that works with a SQLServerCE database. I've just released my latest version, but on 2 of the users computers I got this message:

---

Could not load file or assembly 'System.Data.SqlServerCe, Version=3.5.1.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The module was expected to contain an assembly manifest.

I have the following list of files in my application folder:

sqlceca35.dll

sqlcecompact35.dll

sqlceer35EN.dll

sqlceme35.dll

sqlceoledb35.dll

sqlceqp35.dll

sqlcese35.dll

System.Data.SqlServerCe.dll

Microsoft.Synchronization.Data.dll

Microsoft.Synchronization.Data.Server.dll

Microsoft.Synchronization.Data.SqlServerCe.dll

Could anyone please point me in the right direction?

Answer 1

I solved this problem by setting the Specific Version property of the System.Data.SqlServerCe to False.

You can do this by right clicking on the Reference and clicking on Properties. After the properties window has opened, find the Specific Version property and set it to False.

Answer 2

Solution : its worked to my system, issue closed Install Microsoft SQL CE 3.5 that can be downloaded from http://www.microsoft.com/download/en/details.aspx?id=5783

Install Microsoft SQL CE 4.0 SP1 that can be downloaded from https://www.microsoft.com/en-us/download/confirmation.aspx?id=30709