protected void AppendWhereClause(
StringBuilder statement,
IComparedColumnsSpecification comparedColumns,
IDbCommand command)
{
statement.Append(" WHERE ");
comparedColumns.AddParameters(command, SqlDialect);
comparedColumns.AppendComparisons(statement, command, SqlDialect);
}
public DeleteDbCommandBuilder(
TableDefinition tableDefinition,
IComparedColumnsSpecification comparedColumnsSpecification,
ISqlDialect sqlDialect)
: base(sqlDialect)
{
ArgumentUtility.CheckNotNull("tableDefinition", tableDefinition);
ArgumentUtility.CheckNotNull("comparedColumnsSpecification", comparedColumnsSpecification);
_tableDefinition = tableDefinition;
_comparedColumnsSpecification = comparedColumnsSpecification;
}
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();
_comparedColumnsSpecificationStrictMock = MockRepository.GenerateStrictMock <IComparedColumnsSpecification>();
_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();
_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 AppendWhereClause(StringBuilder statement, IComparedColumnsSpecification comparedColumns, IDbCommand command)
{
base.AppendWhereClause(statement, comparedColumns, command);
}
