protected void AppendOrderByClause(StringBuilder statement, IOrderedColumnsSpecification orderedColumnsSpecification) { ArgumentUtility.CheckNotNull("statement", statement); ArgumentUtility.CheckNotNull("orderedColumnsSpecification", orderedColumnsSpecification); if (!orderedColumnsSpecification.IsEmpty) { statement.Append(" ORDER BY "); orderedColumnsSpecification.AppendOrderings(statement, SqlDialect); } }
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 AppendOrderByClause(StringBuilder statement, IOrderedColumnsSpecification orderedColumnsSpecification) { base.AppendOrderByClause(statement, orderedColumnsSpecification); }