private void AssertNotExist(string connectionStringName) { try { DBSqlServerConnectionStrings.Get(connectionStringName); Assert.Fail(); } catch (ArgumentOutOfRangeException) { // OK } }
public void TestDBSqlServerConnectionStrings() { #region Build connection strings var connectionString = new DBSqlServerConnectionStringBuilder(); connectionString.DataSource = @"localhost"; connectionString.Pooling = true; var connectionStringWithPooling = connectionString.ConnectionString; connectionString.Pooling = false; var connectionStringWithoutPooling = connectionString.ConnectionString; #endregion Assert.AreEqual(0, DBSqlServerConnectionStrings.GetAll().Count); AssertNotExist(@"DB_POOL"); AssertNotExist(@"DB_NOPOOL"); AssertNotExist(@"DB_TEST"); DBSqlServerConnectionStrings.Add(@"DB_POOL", connectionStringWithPooling); Assert.AreEqual(1, DBSqlServerConnectionStrings.GetAll().Count); Assert.AreEqual(connectionStringWithPooling, DBSqlServerConnectionStrings.Get(@"DB_POOL")); AssertNotExist(@"DB_NOPOOL"); AssertNotExist(@"DB_TEST"); Assert.IsTrue(DBSqlServerConnectionStrings.GetAll().OrderBy(item => item.Key).SequenceEqual(new[] { new KeyValuePair <string, string>(@"DB_POOL", connectionStringWithPooling) })); DBSqlServerConnectionStrings.Add(@"DB_NOPOOL", connectionStringWithoutPooling); Assert.AreEqual(2, DBSqlServerConnectionStrings.GetAll().Count); Assert.AreEqual(connectionStringWithPooling, DBSqlServerConnectionStrings.Get(@"DB_POOL")); Assert.AreEqual(connectionStringWithoutPooling, DBSqlServerConnectionStrings.Get(@"DB_NOPOOL")); AssertNotExist(@"DB_TEST"); Assert.IsTrue(DBSqlServerConnectionStrings.GetAll().OrderBy(item => item.Key).SequenceEqual(new[] { new KeyValuePair <string, string>(@"DB_NOPOOL", connectionStringWithoutPooling), new KeyValuePair <string, string>(@"DB_POOL", connectionStringWithPooling) })); Assert.IsTrue(DBSqlServerConnectionStrings.Remove(@"DB_POOL")); Assert.AreEqual(1, DBSqlServerConnectionStrings.GetAll().Count); AssertNotExist(@"DB_POOL"); Assert.AreEqual(connectionStringWithoutPooling, DBSqlServerConnectionStrings.Get(@"DB_NOPOOL")); AssertNotExist(@"DB_TEST"); Assert.IsTrue(DBSqlServerConnectionStrings.GetAll().OrderBy(item => item.Key).SequenceEqual(new[] { new KeyValuePair <string, string>(@"DB_NOPOOL", connectionStringWithoutPooling) })); Assert.IsFalse(DBSqlServerConnectionStrings.Remove(@"DB_POOL")); Assert.AreEqual(1, DBSqlServerConnectionStrings.GetAll().Count); AssertNotExist(@"DB_POOL"); Assert.AreEqual(connectionStringWithoutPooling, DBSqlServerConnectionStrings.Get(@"DB_NOPOOL")); AssertNotExist(@"DB_TEST"); Assert.IsTrue(DBSqlServerConnectionStrings.GetAll().OrderBy(item => item.Key).SequenceEqual(new[] { new KeyValuePair <string, string>(@"DB_NOPOOL", connectionStringWithoutPooling) })); Assert.IsTrue(DBSqlServerConnectionStrings.Remove(@"DB_NOPOOL")); Assert.AreEqual(0, DBSqlServerConnectionStrings.GetAll().Count); AssertNotExist(@"DB_POOL"); AssertNotExist(@"DB_NOPOOL"); AssertNotExist(@"DB_TEST"); Assert.IsFalse(DBSqlServerConnectionStrings.Remove(@"DB_NOPOOL")); Assert.AreEqual(0, DBSqlServerConnectionStrings.GetAll().Count); AssertNotExist(@"DB_POOL"); AssertNotExist(@"DB_NOPOOL"); AssertNotExist(@"DB_TEST"); }