Microsoft SQL Server compact 4.0 is a free embedded database. Software developers can use it to build ASP. NET websites and Windows desktop applications. Program. SQL Server compact 4.0 has the following advantages: it occupies a small amount of space and supports deploying binary files in the application folder. It is easy to use Visual Studio and webmatrix for application development, and seamlessly migrate the Architecture and Data to SQL Server.
Installation:
Install WPI (webplatform installer) in ms.
File: The suffix is. SDF.
The SDF file cannot be appended to the database with sqlserver
If you have installed sqlserverce4.0 and double-click SDF, you cannot open it directly. However, in studio, you can double-click to open the SDF file.
Diagram:
NOTE: If chinasec is installed, you cannot directly open the SDF file using vs10.
