SqlCeEngine.Verify Method ()

Článek
10/22/2009

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

public bool Verify ()

public:
bool Verify ()

public boolean Verify ()

public function Verify () : boolean

Return Value

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 is already opened in exclusive mode by another application.

Example

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);
}

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

Windows Vista, Windows Mobile 5.0, Windows XP Professional with Service Pack 2 (SP2), Windows Server 2003, Windows Mobile 2003 for Pocket PC, Windows CE 5.0
Version Information
.NET Framework and NET Compact Framework
Supported in 3.5
.NET Framework
Supported in 3.0
.NET Compact Framework and .Net Framework
Supported in 2.0

Sdílet prostřednictvím