RepairOption Enumeration

When passed to the Repair method, RepairOption specifies the type of database repair to perform.

Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)

Syntax

'Declaration
Public Enumeration RepairOption
'Usage
Dim instance As RepairOption
public enum RepairOption
public enum class RepairOption
public enum RepairOption
public enum RepairOption

Members

  Member name Description
Supported by the .NET Compact Framework DeleteCorruptedRows Deletes all corrupted rows without attempting to fix them. 
Supported by the .NET Compact Framework RecoverCorruptedRows Attempts to fix all corrupted rows rather than deleting them. 

Remarks

When using the RepairOption's DeleteCorruptedRows value, all corrupted pages are discarded from the database. This may result in significant data loss, but the data that is recovered using this option will be free from corruption.

When using the RepairOption's RecoverCorruptedRows value, the database will attempt to read data from the corrupted pages. This potentially results in more data being recovered, but this option does not guarantee that the data recovered will be free of corruption.

Platforms

Windows CE, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows XP Professional x64 Edition, Windows XP SP2

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

Version Information

.NET Framework

Supported in: 3.0

.NET Compact Framework

Supported in: 2.0

See Also

Reference

System.Data.SqlServerCe Namespace