public void GetActiveDbListenersTest() { Func <int> getDbDepCount = () => SqlDependencyEx.GetDependencyDbIdentities( TEST_CONNECTION_STRING, TEST_DATABASE_NAME).Length; using (var dep1 = new SqlDependencyEx(TEST_CONNECTION_STRING, TEST_DATABASE_NAME, TEST_TABLE_NAME, "temp" , identity: 4)) using (var dep2 = new SqlDependencyEx(TEST_CONNECTION_STRING, TEST_DATABASE_NAME, TEST_TABLE_NAME, "temp" , 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 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 async Task ClearDatabaseTest() { Func <Task <int> > getDbDepCount = async() => (await SqlDependencyEx.GetDependencyDbIdentities(TEST_CONNECTION_STRING, TEST_DATABASE_NAME)).Length; var dep1 = new SqlDependencyEx( TEST_CONNECTION_STRING, TEST_DATABASE_NAME, TEST_TABLE_NAME, "temp", identity: 4); var dep2 = new SqlDependencyEx( TEST_CONNECTION_STRING, TEST_DATABASE_NAME, TEST_TABLE_NAME, "temp", 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 await SqlDependencyEx.CleanDatabase(TEST_CONNECTION_STRING, TEST_DATABASE_NAME); // Make sure db has no any dependency objects. Assert.AreEqual(0, getDbDepCount()); dep1.Dispose(); dep2.Dispose(); }
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(); }