public void GetActiveDbListenersTest()
{
Func <int> getDbDepCount =
() =>
SqlDependencyEx.GetDependencyDbIdentities(
TEST_CONNECTION_STRING,
TEST_DATABASE_NAME).Length;
var options = new SqlDependencyExOptions
{
ConnectionString = TEST_CONNECTION_STRING,
DatabaseName = TEST_DATABASE_NAME,
TableName = TEST_TABLE_NAME,
SchemaName = "temp"
};
using (var dep1 = new SqlDependencyEx(options, identity: 4))
using (var dep2 = new SqlDependencyEx(options, identity: 5))
{
dep1.Start();
// Make sure db has been got 1 dependency object.
Assert.AreEqual(1, getDbDepCount());
dep2.Start();
// Make sure db has been got 2 dependency object.
Assert.AreEqual(2, getDbDepCount());
}
// Make sure db has no any dependency objects.
Assert.AreEqual(0, getDbDepCount());
}
public void ClearDatabaseTest()
{
Func <int> getDbDepCount =
() =>
SqlDependencyEx.GetDependencyDbIdentities(
TEST_CONNECTION_STRING,
TEST_DATABASE_NAME).Length;
var options = new SqlDependencyExOptions
{
ConnectionString = TEST_CONNECTION_STRING,
DatabaseName = TEST_DATABASE_NAME,
TableName = TEST_TABLE_NAME,
SchemaName = "temp"
};
var dep1 = new SqlDependencyEx(
options,
identity: 4);
var dep2 = new SqlDependencyEx(
options,
identity: 5);
dep1.Start();
// Make sure db has been got 1 dependency object.
Assert.AreEqual(1, getDbDepCount());
dep2.Start();
// Make sure db has been got 2 dependency object.
Assert.AreEqual(2, getDbDepCount());
// Forced db cleaning
SqlDependencyEx.CleanDatabase(TEST_CONNECTION_STRING, TEST_DATABASE_NAME);
// Make sure db has no any dependency objects.
Assert.AreEqual(0, getDbDepCount());
dep1.Dispose();
dep2.Dispose();
}
