public override void BuildCommand(DbCommand command)
 {
     // TODO: handle_commandTree.Parameters
     InsertExpression insert = new InsertExpression();
     _tableName = _commandTree.Target.VariableName;
     insert.AppendTarget(_commandTree.Target.Expression.Accept(this));
     List<VisitedExpression> columns = new List<VisitedExpression>();
     List<VisitedExpression> values = new List<VisitedExpression>();
     foreach (DbSetClause clause in _commandTree.SetClauses)
     {
         columns.Add(clause.Property.Accept(this));
         values.Add(clause.Value.Accept(this));
     }
     insert.AppendColumns(columns);
     insert.AppendValues(values);
     if (_commandTree.Returning != null)
     {
         insert.AppendReturning(_commandTree.Returning as DbNewInstanceExpression);
     }
     _tableName = null;
     command.CommandText = insert.ToString();
 }
Example #2
0
        public override void BuildCommand(DbCommand command)
        {
            // TODO: handle_commandTree.Parameters
            InsertExpression insert = new InsertExpression();

            _tableName = _commandTree.Target.VariableName;
            insert.AppendTarget(_commandTree.Target.Expression.Accept(this));
            List <VisitedExpression> columns = new List <VisitedExpression>();
            List <VisitedExpression> values  = new List <VisitedExpression>();

            foreach (DbSetClause clause in _commandTree.SetClauses)
            {
                columns.Add(clause.Property.Accept(this));
                values.Add(clause.Value.Accept(this));
            }
            insert.AppendColumns(columns);
            insert.AppendValues(values);
            if (_commandTree.Returning != null)
            {
                insert.AppendReturning(_commandTree.Returning as DbNewInstanceExpression);
            }
            _tableName          = null;
            command.CommandText = insert.ToString();
        }