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(); }
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 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); }
void IContainerPolicyCreator.CreatePolicies( IPolicyList policyList, string instanceName, ConfigurationElement configurationObject, IConfigurationSource configurationSource) { ConnectionStringSettings castConfigurationObject = (ConnectionStringSettings)configurationObject; IList <IOraclePackage> packages = new IOraclePackage[0]; OracleConnectionSettings oracleConnectionSettings = OracleConnectionSettings.GetSettings(configurationSource); if (oracleConnectionSettings != null) { OracleConnectionData oracleConnectionData = oracleConnectionSettings.OracleConnectionsData.Get(castConfigurationObject.Name); if (oracleConnectionData != null) { packages = new List <IOraclePackage>(from op in oracleConnectionData.Packages select(IOraclePackage) op); } } new PolicyBuilder <OracleDatabase, ConnectionStringSettings>( instanceName, castConfigurationObject, c => new OracleDatabase(c.ConnectionString, packages)) .AddPoliciesToPolicyList(policyList); }
/// <summary> /// Builds an instance of the concrete subtype of <see cref="T:Microsoft.Practices.EnterpriseLibrary.Data.Database"/> /// the receiver knows how to build, based on the provided connection string and any configuration information /// that might be contained by the <paramref name="configurationSource"/>. /// </summary> /// <param name="name">The name for the new database instance.</param> /// <param name="connectionStringSettings">The connection string for the new database instance.</param> /// <param name="configurationSource">The source for any additional configuration information.</param> /// <returns> /// The new database instance. /// </returns> public Database Assemble(string name, ConnectionStringSettings connectionStringSettings, IConfigurationSource configurationSource) { if (IsDebugEnabled) { log.Debug("EnterpriseLibrary용 OracleProvider 인스턴스를 빌드합니다... name=[{0}]", name); } var settings = OracleConnectionSettings.GetSettings(configurationSource); if (settings != null) { var data = settings.OracleConnectionsData.Get(name); if (data != null) { var packages = new IOraclePackage[data.Packages.Count]; var num = 0; foreach (var package in data.Packages) { packages[num++] = package; } return(new OracleDatabase(connectionStringSettings.ConnectionString)); } } if (IsDebugEnabled) { log.Debug("OracleDatabase를 생성합니다. connectionString=[{0}]", connectionStringSettings.ConnectionString); } return(new OracleDatabase(connectionStringSettings.ConnectionString)); }
/// <summary> /// Builds an instance of the concrete subtype of <see cref="T:Microsoft.Practices.EnterpriseLibrary.Data.Database"/> the receiver knows how to build, based on /// the provided connection string and any configuration information that might be contained by the /// <paramref name="configurationSource"/>. /// </summary> /// <param name="name">The name for the new database instance.</param> /// <param name="connectionStringSettings">The connection string for the new database instance.</param> /// <param name="configurationSource">The source for any additional configuration information.</param> /// <returns>The new database instance.</returns> public Database Assemble(string name, ConnectionStringSettings connectionStringSettings, IConfigurationSource configurationSource) { if (log.IsInfoEnabled) { log.Info("OdpNetDatabase 인스턴스를 생성하기 위해 환경설정 정보를 읽습니다..." + "name=[{0}], connectionStringSettings=[{1}], configurationSource=[{2}]", name, connectionStringSettings.ConnectionString, configurationSource); } var connectionSettings = OracleConnectionSettings.GetSettings(configurationSource); if (connectionSettings != null) { OracleConnectionData oraConnData = connectionSettings.OracleConnectionsData.Get(name); if (oraConnData != null) { var packages = oraConnData.Packages.Cast <IOraclePackage>().ToArray(); return(new OdpNetDatabase(connectionStringSettings.ConnectionString, packages)); } } return(new OdpNetDatabase(connectionStringSettings.ConnectionString)); }
public void SetUp() { provider = new OracleConnectionSettingsManageabilityProvider(new Dictionary <Type, ConfigurationElementManageabilityProvider>(0)); machineKey = new MockRegistryKey(true); userKey = new MockRegistryKey(true); section = new OracleConnectionSettings(); }
/// <summary> /// Gets the a <see cref="ConfigurationSectionInfo"/> for the oracle connection configuration section. /// </summary> /// <param name="serviceProvider">The a mechanism for retrieving a service object; that is, an object that provides custom support to other objects.</param> /// <returns>A <see cref="ConfigurationSectionInfo"/> for the oracle connection configuration section.</returns> protected override ConfigurationSectionInfo GetConfigurationSectionInfo(IServiceProvider serviceProvider) { ConfigurationNode rootNode = ServiceHelper.GetCurrentRootNode(serviceProvider); DatabaseSectionNode databaseSectionNode = null; if (rootNode != null) { databaseSectionNode = rootNode.Hierarchy.FindNodeByType(rootNode, typeof(DatabaseSectionNode)) as DatabaseSectionNode; } OracleConnectionSettings oracleConnectionSection = null; IList <ConfigurationNode> connections = rootNode.Hierarchy.FindNodesByType(typeof(OracleConnectionElementNode)); if (connections.Count == 0) { oracleConnectionSection = null; } else { OracleConnectionSettingsBuilder builder = new OracleConnectionSettingsBuilder(serviceProvider); oracleConnectionSection = builder.Build(); } string protectionProviderName = GetProtectionProviderName(databaseSectionNode); return(new ConfigurationSectionInfo(rootNode, oracleConnectionSection, OracleConnectionSettings.SectionName, protectionProviderName)); }
public void DictionaryConfigurationSourceCanConfigureFactoryAndExecuteScalar() { DictionaryConfigurationSource source = new DictionaryConfigurationSource(); DatabaseSettings setting = new DatabaseSettings(); setting.DefaultDatabase = "OracleTest"; ConnectionStringsSection connectionSection = new ConnectionStringsSection(); connectionSection.ConnectionStrings.Add(new ConnectionStringSettings("OracleTest", ConfigurationManager.AppSettings["oracleConnectionString"] , "System.Data.OracleClient")); source.Add("connectionStrings", connectionSection); source.Add("dataConfiguration", setting); OracleConnectionSettings oracleSetting = new OracleConnectionSettings(); OracleConnectionData oracleData = new OracleConnectionData(); oracleData.Name = "OracleTest"; oracleSetting.OracleConnectionsData.Add(oracleData); source.Add("oracleConnectionSettings", oracleSetting); DatabaseProviderFactory factory = new DatabaseProviderFactory(source); Database db = factory.Create("OracleTest"); DbCommand dbCommand = db.GetStoredProcCommand("GetProductName"); db.AddInParameter(dbCommand, "vProductId", DbType.Int32, 1); db.AddOutParameter(dbCommand, "vResult", DbType.StringFixedLength, 100); db.ExecuteScalar(dbCommand); Assert.AreEqual("Product1", db.GetParameterValue(dbCommand, "vResult").ToString().Trim()); }
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); }
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()); }
private void EnsureOracleSettings() { currentOracleSettings = Builder.Get <OracleConnectionSettings>(OracleConnectionSettings.SectionName); if (currentOracleSettings != null) { return; } currentOracleSettings = new OracleConnectionSettings(); Builder.AddSection(OracleConnectionSettings.SectionName, currentOracleSettings); }
private void EnsureOracleSettings() { this.currentOracleSettings = this.Builder.Get <OracleConnectionSettings>("oracleConnectionSettings"); if (this.currentOracleSettings != null) { return; } this.currentOracleSettings = new OracleConnectionSettings(); this.Builder.AddSection("oracleConnectionSettings", (ConfigurationSection)this.currentOracleSettings); }
private static OracleConnectionSettings GenerateOracleConnectionSettings() { OracleConnectionSettings settings = new OracleConnectionSettings(); OracleConnectionData data = new OracleConnectionData(); data.Name = "Service_Dflt"; data.Packages.Add(new OraclePackageData("PKGNORTHWIND", "NWND_")); data.Packages.Add(new OraclePackageData("PKGENTLIB", "RegionSelect")); settings.OracleConnectionsData.Add(data); return(settings); }
private OracleConnectionSettings getDBConnectionSettingsFromGUI() { bool autoConnect = dbConnectionSettings != null && dbConnectionSettings.AutoConnect; OracleConnectionSettings settings = new OracleConnectionSettings(); settings.DataSource = textBoxDBDataSource.Text; settings.UserId = textBoxDBUserID.Text; settings.Password = textBoxDBPassword.Text; settings.AutoConnect = autoConnect; dbConnectionSettings = settings; return(settings); }
public OracleOptions() { _lazyConnectionSettings = new Lazy <OracleConnectionSettings>(() => { if (_relationalOptions.Connection != null) { return(OracleConnectionSettings.GetSettings(_relationalOptions.Connection)); } return(OracleConnectionSettings.GetSettings(_relationalOptions.ConnectionString)); }, LazyThreadSafetyMode.PublicationOnly); }
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.GetSection); }
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 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 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); }
/// <summary> /// Gets the a <see cref="ConfigurationSectionInfo"/> for the oracle connection configuration section. /// </summary> /// <param name="serviceProvider">The a mechanism for retrieving a service object; that is, an object that provides custom support to other objects.</param> /// <returns>A <see cref="ConfigurationSectionInfo"/> for the oracle connection configuration section.</returns> protected override ConfigurationSectionInfo GetConfigurationSectionInfo(IServiceProvider serviceProvider) { ConfigurationNode rootNode = ServiceHelper.GetCurrentRootNode(serviceProvider); OracleConnectionSettings oracleConnectionSection = null; IList <ConfigurationNode> connections = rootNode.Hierarchy.FindNodesByType(typeof(OracleConnectionElementNode)); if (connections.Count == 0) { oracleConnectionSection = null; } else { OracleConnectionSettingsBuilder builder = new OracleConnectionSettingsBuilder(serviceProvider); oracleConnectionSection = builder.Build(); } return(new ConfigurationSectionInfo(rootNode, oracleConnectionSection, OracleConnectionSettings.SectionName)); }
public OracleMultipleTableViewersForm() { InitializeComponent(); //Directories root = Application.StartupPath; if (!Directory.Exists(root + "\\" + configFoldername)) { Directory.CreateDirectory(root + "\\" + configFoldername); //configuraton directory... } //Initialize drawings and pictures try { gray_indicator = global::MultipleTableViewer.Properties.Resources.gray_indicator; red_indicator = global::MultipleTableViewer.Properties.Resources.red_indicator; green_indicator = global::MultipleTableViewer.Properties.Resources.green_indicator; seablue_indicator = global::MultipleTableViewer.Properties.Resources.seablue_indicator; pictureBoxConnection.Image = gray_indicator; } catch { } //Initialization variables FileStream filestream = null; string folderpath = root + "\\" + configFoldername; XmlSerializer serializerObj; try { filestream = new FileStream(folderpath + "\\" + dbConnectionFilename + ".xml", FileMode.Open, FileAccess.Read, FileShare.Read); serializerObj = new XmlSerializer(typeof(OracleConnectionSettings)); dbConnectionSettings = (OracleConnectionSettings)serializerObj.Deserialize(filestream); filestream.Close(); textBoxDBDataSource.Text = dbConnectionSettings.DataSource; textBoxDBUserID.Text = dbConnectionSettings.UserId; textBoxDBPassword.Text = dbConnectionSettings.Password; if (dbConnectionSettings.AutoConnect) { connect(); } } catch { if (filestream != null) { filestream.Close(); } } }
public Database Assemble(string name, ConnectionStringSettings connectionStringSettings, IConfigurationSource configurationSource) { OracleConnectionSettings oracleConnectionSettings = OracleConnectionSettings.GetSettings(configurationSource); if (oracleConnectionSettings != null) { OracleConnectionData oracleConnectionData = oracleConnectionSettings.OracleConnectionsData.Get(name); if (oracleConnectionData != null) { IOraclePackage[] packages = new IOraclePackage[oracleConnectionData.Packages.Count]; int i = 0; foreach (IOraclePackage package in oracleConnectionData.Packages) { packages[i++] = package; } return(new OracleDatabase(connectionStringSettings.ConnectionString, packages)); } } return(new OracleDatabase(connectionStringSettings.ConnectionString)); }
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.GetSection); }
public static DictionaryConfigurationSource CreateConfigurationSource() { DictionaryConfigurationSource source = new DictionaryConfigurationSource(); DatabaseSettings settings = new DatabaseSettings(); settings.DefaultDatabase = "Service_Dflt"; settings.ProviderMappings.Add(new DbProviderMapping(DbProviderMapping.DefaultOracleProviderName, typeof(EnterpriseLibrary.Data.OdpNet.Core.OracleDatabase))); 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 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 OracleConnectionNodeBuilder(IServiceProvider serviceProvider, OracleConnectionSettings oracleConnectionSettings) : base(serviceProvider) { this.hierarchy = ServiceHelper.GetCurrentHierarchy(serviceProvider); this.oracleConnectionSettings = oracleConnectionSettings; }
public static void GenerateWmiObjects(OracleConnectionSettings configurationObject, ICollection <ConfigurationSetting> wmiSettings) { }