SqlCeEngine Class
Represents the properties, methods, and other objects of the SQL Server Compact Engine object. This class cannot be inherited.
Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in System.Data.SqlServerCe.dll)
The SqlCeEngine type exposes the following members.
| Name | Description | |
|---|---|---|
 | SqlCeEngine() | Initializes a new instance of the SqlCeEngine class. |
| SqlCeEngine(String) | Initializes a new instance of the SqlCeEngine class with the specified local connection string. |
| Name | Description | |
|---|---|---|
| LocalConnectionString | Gets or sets the connection string to the SQL Server Compact database. |
| Name | Description | |
|---|---|---|
| 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. |
| CreateDatabase | Creates a new database. |
| Dispose | Releases all SQL Server Compact SqlCeEngine resources. |
| Equals | (inherited from Object) |
| Finalize | (inherited from Object) |
| GetHashCode | (inherited from Object) |
| GetType | (inherited from Object) |
| MemberwiseClone | (inherited from Object) |
| Repair | Repairs a corrupted database. |
| 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. |
| ToString | (inherited from Object) |
| 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. |
| 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. |
| Verify() | Recalculates the checksums for each page in the database and compares the new checksums to the expected values. |
| Verify(VerifyOption) | Verifies the integrity of the database based on the VerifyOption. |
SQL Server Compact is optimized to serve as a database for Web sites and Web applications. SQL Server Compact is optimized for use as an embedded database within Web applications. SQL Server Compact can be used as a database for Web sites for multiple users and concurrent data changes.
SQL Server Compact can be used for developing ASP.NET Web applicatons. In the previous versions of SQL Server Compact a flag, SQLServerCompactEditionUnderWebHosting had to be set to use SQL Server Compact in ASP.NET Web applications. The flag is removed in SQL Server Compact 4.0.