SqlCeChangeTracking Class

This type has a SecurityCriticalAttribute attribute, which restricts it to internal use by the .NET Framework for Silverlight class library. Application code that uses any member of this type throws a MethodAccessException.


Provides methods that can be used to track changes to tables in a SQL Server Compact database.

Inheritance Hierarchy


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


<SecurityCriticalAttribute(SecurityCriticalScope.Everything)> _
<PermissionSetAttribute(SecurityAction.Demand, Name := "FullTrust")> _
Public NotInheritable Class SqlCeChangeTracking _
    Implements IDisposable
Dim instance As SqlCeChangeTracking
[PermissionSetAttribute(SecurityAction.Demand, Name = "FullTrust")]
public sealed class SqlCeChangeTracking : IDisposable
[PermissionSetAttribute(SecurityAction::Demand, Name = L"FullTrust")]
public ref class SqlCeChangeTracking sealed : IDisposable
[<PermissionSetAttribute(SecurityAction.Demand, Name = "FullTrust")>]
type SqlCeChangeTracking =  
        interface IDisposable
public final class SqlCeChangeTracking implements IDisposable

The SqlCeChangeTracking type exposes the following members.


  Name Description
Public method SqlCeChangeTracking(SqlCeConnection) Initializes a new instance of the SqlCeChangeTracking class with a SqlCeConnection.
Public method SqlCeChangeTracking(SqlCeTransaction) Initializes a new instance of the SqlCeChangeTracking class with a SqlCeTransaction.



  Name Description
Public method DisableTracking Disables tracking on the specified table.
Public method Dispose() Releases all resources used by the current instance of the SqlCeChangeTracking class.
Public method Dispose(Boolean) Releases the unmanaged resources used by the SqlCeChangeTracking class and optionally releases the managed resources.
Public method EnableTracking Enables tracking on the specified table.
Public method Equals (inherited from Object)
Protected method Finalize (inherited from Object)
Public method GetHashCode (inherited from Object)
Public method GetLastCommittedCsn Returns the Commit Sequence Number (CSN) of the last transaction committed for the data source associated with the SqlCeChangeTracking object.
Public method GetTrackingOptions Gets a value that indicates the database operations that are currently being tracked on the specified table.
Public method GetType (inherited from Object)
Protected method MemberwiseClone (inherited from Object)
Public method PackTombstoneKey Converts the row key from the specified table into the format used for the row key in the tombstone table.
Public method PurgeTombstoneTableData Purges tombstone data for the specified table.
Public method PurgeTransactionSequenceData Purges the specified data from the transaction history table.
Public method ToString (inherited from Object)
Public method UnpackTombstoneKey Converts the representation of a row key used in the tombstone table into the column values of the row key used in the specified table.
Public methodStatic member UpgradePublicTracking Upgrades tracking metadata in a SQL Server Compact SP2 database, on which tracking has been enabled, for use by Microsoft Sync Framework Service Pack 1 (SP1) and later versions of Sync Framework.


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.

See Also


System.Data.SqlServerCe Namespace