Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
DropSubscription Method

SqlCeReplication.DropSubscription Method

Drops the subscription to a SQL Server publication and optionally deletes the SQL Server Compact Edition 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
Not applicable.



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




Deletes the SQL Server Compact Edition 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

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.

.NET Framework

Supported in: 3.0

.NET Compact Framework

Supported in: 2.0, 1.0

Community Additions

© 2015 Microsoft