Reclaims wasted space in the SQL Server Compact database by moving empty pages to the end of the file, and then truncating the file.
Assembly: System.Data.SqlServerCe (in System.Data.SqlServerCe.dll)
Unlike the Compact method, the method does not create a temporary database file. Instead, all empty and unallocated pages are moved to the end of the file and are then truncated, reducing the overall database size.
You can configure a database to automatically shrink by setting the property on the database.