SqlCeReplication.DropSubscription Method
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)
'Declaration Public Sub DropSubscription ( _ dropOption As DropOption _ ) 'Usage Dim instance As SqlCeReplication Dim dropOption As DropOption instance.DropSubscription(dropOption)
public void DropSubscription ( DropOption dropOption )
public function DropSubscription ( dropOption : DropOption )
Parameters
- dropOption
The DropOption value specifies whether to leave or delete the SQL Server Mobile database. The value can be one of the following constants:
| Item | Description |
|---|---|
| DropDatabase | Deletes the SQL Server Mobile database (default). |
| LeaveDatabase | 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.
Dim repl As SqlCeReplication = Nothing Try ' Create SqlCeReplication instance ' repl = New SqlCeReplication() repl.SubscriberConnectionString = "Data Source=MyDatabase.sdf" ' Drop the subscription and delete the database ' repl.DropSubscription(DropOption.DropDatabase) Catch ' Handle errors here Finally ' Dispose the repl object ' repl.Dispose() End Try
Windows CE, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows XP Professional x64 Edition, Windows XP SP2
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.