[Ignore] // Requires setting up IIS fro subscription
public void DropSubscriptionTwiceThrowsException()
{
SubscriptionParameters subParams = CreateSubscriptionParams("PubCustomers", "CustomersTest");
SqlSubscriptionManager subMgr = CreateSubscriptionManager();
subMgr.Add(subParams);
subMgr.Synchronize(subMgr.Subscriptions[0]);
subMgr = CreateSubscriptionManager();
Subscription sub = subMgr.Subscriptions[0];
subMgr.Drop(sub);
subMgr.Drop(sub);
}
public void CanDropSubscriptionAfterAppRestart()
{
SubscriptionParameters subParams = CreateSubscriptionParams("PubCustomers", "CustomersTest");
SqlSubscriptionManager subMgr = CreateSubscriptionManager();
subMgr.Add(subParams);
subMgr = CreateSubscriptionManager();
subMgr.Drop(subMgr.Subscriptions[0]);
Assert.AreEqual(0, subMgr.Subscriptions.Count);
}
[Ignore] // Requires setting up IIS fro subscription
public void CanDropSubscriptionByName()
{
SubscriptionParameters subParams = CreateSubscriptionParams("PubCustomers", "CustomersTest");
SqlSubscriptionManager subMgr = CreateSubscriptionManager();
subMgr.Add(subParams);
subMgr.Synchronize("CustomersTest");
subMgr = CreateSubscriptionManager();
subMgr.Drop("CustomersTest");
Assert.AreEqual(0, subMgr.Subscriptions.Count);
subMgr = CreateSubscriptionManager();
Assert.AreEqual(0, subMgr.Subscriptions.Count);
}
[Ignore] // Requires setting up IIS fro subscription
public void DifferentFilterReturnsDifferentData()
{
SubscriptionParameters subParams = CreateSubscriptionParams("PubCustomers", "CustomersTest");
subParams.Filter = "DE";
SqlSubscriptionManager subMgr = CreateSubscriptionManager();
subMgr.Add(subParams);
Subscription sub = subMgr.Subscriptions[0];
subMgr.Synchronize(sub);
int count = CountCustomers(connectionString);
subMgr.Drop(sub);
subParams.Filter = "DK";
subMgr.Add(subParams);
sub = subMgr.Subscriptions[0];
subMgr.Synchronize(sub);
int count2 = CountCustomers(connectionString);
Assert.AreNotEqual(count, count2);
}