public void Initialize()
{
XmlTextReader xmlReader = new XmlTextReader(new StringReader(oracleXmlString));
XmlSerializer xmlSerializer = new XmlSerializer(typeof(ConnectionStringData));
oracleConnectionString = xmlSerializer.Deserialize(xmlReader) as OracleConnectionStringData;
}
/// <devdoc>
/// Look into configuration and get the information how the command wrapper should be updated if calling a package on this
/// connection.
/// </devdoc>
private void PreparePackageSchema(ODP10CommandWrapper commandWrapper)
{
const string allPrefix = "*";
string packageName = String.Empty;
string prefix = String.Empty;
string commandText = commandWrapper.Command.CommandText;
if (CommandType.StoredProcedure == commandWrapper.Command.CommandType)
{
OracleConnectionStringData oraConnectionString = this.DatabaseProviderData.ConnectionStringData as OracleConnectionStringData;
if (oraConnectionString != null)
{
foreach (OraclePackageData oraPackage in oraConnectionString.OraclePackages)
{
if ((oraPackage.Prefix == allPrefix) || (commandText.StartsWith(prefix)))
{
//use the package name for the matching prefix
packageName = oraPackage.Name;
break;
}
}
}
if (0 != packageName.Length)
{
commandWrapper.Command.CommandText = String.Format(CultureInfo.InvariantCulture, "{0}.{1}", packageName, commandText);
}
}
}
public override void SetUp()
{
base.SetUp();
DatabaseSettings databaseSettings = DatabaseSettingsBuilder.Create(Host);
connectionStringData = databaseSettings.ConnectionStrings["OracleConnection"] as OracleConnectionStringData;
Assert.IsNotNull(connectionStringData);
DatabaseSettingsNode databaseSettingsNode = new DatabaseSettingsNode(databaseSettings);
IUIHierarchy hierarchy = CreateHierarchyAndAddToHierarchyService(databaseSettingsNode, CreateDefaultConfiguration());
ConfigurationNode[] nodes = hierarchy.FindNodesByType(typeof(OracleConnectionStringNode));
foreach (OracleConnectionStringNode node in nodes)
{
connectionStringNode = node;
}
}
public void CreateFromRuntimeTest()
{
DatabaseSettings databaseSettings = DatabaseSettingsBuilder.Create(Host);
OracleConnectionStringData data = databaseSettings.ConnectionStrings["OracleConnection"] as OracleConnectionStringData;
OracleConnectionStringNode node = new OracleConnectionStringNode(data);
CreateHierarchyAndAddToHierarchyService(node, CreateDefaultConfiguration());
Assert.AreEqual(data.Name, node.Name);
Assert.AreEqual(4, node.Nodes.Count);
ValidateNodeCommand cmd = new ValidateNodeCommand(Host);
cmd.Execute(node);
Assert.AreEqual(0, ValidationErrorsCount);
}
public override void SetUp()
{
base.SetUp();
DatabaseSettings databaseSettings = DatabaseSettingsBuilder.Create(Host);
connectionStringData = databaseSettings.ConnectionStrings["OracleConnection"] as OracleConnectionStringData;
Assert.IsNotNull(connectionStringData);
DatabaseSettingsNode databaseSettingsNode = new DatabaseSettingsNode(databaseSettings);
IUIHierarchy hierarchy = CreateHierarchyAndAddToHierarchyService(databaseSettingsNode, CreateDefaultConfiguration());
ConfigurationNode[] nodes = hierarchy.FindNodesByType(typeof(OracleConnectionStringNode));
foreach (OracleConnectionStringNode node in nodes)
{
connectionStringNode = node;
}
}
public void SerializeTest()
{
OracleConnectionStringData connectionString = new OracleConnectionStringData(name);
connectionString.OraclePackages.Add(new OraclePackageData(packageName, prefix));
connectionString.Parameters.Add(new ParameterData(sspiName, sspiValue));
connectionString.Parameters.Add(new ParameterData(paramName, paramValue));
XmlSerializer serializer = new XmlSerializer(typeof(ConnectionStringData));
StringWriter stringWriter = new StringWriter(CultureInfo.CurrentUICulture);
XmlTextWriter xmlTextWriter = new XmlTextWriter(stringWriter);
try
{
serializer.Serialize(xmlTextWriter, connectionString);
xmlTextWriter.Flush();
string xml = stringWriter.ToString();
Assert.AreEqual(oracleXmlString, xml);
}
finally
{
xmlTextWriter.Close();
stringWriter.Close();
}
}
public void SerializeTest()
{
OracleConnectionStringData connectionString = new OracleConnectionStringData(name);
connectionString.OraclePackages.Add(new OraclePackageData(packageName, prefix));
connectionString.Parameters.Add(new ParameterData(sspiName, sspiValue));
connectionString.Parameters.Add(new ParameterData(paramName, paramValue));
XmlSerializer serializer = new XmlSerializer(typeof(ConnectionStringData));
StringWriter stringWriter = new StringWriter(CultureInfo.CurrentUICulture);
XmlTextWriter xmlTextWriter = new XmlTextWriter(stringWriter);
try
{
serializer.Serialize(xmlTextWriter, connectionString);
xmlTextWriter.Flush();
string xml = stringWriter.ToString();
Assert.AreEqual(oracleXmlString, xml);
}
finally
{
xmlTextWriter.Close();
stringWriter.Close();
}
}
public void Initialize()
{
XmlTextReader xmlReader = new XmlTextReader(new StringReader(oracleXmlString));
XmlSerializer xmlSerializer = new XmlSerializer(typeof(ConnectionStringData));
oracleConnectionString = xmlSerializer.Deserialize(xmlReader) as OracleConnectionStringData;
}
/// <summary>
/// <para>Initalize a new instance of the <see cref="OracleConnectionStringNode"/> class with the runtime version that this node will represent.</para>
/// </summary>
/// <param name="oracleConnectionStringData">
/// <para>The <see cref="OracleConnectionStringData"/> that this node will represent.</para>
/// </param>
public OracleConnectionStringNode(OracleConnectionStringData oracleConnectionStringData) : base(oracleConnectionStringData)
{
this.oracleConnectionStringData = oracleConnectionStringData;
}
/// <summary>
/// <para>Initalize a new instance of the <see cref="OracleConnectionStringNode"/> class with the runtime version that this node will represent.</para>
/// </summary>
/// <param name="oracleConnectionStringData">
/// <para>The <see cref="OracleConnectionStringData"/> that this node will represent.</para>
/// </param>
public OracleConnectionStringNode(OracleConnectionStringData oracleConnectionStringData)
: base(oracleConnectionStringData)
{
this.oracleConnectionStringData = oracleConnectionStringData;
}
