Example #1
0
        public virtual String GenerateUpdate()
        {
            Command = new StringBuilder();
            Command.Append("UPDATE\n");
            Command.AppendFormat("\t[{0}]", this.TableAlias);
            Command.Append("\nSET\n");

            Command.Append(String.Format("\t{0}", String.Join(",", _updateSets)));
            Command.Append("\nFROM");
            Command.AppendFormat("\n\t{0} [{1}]", this.FullyQualifiedTableName, this.TableAlias);
            if (_whereClause != null)
            {
                Command.Append("\nWHERE\n");

                var visitor = new SqlExpressionVisitor <T>(Command, Parameters, Members);
                visitor.Visit(_whereClause);
            }

            return(Command.ToString());
        }