public void CanDeserializeSerializedConfiguration()
{
OracleConnectionSettings rwSettings = new OracleConnectionSettings();
OracleConnectionData rwOracleConnectionData = new OracleConnectionData();
rwOracleConnectionData.Name = "name0";
rwOracleConnectionData.Packages.Add(new OraclePackageData("package1", "pref1"));
rwOracleConnectionData.Packages.Add(new OraclePackageData("package2", "pref2"));
rwSettings.OracleConnectionsData.Add(rwOracleConnectionData);
rwOracleConnectionData = new OracleConnectionData();
rwOracleConnectionData.Name = "name1";
rwOracleConnectionData.Packages.Add(new OraclePackageData("package3", "pref3"));
rwOracleConnectionData.Packages.Add(new OraclePackageData("package4", "pref4"));
rwSettings.OracleConnectionsData.Add(rwOracleConnectionData);
IDictionary<string, ConfigurationSection> sections = new Dictionary<string, ConfigurationSection>();
sections[OracleConnectionSettings.SectionName] = rwSettings;
IConfigurationSource configurationSource
= ConfigurationTestHelper.SaveSectionsInFileAndReturnConfigurationSource(sections);
OracleConnectionSettings roSettings = (OracleConnectionSettings)configurationSource.GetSection(OracleConnectionSettings.SectionName);
Assert.AreEqual(2, roSettings.OracleConnectionsData.Count);
Assert.AreEqual("name0", roSettings.OracleConnectionsData.Get(0).Name);
Assert.AreEqual(2, roSettings.OracleConnectionsData.Get(0).Packages.Count);
}
public void SetUp()
{
provider = new OracleConnectionSettingsManageabilityProvider(new Dictionary<Type, ConfigurationElementManageabilityProvider>(0));
machineKey = new MockRegistryKey(true);
userKey = new MockRegistryKey(true);
section = new OracleConnectionSettings();
}
private void InitializeSubordinateSectionViewModels(DatabaseSettings databaseSettings, OracleConnectionSettings oracleSettings)
{
if (databaseSettings == null) databaseSettings = new DatabaseSettings();
dataSettingsViewModel = CreateSubordinateModel(DatabaseSettings.SectionName, databaseSettings);
elementLookup.AddSection(dataSettingsViewModel);
if (oracleSettings == null) oracleSettings = new OracleConnectionSettings();
oracleSettingsViewModel = CreateSubordinateModel(OracleConnectionSettings.SectionName, oracleSettings);
elementLookup.AddSection(oracleSettingsViewModel);
}
public OracleDatabaseData(
ConnectionStringSettings connectionStringSettings,
IConfigurationSource configurationSource)
: base(connectionStringSettings, configurationSource)
{
OracleConnectionSettings section = (OracleConnectionSettings)configurationSource.GetSection("oracleConnectionSettings");
if (section == null)
{
return;
}
this.ConnectionData = section.OracleConnectionsData.Get(connectionStringSettings.Name);
}
public OracleConnectionSettings Build()
{
oracleConnectionSettings = new OracleConnectionSettings();
IList<ConfigurationNode> connections = hierarchy.FindNodesByType(typeof(OracleConnectionElementNode));
for (int index = 0; index < connections.Count; ++index)
{
OracleConnectionData data = new OracleConnectionData();
data.Name = connections[index].Parent.Name;
foreach (OraclePackageElementNode node in connections[index].Nodes)
{
data.Packages.Add(node.OraclePackageElement);
}
oracleConnectionSettings.OracleConnectionsData.Add(data);
}
return oracleConnectionSettings;
}
public static DictionaryConfigurationSource CreateConfigurationSource()
{
DictionaryConfigurationSource source = new DictionaryConfigurationSource();
DatabaseSettings settings = new DatabaseSettings();
settings.DefaultDatabase = "Service_Dflt";
OracleConnectionSettings oracleConnectionSettings = new OracleConnectionSettings();
OracleConnectionData data = new OracleConnectionData();
data.Name = "OracleTest";
data.Packages.Add(new OraclePackageData("TESTPACKAGE", "TESTPACKAGETOTRANSLATE"));
oracleConnectionSettings.OracleConnectionsData.Add(data);
source.Add(DatabaseSettings.SectionName, settings);
source.Add(OracleConnectionSettings.SectionName, oracleConnectionSettings);
return source;
}
public static DictionaryConfigurationSource CreateConfigurationSource()
{
DictionaryConfigurationSource source = new DictionaryConfigurationSource();
DatabaseSettings settings = new DatabaseSettings();
settings.DefaultDatabase = "Service_Dflt";
settings.ProviderMappings.Add(new DbProviderMapping("Oracle.ManagedDataAccess.Client", "EntLibContrib.Data.Oracle.ManagedDataAccess.OracleDatabase, EntLibContrib.Data.Oracle.ManagedDataAccess, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"));
OracleConnectionSettings oracleConnectionSettings = new OracleConnectionSettings();
OracleConnectionData data = new OracleConnectionData();
data.Name = "OracleTest";
data.Packages.Add(new OraclePackageData("TESTPACKAGE", "TESTPACKAGETOTRANSLATE"));
data.Packages.Add(new OraclePackageData("PKGNORTHWIND", "NWND_"));
data.Packages.Add(new OraclePackageData("PKGENTLIB", "RegionSelect"));
oracleConnectionSettings.OracleConnectionsData.Add(data);
source.Add(DatabaseSettings.SectionName, settings);
source.Add(OracleConnectionSettings.SectionName, oracleConnectionSettings);
return source;
}
public void CanGetExtraInformation()
{
ConnectionStringSettings data
= new ConnectionStringSettings(name, "connection string;");
OracleConnectionData oracleConnectionData = new OracleConnectionData();
oracleConnectionData.Name = name;
oracleConnectionData.Packages.Add(new OraclePackageData("package1", "pref1"));
oracleConnectionData.Packages.Add(new OraclePackageData("package2", "pref2"));
OracleConnectionSettings oracleConnectionSettings = new OracleConnectionSettings();
oracleConnectionSettings.OracleConnectionsData.Add(oracleConnectionData);
configurationSource.Add(OracleConnectionSettings.SectionName, oracleConnectionSettings);
OracleDatabase database = (OracleDatabase)assembler.Assemble(data.Name, data, configurationSource);
Assert.IsNotNull(database);
Assert.AreSame(typeof(OracleDatabase), database.GetType());
// can't access the packages - must resort to side effect
DbCommand dBCommand = database.GetStoredProcCommand(OracleTestStoredProcedureInPackageWithTranslation);
Assert.AreEqual((object)OracleTestTranslatedStoredProcedureInPackageWithTranslation, dBCommand.CommandText);
}
public OracleConnectionNodeBuilder(IServiceProvider serviceProvider, OracleConnectionSettings oracleConnectionSettings)
: base(serviceProvider)
{
this.hierarchy = ServiceHelper.GetCurrentHierarchy(serviceProvider);
this.oracleConnectionSettings = oracleConnectionSettings;
}
private void EnsureOracleSettings()
{
currentOracleSettings = Builder.Get<OracleConnectionSettings>(OracleConnectionSettings.SectionName);
if (currentOracleSettings != null) return;
currentOracleSettings = new OracleConnectionSettings();
Builder.AddSection(OracleConnectionSettings.SectionName, currentOracleSettings);
}
public void Setup()
{
var configSource = new DictionaryConfigurationSource();
var connectionStrings = new ConnectionStringsSection();
connectionStrings.ConnectionStrings.Add(
new ConnectionStringSettings("someSetting", "someConnectionString", "System.Data.OracleClient"));
configSource.Add("connectionStrings", connectionStrings);
var oracleConnectionData = new OracleConnectionData { Name = "someSetting" };
oracleConnectionData.Packages.Add(new OraclePackageData("foo", "bar"));
var oracleSettings = new OracleConnectionSettings();
oracleSettings.OracleConnectionsData.Add(oracleConnectionData);
configSource.Add(OracleConnectionSettings.SectionName, oracleSettings);
configSettings = new DatabaseSyntheticConfigSettings(configSource);
}
public void Setup()
{
var configSource = new DictionaryConfigurationSource();
var connectionStrings = new ConnectionStringsSection();
connectionStrings.ConnectionStrings.Add(
new ConnectionStringSettings("someSetting", "someConnectionString", "System.Data.OracleClient"));
configSource.Add("connectionStrings", connectionStrings);
var oracleSettings = new OracleConnectionSettings();
configSource.Add(OracleConnectionSettings.SectionName, oracleSettings);
configSettings = new DatabaseSyntheticConfigSettings(configSource);
}
public void Given()
{
// Setup connection strings
configurationSource = new DictionaryConfigurationSource();
var connectionStringsSection = new ConnectionStringsSection();
connectionStringsSection.ConnectionStrings.Add(
new ConnectionStringSettings
{
Name = "myConnectionName",
ConnectionString = "myConnectionString",
ProviderName = "System.Data.OracleClient"
}
);
configurationSource.Add("connectionStrings", connectionStringsSection);
// Setup oracle configuration sections
var oracleConnectionData = new OracleConnectionData { Name = "myConnectionName" };
oracleConnectionData.Packages.Add(new OraclePackageData("foo", "bar"));
var oracleSettings = new OracleConnectionSettings();
oracleSettings.OracleConnectionsData.Add(oracleConnectionData);
configurationSource.Add(OracleConnectionSettings.SectionName, oracleSettings);
settings = new DatabaseSyntheticConfigSettings(configurationSource.GetSection);
}
public void Given()
{
var configurationSource = new DictionaryConfigurationSource();
var oracleConnectionData = new OracleConnectionData { Name = "myConnectionName" };
oracleConnectionData.Packages.Add(new OraclePackageData("foo", "bar"));
var oracleSettings = new OracleConnectionSettings();
oracleSettings.OracleConnectionsData.Add(oracleConnectionData);
configurationSource.Add(OracleConnectionSettings.SectionName, oracleSettings);
var databaseData = new OracleDatabaseData(
new ConnectionStringSettings
{
Name = "myConnectionName",
ConnectionString = "myConnectionString",
ProviderName = "System.Data.Odbc"
},
configurationSource);
registration = databaseData.GetRegistrations().First();
}
private static bool OracleSettingsAreEmpty(OracleConnectionSettings oracleConnectionSettings)
{
if (oracleConnectionSettings.OracleConnectionsData.Count > 0) return false;
return true;
}
public void WillNotFailIfOracleConnectionDataEntryDesNotExistForName()
{
ConnectionStringSettings data
= new ConnectionStringSettings(name, "connection string;");
OracleConnectionSettings oracleConnectionSettings = new OracleConnectionSettings();
OracleDatabase database = (OracleDatabase)assembler.Assemble(data.Name, data, configurationSource);
Assert.IsNotNull(database);
Assert.AreSame(typeof(OracleDatabase), database.GetType());
}
