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)
{
}
