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; }