Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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)
Syntax
'Declaration
Public Function Verify As Boolean
'Usage
Dim instance As SqlCeEngine
Dim returnValue As Boolean
returnValue = instance.Verify()
public bool Verify()
public:
bool Verify()
member Verify : unit -> bool
public function Verify() : boolean
Return Value
Type: System.Boolean
True if the checksums match and there is no database corruption; otherwise, false.
Remarks
If this method returns false, the database is corrupt, and your application should call the Repair method to correct the problem.
Note
False is also returned if there is a failure connecting to the database. Scenarios include an incorrect password, or the database file is inaccessible.
Examples
Dim engine As New SqlCeEngine("Data Source = AdventureWorks.sdf")
If False = engine.Verify() Then
MessageBox.Show("Database is corrupted.")
engine.Repair(Nothing, RepairOption.RecoverCorruptedRows)
End If
SqlCeEngine engine = new SqlCeEngine("Data Source = AdventureWorks.sdf");
if (false == engine.Verify())
{
MessageBox.Show("Database is corrupted.");
engine.Repair(null, RepairOption.RecoverCorruptedRows);
}