private void AssertNotExist(string connectionStringName) { try { DBOracleConnectionStrings.Get(connectionStringName); Assert.Fail(); } catch (ArgumentOutOfRangeException) { // OK } }
public void TestDBOracleConnectionStrings() { #region Build connection strings var connectionString = new DBOracleConnectionStringBuilder(); var dataSource = new DBOracleDataSourceBuilder(); var description = dataSource.AddDescription(); description.ConnectData.ServiceName = @"XE"; var address = description.AddAddressList().AddAddress(); address.Protocol = DBOracleDataSourceBuilder.ProtocolTCP; address.Host = @"localhost"; address.Port = 1521; connectionString.DataSource = dataSource.DataSourceString; connectionString.Pooling = true; var connectionStringWithPooling = connectionString.ConnectionString; connectionString.Pooling = false; var connectionStringWithoutPooling = connectionString.ConnectionString; #endregion Assert.AreEqual(0, DBOracleConnectionStrings.GetAll().Count); AssertNotExist(@"DB_POOL"); AssertNotExist(@"DB_NOPOOL"); AssertNotExist(@"DB_TEST"); DBOracleConnectionStrings.Add(@"DB_POOL", connectionStringWithPooling); Assert.AreEqual(1, DBOracleConnectionStrings.GetAll().Count); Assert.AreEqual(connectionStringWithPooling, DBOracleConnectionStrings.Get(@"DB_POOL")); AssertNotExist(@"DB_NOPOOL"); AssertNotExist(@"DB_TEST"); Assert.IsTrue(DBOracleConnectionStrings.GetAll().OrderBy(item => item.Key).SequenceEqual(new[] { new KeyValuePair <string, string>(@"DB_POOL", connectionStringWithPooling) })); DBOracleConnectionStrings.Add(@"DB_NOPOOL", connectionStringWithoutPooling); Assert.AreEqual(2, DBOracleConnectionStrings.GetAll().Count); Assert.AreEqual(connectionStringWithPooling, DBOracleConnectionStrings.Get(@"DB_POOL")); Assert.AreEqual(connectionStringWithoutPooling, DBOracleConnectionStrings.Get(@"DB_NOPOOL")); AssertNotExist(@"DB_TEST"); Assert.IsTrue(DBOracleConnectionStrings.GetAll().OrderBy(item => item.Key).SequenceEqual(new[] { new KeyValuePair <string, string>(@"DB_NOPOOL", connectionStringWithoutPooling), new KeyValuePair <string, string>(@"DB_POOL", connectionStringWithPooling) })); Assert.IsTrue(DBOracleConnectionStrings.Remove(@"DB_POOL")); Assert.AreEqual(1, DBOracleConnectionStrings.GetAll().Count); AssertNotExist(@"DB_POOL"); Assert.AreEqual(connectionStringWithoutPooling, DBOracleConnectionStrings.Get(@"DB_NOPOOL")); AssertNotExist(@"DB_TEST"); Assert.IsTrue(DBOracleConnectionStrings.GetAll().OrderBy(item => item.Key).SequenceEqual(new[] { new KeyValuePair <string, string>(@"DB_NOPOOL", connectionStringWithoutPooling) })); Assert.IsFalse(DBOracleConnectionStrings.Remove(@"DB_POOL")); Assert.AreEqual(1, DBOracleConnectionStrings.GetAll().Count); AssertNotExist(@"DB_POOL"); Assert.AreEqual(connectionStringWithoutPooling, DBOracleConnectionStrings.Get(@"DB_NOPOOL")); AssertNotExist(@"DB_TEST"); Assert.IsTrue(DBOracleConnectionStrings.GetAll().OrderBy(item => item.Key).SequenceEqual(new[] { new KeyValuePair <string, string>(@"DB_NOPOOL", connectionStringWithoutPooling) })); Assert.IsTrue(DBOracleConnectionStrings.Remove(@"DB_NOPOOL")); Assert.AreEqual(0, DBOracleConnectionStrings.GetAll().Count); AssertNotExist(@"DB_POOL"); AssertNotExist(@"DB_NOPOOL"); AssertNotExist(@"DB_TEST"); Assert.IsFalse(DBOracleConnectionStrings.Remove(@"DB_NOPOOL")); Assert.AreEqual(0, DBOracleConnectionStrings.GetAll().Count); AssertNotExist(@"DB_POOL"); AssertNotExist(@"DB_NOPOOL"); AssertNotExist(@"DB_TEST"); }