SqlCeReplication.DropSubscription Method
.NET Framework 3.0
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)
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 )
Not applicable.
Parameters
- dropOption
The DropOption value specifies whether to leave or delete the SQL Server Compact Edition database. The value can be one of the following constants:
| Item | Description |
|---|---|
| DropDatabase | Deletes the SQL Server Compact Edition 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
Community Additions
ADD
Show: