Export (0) Print
Expand All

SqlCeEngine.Verify Method

Recalculates the checksums for each page in the database and compares the new checksums to the expected values.

Namespace:  System.Data.SqlServerCe
Assembly:  System.Data.SqlServerCe (in System.Data.SqlServerCe.dll)

public bool Verify()

Return Value

Type: System.Boolean
True if the checksums match and there is no database corruption; otherwise, false.

If this method returns false, the database is corrupt, and your application should call the Repair method to correct the problem.

NoteNote

False is also returned if there is a failure connecting to the database. Scenarios include an incorrect password, or the database file is inaccessible.

SqlCeEngine engine = new SqlCeEngine("Data Source = AdventureWorks.sdf");

if (false == engine.Verify())
{
    MessageBox.Show("Database is corrupted.");
    engine.Repair(null, RepairOption.RecoverCorruptedRows);
}


Show:
© 2014 Microsoft