Solution Provider 'System. Data. sqlserverce.3.5 'not installed.

Developed on 64-bit machines. If sqlserverce is used, you may encounter this problem. There are two problems:

1. If you are prompted that sqlserverce is not installed on the cloud, you only need to download it from Microsoft.

2. sqlserverce has been installed in the system, and the program cannot find the corresponding assembly. At this time, there are many solutions on the Internet, and the most effective method may be the personalized app. config file. However, this method cannot completely solve the problem, and it will not work on 64-bit machines. In this case, you need to force the application to be compatible with 32-bit (even if the 64-bit sqlserverce is installed ). The method is to change platform target to x86 In the build tab of the program properties.