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 object CreateObject(IBuilderContext context, string name, IConfigurationSource configurationSource, ConfigurationReflectionCache reflectionCache)
{
DatabaseConfigurationView configurationView = new DatabaseConfigurationView(configurationSource);
ConnectionStringSettings connectionStringSettings = configurationView.GetConnectionStringSettings(name);
DbProviderMapping mapping = configurationView.GetProviderMapping(name, connectionStringSettings.ProviderName);
IDatabaseAssembler assembler = GetAssembler(mapping.DatabaseType, name, reflectionCache);
Database database = assembler.Assemble(name, connectionStringSettings, configurationSource);
return(database);
}
public void CanConnectToOracleAndExecuteAReader()
{
ConnectionStringSettings data = view.GetConnectionStringSettings("OracleTest");
OracleDatabase oracleDatabase = (OracleDatabase)assembler.Assemble(data.Name, data, configurationSource);
DbConnection connection = oracleDatabase.CreateConnection();
Assert.IsNotNull(connection);
Assert.IsTrue(connection is OracleConnection);
connection.Open();
DbCommand cmd = oracleDatabase.GetSqlStringCommand("Select * from Region");
cmd.CommandTimeout = 0;
}