I'm having a problem moving running my applications on Windows 8 and 8.1 platforms. I have built few inter-connected software which use a single database file built using SQL Server CE (file is of .SDF format). This software works fine on Windows 7.
But whenever I try to run on Windows 8 or 8.1, it gives me error that SQL Server CE file or assembly not found.
System.IO.FileNotFoundException: Could not load file or assembly 'System.Data.SqlServerCe, Version=4.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. File name: 'System.Data.SqlServerCe, Version=4.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
I've tried installing SQL Server CE 4.0 on Windows 8, the setup gives error that platform is not supported. I've tried bundling the 7 DLLs of SQL Server CE along with my executable files, it still gives not found error as above.
What am I missing here. Can anyone guide?
-Faraz
