public ISelectedColumnsSpecification UnionWithSelectedColumns(ISelectedColumnsSpecification selectedColumns)
{
ArgumentUtility.CheckNotNull("selectedColumns", selectedColumns);
if (!_columns.Any())
{
return(selectedColumns);
}
return(selectedColumns.Union(_columns.Select(orderedColumn => orderedColumn.ColumnDefinition)));
}
public UnionSelectDbCommandBuilder(
UnionViewDefinition unionViewDefinition,
ISelectedColumnsSpecification selectedColumns,
IComparedColumnsSpecification comparedColumns,
IOrderedColumnsSpecification orderedColumns,
ISqlDialect sqlDialect)
: base(sqlDialect)
{
ArgumentUtility.CheckNotNull("unionViewDefinition", unionViewDefinition);
ArgumentUtility.CheckNotNull("selectedColumns", selectedColumns);
ArgumentUtility.CheckNotNull("comparedColumns", comparedColumns);
ArgumentUtility.CheckNotNull("orderedColumns", orderedColumns);
_unionViewDefinition = unionViewDefinition;
_selectedColumns = selectedColumns;
_comparedColumns = comparedColumns;
_orderedColumns = orderedColumns;
}
public SelectDbCommandBuilder(
TableDefinition table,
ISelectedColumnsSpecification selectedColumns,
IComparedColumnsSpecification comparedColumns,
IOrderedColumnsSpecification orderedColumns,
ISqlDialect sqlDialect)
: base(sqlDialect)
{
ArgumentUtility.CheckNotNull("table", table);
ArgumentUtility.CheckNotNull("selectedColumns", selectedColumns);
ArgumentUtility.CheckNotNull("comparedColumns", comparedColumns);
ArgumentUtility.CheckNotNull("orderedColumns", orderedColumns);
_table = table;
_selectedColumns = selectedColumns;
_comparedColumns = comparedColumns;
_orderedColumns = orderedColumns;
}
public override void SetUp()
{
base.SetUp();
_selectedColumnsStub = MockRepository.GenerateStub <ISelectedColumnsSpecification>();
_selectedColumnsStub
.Stub(stub => stub.AppendProjection(Arg <StringBuilder> .Is.Anything, Arg <ISqlDialect> .Is.Anything))
.WhenCalled(mi => ((StringBuilder)mi.Arguments[0]).Append("[Column1], [Column2], [Column3]"));
_comparedColumnsStrictMock = MockRepository.GenerateStrictMock <IComparedColumnsSpecification> ();
_orderedColumnsStub = MockRepository.GenerateStub <IOrderedColumnsSpecification> ();
_sqlDialectStub = MockRepository.GenerateStub <ISqlDialect>();
_sqlDialectStub.Stub(stub => stub.StatementDelimiter).Return(";");
_dbDataParameterStub = MockRepository.GenerateStub <IDbDataParameter>();
_dataParameterCollectionMock = MockRepository.GenerateStrictMock <IDataParameterCollection>();
_dbCommandStub = MockRepository.GenerateStub <IDbCommand>();
_dbCommandStub.Stub(stub => stub.CreateParameter()).Return(_dbDataParameterStub);
_dbCommandStub.Stub(stub => stub.Parameters).Return(_dataParameterCollectionMock);
_commandExecutionContextStub = MockRepository.GenerateStub <IRdbmsProviderCommandExecutionContext>();
_commandExecutionContextStub.Stub(stub => stub.CreateDbCommand()).Return(_dbCommandStub);
}
public override void SetUp()
{
base.SetUp();
_originalSelectedColumnsStub = MockRepository.GenerateStub <ISelectedColumnsSpecification> ();
_comparedColumnsStrictMock = MockRepository.GenerateStrictMock <IComparedColumnsSpecification>();
_fullSelectedColumnsStub = MockRepository.GenerateStub <ISelectedColumnsSpecification> ();
_orderedColumnsStub = MockRepository.GenerateStub <IOrderedColumnsSpecification> ();
_sqlDialectStub = MockRepository.GenerateStub <ISqlDialect>();
_sqlDialectStub.Stub(stub => stub.StatementDelimiter).Return(";");
_dbCommandStub = MockRepository.GenerateStub <IDbCommand>();
_commandExecutionContextStub = MockRepository.GenerateStub <IRdbmsProviderCommandExecutionContext>();
_commandExecutionContextStub.Stub(stub => stub.CreateDbCommand()).Return(_dbCommandStub);
Guid.NewGuid();
_table1 = TableDefinitionObjectMother.Create(TestDomainStorageProviderDefinition, new EntityNameDefinition(null, "Table1"));
_table2 = TableDefinitionObjectMother.Create(TestDomainStorageProviderDefinition, new EntityNameDefinition(null, "Table2"));
_table3 = TableDefinitionObjectMother.Create(TestDomainStorageProviderDefinition, new EntityNameDefinition("customSchema", "Table3"));
}
public new void AppendSelectClause(StringBuilder statement, ISelectedColumnsSpecification selectedColumns)
{
base.AppendSelectClause(statement, selectedColumns);
}
protected void AppendSelectClause(StringBuilder statement, ISelectedColumnsSpecification selectedColumns)
{
statement.Append("SELECT ");
selectedColumns.AppendProjection(statement, SqlDialect);
}
