SqlCeEngine Methods

Include Protected Members
Include Inherited Members

The SqlCeEngine type exposes the following members.

Methods

  Name Description
Public method Compact Reclaims wasted space in the SQL Server Compact database by creating a new database file from the existing file. This method is also used to change the collating order, encryption, or password settings of the database.
Public method CreateDatabase Creates a new database.
Public method Dispose Releases all SQL Server Compact SqlCeEngine resources.
Public method Equals (inherited from Object)
Protected method Finalize (inherited from Object)
Public method GetHashCode (inherited from Object)
Public method GetType (inherited from Object)
Protected method MemberwiseClone (inherited from Object)
Public method Repair Repairs a corrupted database.
Public method Shrink Reclaims wasted space in the SQL Server Compact database by moving empty pages to the end of the file, and then truncating the file.
Public method ToString (inherited from Object)
Public method Upgrade() Upgrades a SQL Server Compact database from version 3.5 to 4.0. After the upgrade, the database will be encrypted if the source database was encrypted. If it was not, the upgraded database will be unencrypted.
Public method Upgrade(String) Upgrades a SQL Server Compact database from version 3.5 to 4.0. The destination database will be encrypted if the encryption mode was specified in the Destination Connection string. The collation of the database will be case sensitive if the case-sensitive property is set to true in the connection string.
Public method Verify() Recalculates the checksums for each page in the database and compares the new checksums to the expected values.
Public method Verify(VerifyOption) Verifies the integrity of the database based on the VerifyOption.

Top

See Also

Reference

SqlCeEngine Class

System.Data.SqlServerCe Namespace