public void Setup() { using (var connection = OracleConnectionBuilder.Build()) { connection.Open(); } }
protected override Func <string, DbConnection> GetConnection() { return(x => { var connection = OracleConnectionBuilder.Build(); return connection; }); }
protected override Func <DbConnection> GetConnection() { return(() => { var connection = OracleConnectionBuilder.Build(); connection.Open(); return connection; }); }
public async Task Should_remove_old_property_after_phase_three() { var dialect = BuildSqlDialect.Oracle; var sagaPhase1 = RuntimeSagaDefinitionReader.GetSagaDefinition(typeof(Phase1Saga), dialect); var sagaPhase2 = RuntimeSagaDefinitionReader.GetSagaDefinition(typeof(Phase2Saga), dialect); var sagaPhase3 = RuntimeSagaDefinitionReader.GetSagaDefinition(typeof(Phase3Saga), dialect); string[] phase1Schema, phase2Schema, phase3Schema; using (var connection = OracleConnectionBuilder.Build(disableMetadataPooling: true)) { await connection.OpenAsync().ConfigureAwait(false); connection.ExecuteCommand(SagaScriptBuilder.BuildDropScript(sagaPhase1, dialect), ""); connection.ExecuteCommand(SagaScriptBuilder.BuildCreateScript(sagaPhase1, dialect), ""); phase1Schema = GetSchema(connection); connection.PurgeStatementCache(); } using (var connection = OracleConnectionBuilder.Build(disableMetadataPooling: true)) { await connection.OpenAsync().ConfigureAwait(false); connection.ExecuteCommand(SagaScriptBuilder.BuildCreateScript(sagaPhase2, dialect), ""); phase2Schema = GetSchema(connection); connection.PurgeStatementCache(); } using (var connection = OracleConnectionBuilder.Build(disableMetadataPooling: true)) { await connection.OpenAsync().ConfigureAwait(false); connection.ExecuteCommand(SagaScriptBuilder.BuildCreateScript(sagaPhase3, dialect), ""); phase3Schema = GetSchema(connection); connection.PurgeStatementCache(); } CollectionAssert.Contains(phase1Schema, "CORR_ORDERNUMBER"); CollectionAssert.DoesNotContain(phase1Schema, "CORR_ORDERID"); CollectionAssert.Contains(phase2Schema, "CORR_ORDERNUMBER"); CollectionAssert.Contains(phase2Schema, "CORR_ORDERID"); CollectionAssert.DoesNotContain(phase3Schema, "CORR_ORDERNUMBER"); CollectionAssert.Contains(phase3Schema, "CORR_ORDERID"); }