SqlCeReplication.DropSubscription Method

Drops the subscription to a SQL Server publication and optionally deletes the SQL Server Compact 3.5 SP1 database from the Windows Mobile-based device.

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

public void DropSubscription (
	DropOption dropOption
public void DropSubscription (
	DropOption dropOption
public function DropSubscription (
	dropOption : DropOption



The DropOption value specifies whether to leave or delete the SQL Server Compact 3.5 SP1 database. The value can be one of the following constants:




Deletes the SQL Server Compact 3.5 SP1 database (default).


Deletes the replication system tables and three replication system columns in the user tables, but does not delete the database.

The following example shows how to drop a subscription and delete the local database. A SqlCeReplication object is created, the SubscriberConnectionString is set, and the DropSubscription method is called. This method passes the DropDatabase option.

SqlCeReplication repl = null;

    // Create SqlCeReplication instance
    repl = new SqlCeReplication();
    repl.SubscriberConnectionString = "Data Source=MyDatabase.sdf";

    // Drop the subscription and delete the database
catch (SqlCeException)
    // Handle errors here
    // Dispose the repl object

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.

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