Esempio n. 1
0
 protected void AppendWhereClause(
     StringBuilder statement,
     IComparedColumnsSpecification comparedColumns,
     IDbCommand command)
 {
     statement.Append(" WHERE ");
     comparedColumns.AddParameters(command, SqlDialect);
     comparedColumns.AppendComparisons(statement, command, SqlDialect);
 }
Esempio n. 2
0
        public override IDbCommand Create(IRdbmsProviderCommandExecutionContext commandExecutionContext)
        {
            ArgumentUtility.CheckNotNull("commandExecutionContext", commandExecutionContext);

            var command = commandExecutionContext.CreateDbCommand();

            var fullProjection = _orderedColumns.UnionWithSelectedColumns(_selectedColumns);

            var  statement = new StringBuilder();
            bool first     = true;

            _comparedColumns.AddParameters(command, SqlDialect);

            foreach (var table in _unionViewDefinition.GetAllTables())
            {
                if (!first)
                {
                    statement.Append(" UNION ALL ");
                }

                var adjustedProjection = fullProjection.AdjustForTable(table);
                AppendSelectClause(statement, adjustedProjection);
                AppendFromClause(statement, table);

                statement.Append(" WHERE ");
                _comparedColumns.AppendComparisons(statement, command, SqlDialect);

                first = false;
            }

            AppendOrderByClause(statement, _orderedColumns);

            statement.Append(SqlDialect.StatementDelimiter);

            command.CommandText = statement.ToString();

            return(command);
        }