SqlCeEngine Members

Represents the properties, methods, and other objects of the Engine object. This class cannot be inherited.

The SqlCeEngine type exposes the following members.

Constructors

  Name Description
Public method SqlCeEngine() () () () Initializes a new instance of the SqlCeEngine class.
Public method SqlCeEngine(String) Initializes a new instance of the SqlCeEngine class with the specified local connection string.

Top

Methods

  Name Description
Public method Compact(String) Reclaims wasted space in the 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  SqlCeEngine resources.
Public method Equals(Object) (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(String, RepairOption) Repairs a corrupted database.
Public method Shrink() () () () Reclaims wasted space in the 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.1 to 3.5. 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.1 to 3.5. 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

Properties

  Name Description
Public property LocalConnectionString Gets or sets the connection string to the database.

Top

See Also

Reference

SqlCeEngine Class

System.Data.SqlServerCe Namespace